I’m obviously missing something basic regarding relations columns. Most frustrating is that I’m sure I had this working correctly a few months back. And then I rebuilt my app as I was learning new things and I just can’t get back to where I was.
Sheet 1 - list of event names, descriptions, logo, venue, etc. - 1 row per event.
Sheet 2 - dates of these activities, start time, end time, etc. Many to one relation as there are many dates to one event.
I have created a relation column on each sheet using the unique event name as the matching field so that I can reference information in both directions.
I am successful in adding calendar information to an Event List tab’s detail page using the relation column as the source for that component.
And I have created a basic calendar tab without problem.
However, I can’t seem to build the detail page behind each calendar listing because I can’t get the calendar and event sheets to connect.
I have attempted to create the Calendar tab by two methods:
- use the calendar sheet as the data source and hope the relation column will access some info on the event sheet
- use the event sheet as the data source and hope the relation column will access some info on the calendar sheet.
No matter which direction I go, I can’t seen to get these 2 sheets to talk to each other to create a click-through detail sheet from the calendar listing that allows me to build components from both the event and the calendar sheets.
Any help is appreciated.