Global filter for all tables/views

[Pedro_Pais]

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.

[Kamille_Parks · Accepted solution]

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.

[Pedro_Pais]

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