I have a simple AppSheet app that includes two tables: a checkout table and a student data table. Both tables have the following columns:
Unique ID, Student ID, First Name, Last Name, Grad Year, TimeNow.
I created a reference column in the checkout table's Student ID column that refers to the Student ID in the student data table. This allows me to enter a Student ID number into the checkout table/form, and all the corresponding student information is automatically written into the checkout table along with the timestamp of the action. This functionality works well. I can use a barcode scanner too that simply reads the text and enters it into the field / column
However, the issue is that I currently have to click on the Student ID field in the form and either select a student from a dropdown list or manually enter the Student ID number into the search bar. What I would like is for students to simply scan a barcode into the checkout form, have the data saved automatically, and then allow the next student to do the same. The app wonโt work for our needs if someone has to use the dropdown, search, or select from a list.
Iโve already set the app to auto-save and auto-reopen, but I still need to click into the field and either search or select from the list. Any help or suggestions to achieve this barcode-scanning functionality would be greatly appreciated.
LinkedIn
Twitter
