Advanced Filtering for Complex Formulas

Snag_6fb726ef.png

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