Can Barcode Scan return Sheet Data and Auto Complete Form?

Geez

Hi!

Help!!

I'm working on a Sheet to help with our Kanban System.

As an employee takes a part from the Kanban Bin, we would them like to scan a QR code of the part taken via a form and the barcode reader on his smart phone, we have set up a test sheet using a lookup table of all parts (on a separate sheet "inventory") then used a vlookup in a "parts used" sheet to return the information relating to the part so this can be reordered. All this works fine... However it would be ideal if the form autofilled with the same information held in the lookup "inventory" sheet so that the employee could check the description matches the part used.

Q Can the form autofill or show the part description that the Vlookup returns in the sheet, at the point the QR code is scanned? I.E. Scan code, form auto fills with matching part description, Check, Add Quantity, Send?

Many Thanks

G

Andrée Starå

Hi G,

Unfortunately, it's not possible at the moment because there isn't any communication between the form and the sheet, but it's a great idea!

Please submit an Enhancement Request when you have a moment.

There are third-party tools that can do it and they also integrate with Smartsheet.

Is that an option?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Shaine Greenwood

Hi—

This might take a little work on your end to set up multiple different forms, but you could consider creating query strings and tying them to your barcodes: https://help.smartsheet.com/articles/2478871-url-query-string-form-default-values

The flow I'm imagining is this:

1. Someone scans a barcode in the mobile app search field (as opposed to in a form)
2. They're taken to the relevant row in a sheet that has form links for all parts, they tap the link to the form for their part (search will present that row to them in the app)
3. That link, using query strings, autofills all of the necessary info in form fields
4. They confirm the info is correct and tap Submit.