This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Validate a Scanned QR code and remove drop down selection

Posted on 01-31-2020 05:54 PM
Mike_T
New Member
Reply posted on --/--/---- --:-- AM

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 Solved
0 5 1,037
Topic Labels
Jump to Solution
0 Likes
1 ACCEPTED SOLUTION

Posted on --/--/---- --:-- AM
Steve
Platinum 4
Platinum 4
Reply posted on --/--/---- --:-- AM

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.

View solution in original post

Jump to Solution
5 REPLIES 5
Top Labels in this Space