Issue Summary: I am building a high-volume event check-in app. I have a Check In Logs table with a Ticket ID column that is a Ref type pointing to an Attendees table.
The Goal: I want the bouncer/operator to open the form and have the QR scanner launch immediately. I want to completely hide the dropdown list of registered attendees. It is distracting and slows down the process. I only want the scanner to be used.
What I have tried:
-
Setting the Input Mode to “Scan” in the column settings.
-
Toggling “Scannable” to ON.
-
Using
CONTEXT("ViewType") = "Form"in the Show? property (this made the field disappear entirely). -
Using
LIST()in the Valid_If to try and empty the dropdown (this often blocks the scan from being valid).
Technical Constraints:
-
I must keep the column as a Ref type because I have Google Apps Script logic that relies on that connection to pull guest names and send confirmation emails.
-
I need the security logic (GPS check and Duplicate scan check) to remain active in the
Valid_If.
Question: Is there a way to “Ghost” or disable the UI dropdown element specifically for a Ref column without breaking the data connection or the validation logic? How do I force AppSheet to treat the field as “Scan-Only” and ignore the manual selection list?
