I am challenging myself to make an app using glide tables only as much as possible.
I am trying to make a walking tours app that has questions at each location.
For that I want to have a page for tour listings where the user can access some tour details and enroll in it (save it to their tours)
From their saved tours, they access the tour page and can trigger a start with a start time (tours have to be completed within 24h) and this will reveal the locations.
The page presents a list of locations where they can press to go into the location detail where they can find a way to get directions, some fun facts and a button that opens a form with the question and the answers.
At this point when they are writing the answer to the sheet through the form, I need to write the Enrolment ID, as it needs to belong to this specific entry.
The trouble I am having is not being able to get the enrolment ID at this point.
I’ve tried to illustrate things in the following images (I am naming static db something that only admins can add to and dynamic the ones where users can add stuff)
Am I missing something really obvious?