Barcode or QR Code Lookup

[antproberts]

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:

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

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.

[Suvrutt_Gurjar · Accepted solution]

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.

[antproberts]

Thanks I have been able to resolve this 🙂