Good day all,
I would like to create an app where I can easily choose from a list of events, then see a list of searchable names and scannable IDs that when selected would automatically add that event title to the list of names and IDs. I got so far as to create two tables: (1) Student List with Student Name, Student ID, and Events Attended (Referencing the Events Table) and (2) Events List with one column for Event Title (someone could easily add more events of which they can choose).
I used the Events List as a card view with the hope that when you click on the Event Title it would pull up the Student List and I could create a button that would somehow add that event to their name showing that they attended. But I can't seem to get that list. I loved the Class Attendance template app and tried to mess with that, but it was not close enough to how I wanted this app to function and made it a bit harder to work backwards towards my goal. It worked off a list of names that were preassigned to courses.
Also, I wanted it to be as automatic as possible and attempted a form that would update the list after a quick ID scan, autosave and auto advance (or renew), but it required that I pick an event in the column each time.
I am a newbie when it comes to referencing tables and creating parent-child relationships, and figured this is my missing link (pun intended) and hoping to get some direction.
Thank you appsheet community!
LinkedIn
Twitter
