Advanced Filtering for Complex Formulas

Product update · Nov 15, 2021

Screenshot for “Advanced Filtering for Complex Formulas”

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

All updates · Everything since 2019