QR Code Valid if

[atyka]

Hi,

First table is "customers list" with a code >qr code
Second table is "input" form with a code (to scan) and a NOW() field

Target is, with the "valid if", in second form, when we scan a qrcode : two check : is this code existing in first table (if yes, ok), is this code was already scan (if yes wrong, if no, ok).

For the first step, I tried
IN([_THIS],Data[COD])

but it's strange, it seams work sometime but not everytime....

I search since 2 days now....

[atyka]

New step :

Checking n°1 is working but we need for the first imput choose in the list and save and after scanning is working, if not, we received error : "the scan result didn'r match any known entries"

[Steve · Accepted solution]

AND(
  IN([_THIS], Customers List[Code]),
  NOT(IN([_THIS], Input[Code]))
)