Filtering Table Views to a Relation control that changes on each copy of a page

I’m working on a main page and bunch of subpages that contain tables, which will be used to coordinate an event. We run multilpe events, so I’ve set up a relational select list to choose the right event (pulled from a master event table) on the main page, so date references, buttons, and automations reference the selected event. I’ve set up a duplicate page button on the main page too, that creates copies of each page and subpages for each next event, and views of each of the tables (not duplicate data).

How do I add a filter to all my tables, so that it connects to the new selection on the new main page that gets created, (not the original one)? How do I set up my tables so when I’m updating table trackers, filling in specific event info, it’s not updating the master table or all the connected views?

Thank you!

1 Like

Woah… this is a deep but at the same time I am confused by what you are trying to achieve.

First… why would you duplicate pages for each event when you can filter the information that is displayed on that page (views of base tables or even base tables if that’s your flavor) using a control.

”How do I add a filter to all my tables, so that it connects to the new selection on the new main page that gets created, (not the original one)? How do I set up my tables so when I’m updating table trackers, filling in specific event info, it’s not updating the master table or all the connected views?”

I am confused by this part. Do you have a dummy doc or if you wnat we can jumpon a meet call and I could have alook to actually understand what you are trying to achieve (all free ofc).

1 Like

Thank you so much for your response. I would love a call to go through what I’m looking to achieve! I am open to taking any approaches; really just need to get this working for my team.

1 Like

If you move away from pages to canvas columns, you can use the parent link to automatically filter the table on the canvas column to the name of the row in which the canvas column is.

P

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.