Valid if

[Abanoub12]

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.

[Marc_Dillon]

Don't post your questions twice:

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/clock-in-and-clock-out/m-p/541615#M209177

[Abanoub12]

sorry but this is a different quotation 

[Marc_Dillon]

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.