I am looking to incorporate a type of vlookup/validation into a AppSheet form that starts by entering a large number (24 characters from an RFID tag), the focus jumps to the next field where the app looks into the Google Sheet table to determine if this entry is actually in the table and is associated with a product and/or an attendee. If the character string is in the table, then a checkbox would show a “Check” as a “Yes” validation. If not in the system, the app would force the cursor back into the previous field indicating a re-scan. The motivation is that often the speed of the scan by the operator can sometimes only capture a portion of the code. The full app objective is to replicate this again in the same form with another scan that reads another tag and then looks into a different Google Sheets table to confirm or not the second scan. If both scanned entries are valid, the form is submitted to a separate table and it resets to a fresh form to allow for the next entry. The process is highly repetitive and very fast.
Is this possible within the AppSheet build environment?