Advanced Filtering for Complex Formulas
Product update · Nov 15, 2021
In an effort to offer consistent filtering throughout all areas of Tadabase, we've recently added the ability to create filter groups, and filter using AND/OR in Complex Formulas.
Previously, when creating filter conditions with Complex Formulas, the filters could get unnecessarily long due to being restricted to using the AND operator.
When trying to filter for records where Status is Open or Status is blank, the filter conditions could look something like this:
Status is not In Progress and Status is not In Review and Status is not Blocked and Status is not blank
With the new filter functionality, we can now simplify these conditions to:
Status is Open or Status is blank
Advanced filtering is available for all Complex Formula fields:
- Count
- Maximum
- Minimum
- Average
- Sum