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?