Skip to main content
Question

Using a barcode scanner to associate multiple existing child records to a parent record.

  • May 3, 2021
  • 0 replies
  • 409 views
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
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+14

If you can run an edit API call, and an Add API call from a scan, then I think I have a way. But I am not sure how it would work because an add api call allows you to reference fields from the table you launch from, and I do not know how the system could know what table you are launching from when using the barcode scan.

Let me know if you find out if it's possible and I'll type out the rest of my idea.



------------------------------
Mike Tamoush
------------------------------
MarkShnierYou
Forum|alt.badge.img+22
  • MarkShnierYou
  • Quickbase Alumni
  • May 4, 2021
Ben,
I believe that this is possible to do, and I could demo parts of apps that use the required techniques to explain how it would work.

But to get it working, we would need to have a few zoom sessions to get it working, so you would need to have some kind of budget to work with.

Contact me directly by email if you want to work though this together.

Mark

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
  • ScottBurdayTr
  • Quickbase Alumni
  • May 5, 2021

Ben,

While the Quickbase mobile app can scan a barcode and put it into a field, most barcode scanning needs a process behind it to enable workflows that take place after scanning any barcode.  So, scan a barcode and then a workflow process occurs that automatically takes the user to the next step.  This is always custom development to enable these processes. 

Trinity has been developing custom barcode driven workflow processes for our clients for 23 years and in Quickbase for 17 years. Our team has developed processes just like you describe above.

The productivity and accuracy that comes from barcode scanning is amazing.  Either workstation based with USB connected scanners or mobile Android / iOS devices using the camera as a barcode scanner can greatly improve operational capabilities.  If you would like to get hold of Trinity for us to show you some of the many barcode driven workflow processes that we have developed please connect with us at  info@trinityis.com  We would welcome the opportunity to solve this for you.

Thanks.



------------------------------
Scott Burday, Trinity
------------------------------
  • SouheilKaram
  • Quickbase Alumni
  • May 7, 2021
Hi Ben,
Take a look at this mobile application I setup. It solves exactly what you are looking for. I used my kitchen cabinet as a pallet and the stuff in it as my parts on the pallet. to use:
1 - install the pic2shop pro from apple store or google play. you will need to spend about 26 $$ one time purchase. It is worth it because you can use the app with many users you want 
2 - use you camera to scan the barcode below
3 - enjoy, and reach out if need to customize accordingly.





------------------------------
sckaram sckaram
------------------------------
Terms & ConditionsAccessibility statement