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.
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.