Have a Front-end user input form for the build technicians to use during build to enter data (must be simple and fool proof). Have a single database that records all these measurements.So my situation is that I need to see if we can achieve the following: Of course for a long time, it has been realised that the right way to do this is to use a database to store the info and utilise forms as the data input “front end”. Maintaining the template and updating all the live build cards is an enormous task, involving duplicating current build cards, creating a new replacement if the template has been updated and then copy/pasting all data from current to new. We do some meta-analyses of the data, but it involves using “trick” ways to pull data out of all the individual files. So we end up with lots of individual spreadsheets of data…but not interconnected (well not very well). The spreadsheet becomes a standalone file containing all data pertaining to that build. We call these our build cards.Ĭurrently, we use an Excel spreadsheet to create a template for the build cards with lots of inputs for the Build Technicians to input data. Our high precision products need accurate records of lots of aspects during assembly. We are a small manufacturing company, building products that require recording of build measurements/data during manufacture. I am researching into whether Base can be used to suit our needs.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |