App to Scan Multiple QR Codes In Single Transaction?

AppSheet AppSheet Q&A
1

I’d like to create an app for tracking the transfer of products. Every box has a unique QR code, and we have a limited number of destinations. Here’s the workflow we’d like… can this be done with AppSheet

  1. Select destination by name from a defined list of options.
  2. Scan one or many QR codes (usually it’s 20-50). Each code would contain the product type, batch/lot number, and unique serial number.
  3. Submit all data to a table that would have a transaction ID, date submitted, destination, and QR code data (one line for each QR code scanned).

Can I do this in AppSheet?

2

Yes you can @liftedspirits

1 Like
3

More specifically, you’ll have a table of scans that are children of the destination table with the REF set to isapartof

1 Like
4

An example of the “repeat scan” part of here.
https://www.appsheet.com/samples/An-app-that-repeatedly-scans-barcodes?appGuidString=42fd12f1-16db-4939-90b2-1f215ebff4b7

As @Grant_Stead indicated, you then need to set up the parent table and child table (as inpartof) so you refer back to the parent data in the child records.