I have a database of people who are taking part in a series of activities over a couple of months.
In Airtable I have two tables - one which has all of their information (contacts etc) - and another which is the schedule. I have allocated individuals to the different activities in the schedule by creating linked tables.
I would like to produce an Interface (I think in the Record Review format) that allows me to select an individual from the list on the left. On the right I would like a Calendar to appear that is bespoke to them. ie. it shows them only the activities that they have been allocated to.
At the moment the only way I can do it is to create an additional filter on the Calendar but is there anyway to bypass this step and just use the names on the left to do the filtering automatically?