Hello,
I have two tables: one for the time in and the other for the time out.
two primary views clock in (data table is time in) and clock out ( data table is time out ).
columns contain employee IDs using a scan QR code.
I want to commit users only to scan their QR code, not others.
please help me.
Thanks in advance.
Don’t post your questions twice:
https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/clock-in-and-clock-out/m-p/541615#M209177
sorry but this is a different quotation
Lol. Indeed it is, so different…
What’s the point of having them scan a QR code, if they can always only scan a single one? Why not just use their USEREMAIL() to autofill the record?
But if you must, you’ll just need to specify a valid_if expression that uses USEREMAIL() to check against a table that holds emails paired with qr codes.
