Filter to update multiple elements/grids

[Lindsay_Patross]

I have 3 tables - projects, tasks, shows

Records in projects and records in tasks are linked to shows.

I'd like to have an interface where I can see all of the projects and all of the tasks related to a show on the same page.

Is there a way to use the filter = show name, to then show a grid of the projects and a grid of the shows with that show name?  

[bruceconsulting]

Hi Lindsay,

In your last paragraph, do you mean a grid of the projects and a grid of the tasks with that show name?  If so, you can create a interface starting with a blank layout.  Insert a grid element and choose your show table.  You can show/hide fields in that grid and also use a filter to choose the show name.  

I have an example using a clients table, but you can do the same using your show table.

If you want to talk about this further or if you ever need additional help, please schedule some time with me.  Here's my Calendly link: https://calendly.com/d/zy2-jb4-q6z/30-minute-help-meeting

Jody

[TheTimeSavingCo]

Hm, if I'm understanding you right,  the records in "Projects" and "Tasks" are linked to "Shows"?  If so, you could solve this with a record picker element and selecting the tables you want like so:

Resulting in:

Link to base
Once you duplicate the base you'll be able to modify the interface as well to see how it's set up too

[Lindsay_Patross]

Thank you. I didn't realize there was a difference between the filter and the record picker. 

[Lindsay_Patross]

Question on this one - is there any way to be able to add projects/tasks in this interface? 

[TheTimeSavingCo]

Sort of, you'd need to use a button element with a "Run an automation" action, and it would run an automation that would create either a project or a task linked to the currently selected show