Barcode or QR Code Lookup

AppSheet AppSheet Q&A
, , ,
1

I am trying to get my app to lookup the value for the employee detail via a barcode or QR Code. Lookup is not working niether is Any () Select ()

I have a timesheet table which is where the lookup UX is based.

I have an employee table which is where the employee detail is based.

Employee ID is the unique code for the lookup and System ID is the field I wish to be returned.

Here is the detail on the lookup:

antproberts_0-1660607354451.png
antproberts_0-1660607354451.png736Ă—292 22.8 KB

Barcode scan will populate the below field with the system id from the employee table.

antproberts_2-1660607501670.png
antproberts_2-1660607501670.png262Ă—254 2.83 KB

Please can someone let me know where I am going wrong? I am placing the formula in the intial value section for the column as when I put it in the app formula section the field disapears from view.

2

Pleas try

LOOKUP([_THISROW].[Employee ID], “Employees”, “Employee ID”, “System ID”)

LOOKUP() - AppSheet Help

Please take a look at the Troubleshoot section in the above article.

1 Like
3

Thanks I have been able to resolve this :slightly_smiling_face:

2 Likes