Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Sep 28, 2021 08:06 AM
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.
Solved! Go to Solution.
Sep 28, 2021 12:52 PM
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.
Sep 28, 2021 12:52 PM
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.
Sep 28, 2021 01:41 PM
Thank you very much. That’s quite a clever solution.