Help

Global filter for all tables/views

Solved
Jump to Solution
303 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Pedro_Pais
6 - Interface Innovator
6 - Interface Innovator

Is there any good workaround to specify a global filter that applies to all shown tables or views? The idea is that a user needs to work with multiple tables/views and applying a filter to each of them (changing customer, for example) is quite cumbersome. Any ideas?

The alternative we are using is using a different base for each customer, but that doesn’t seem very efficient and requires to apply changes in multiple bases.

1 Solution

Accepted Solutions

If the relevant tables are linked to Customers, you can add a checkbox field to the Customers table, and lookups of that checkbox field in the related tables. That way you can have a view on each table with a simple filter: “where Checkbox field is checked”. Anytime you want to filter all the tables, just change which customer(s) have the checkbox.

See Solution in Thread

2 Replies 2

If the relevant tables are linked to Customers, you can add a checkbox field to the Customers table, and lookups of that checkbox field in the related tables. That way you can have a view on each table with a simple filter: “where Checkbox field is checked”. Anytime you want to filter all the tables, just change which customer(s) have the checkbox.

Thank you very much. That’s quite a clever solution.