I’m building an app that tracks the continuing education of about 1000 employees. We already have a spreadsheet of names that could be copy/pasted into our new app spreadsheet, and quickly given Unique IDs by putting S10001 in A2 and dragging down.
I would rather use S10001, S10002, S10003 than a UniqueID(), because it looks prettier on the QR code badge that will be generated for each student to check themselves in.
I can add new Employees in AppSheet by finding the latest ID and adding 1, and that works. But when I try to use SELECT or LOOKUP functions to reference students by ID, nothing works. I get the name of the first student in the list, regardless of the ID I’m referencing. I feel like there’s a TRUE or FALSE I’m missing in one of those functions.
Any ideas on how to make this work, or a different, better approach all around?
Thank you for your reply. You know, after a lot of refreshing, and Regenerating Schemas, and clicking things just to get the Save button to light up on every single view, I got it working as expected. Am I nuts, or does it take AppSheet a lot of effort to clear its cache and update all your (even minor) changes?
Either way, the form IDs reliably increment from F10001 to F10002, 03, 04, etc.. and my Google Sheets references are all now working as expected.
Thank you again. I see you a lot on this forum, and I appreciate your effort.