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
Status is not In Review
Status is not Blocked
Status is not blank

With the new filter functionality, we can now simplify these conditions to:

Status is Open
Status is blank

Advanced filtering is available for all Complex Formula fields:

  • Count
  • Maximum
  • Minimum
  • Average
  • Sum