In a form, the second column is the QR code scanner. (I’m using a uniqueID() for the key). I’m trying to get two other columns to auto populate once the qr code is scanned. When the qr code column is blank it doesn’t show up in the form (which is fine). I’m using the following formula:
ANY(SELECT(QR Codes[Campaign], ([QR_Code] = [_THISROW].[QR_Code])))
and in another column:
LOOKUP([_THISROW].[QR_Code], “QR Codes”, “QR_Code”, “Element”)
in the QR Codes table i have a list of the QR codes and the reference information in the columns “Campaign” and “Element”
Here’s the funny part. When I click the scanner button in the emulator and get the resulting 1111222333 code, the other columns show up with the correct information. However when I use my phone and an actual QR code, it scans the qr code fine giving me the same data as in the table, but the other columns don’t appear with the relevant info.
What am i missing?