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.
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.
This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.