Barcode Help - Scan a barcode and it auto checks a box in Smartsheets

Jessica_Sabin

Hi Smartsheet Community!

I have a smartsheet where I want to scan a barcode and it auto checks the box as received. The Employee ID column lists the numbers associated with each barcode. The Present column checkbox is what I would like clicked when the barcode is scanned using the Smartsheet mobile app. I know I need to create a column with a formula to identify when the barcode is scanned and highlighted in the Employee ID column, it checks the checkbox in the Present column but I can't figure out the formula. Any help anyone can provide is greatly appreciated. 😊

Jason Tarpinian

All the barcode scanner does is recognize the # associated with the barcode and fills in a field with that number, it can't do a lookup into a table as your asking to auto-check the adjacent cell. Maybe though you could use a form, and scan the barcode for the "Employee ID" field, and have "Present" as a second hidden field in the form that is auto-checked after submitting? And if you're doing something like taking attendance, update the form settings to reload the form after submitting so you can go ahead and scan the next person.