Iโm trying to force the user to enter the info into the form using a QR code only. At the same time, I want the user to be given an error message if the QR code has already been scanned. (I.e. โThis QR Code was scanned on XXX date by XXXX personโ. Both of these pulled from another table.
Iโve used REF as my column type but this allows the user to view and select the QR code from a drop down menu. Thoughts?
Solved! Go to Solution.
It appears in your case a valid code is one that does not occur in another table. Try a Valid If expression of:
NOT(IN([_THIS], another-table[qrcode-column]))
replacing another-table
and qrcode-column
appropriately.
You can the use the Invalid value error expression to generate an appropriate error message.
It appears in your case a valid code is one that does not occur in another table. Try a Valid If expression of:
NOT(IN([_THIS], another-table[qrcode-column]))
replacing another-table
and qrcode-column
appropriately.
You can the use the Invalid value error expression to generate an appropriate error message.
Nevermind, seems to be working fine now after a couple closed apps and resyncs. Thanks again!
I tried your suggestion but it didnโt work.
This badge # exists in the โother tableโ. Itโs been awhile since this post. By any chance do have another solution?
Thank you.
Disregard Steve I found another post that you were in and your solution worked!
Thank you, Sir!
This works however just using the default error message locks up the app. Not able to rescan, cancel or save. Canโt even go back to earlier screen. bug?
User | Count |
---|---|
33 | |
29 | |
29 | |
20 | |
18 |