BenKrieger
4 years agoQrew Member
Using a barcode scanner to associate multiple existing child records to a parent record.
I am trying to integrate barcode scanning into the app I am developing in order to track and manage the manufacturing process at my companies manufacturing plant. The plan is for each part to be assigned it's own unique QR code (essentially representing the unique record ID of each part in quickbase) and to scan that QR code at each stage of the production process to ensure that every part is tracked as it moves through the plant. Eventually all of the parts are put onto a pallet before being shipped out.
I am currently looking for a way to streamline the palletization process. In my app I have a Pallet table that is the parent table to the Parts child table. The way I imagine the process working is that each pallet will have a QR code which, when scanned, would allow a user to scan the QR codes for all of the parts that are going on that pallet and then clicking a save button that would relate the scanned parts to that pallet.
I'm imagining this could be done using the Quickbase API using something similar to the "add child record" button that is automatically created in the parent table when creating a relationship, but instead the "button" would be a scan and instead of creating a new record it would update the "related pallet" (the parent record) field of the exiting part records for all parts scanned prior to clicking the save button.
------------------------------
Ben Krieger
------------------------------
I am currently looking for a way to streamline the palletization process. In my app I have a Pallet table that is the parent table to the Parts child table. The way I imagine the process working is that each pallet will have a QR code which, when scanned, would allow a user to scan the QR codes for all of the parts that are going on that pallet and then clicking a save button that would relate the scanned parts to that pallet.
I'm imagining this could be done using the Quickbase API using something similar to the "add child record" button that is automatically created in the parent table when creating a relationship, but instead the "button" would be a scan and instead of creating a new record it would update the "related pallet" (the parent record) field of the exiting part records for all parts scanned prior to clicking the save button.
------------------------------
Ben Krieger
------------------------------