Filtering on Free-Text Fields

Filters for text-driven fields are not automatically generated. Generally isn't a reason to filter on free text. Free-text fields can store unlimited variations of a single response. Typically exports are all you'll need for a free-text field. However, there may be occasions where you wish to query on very specific text. This can be accomplished using Subquery Filters.

Formula (Aggregate)

One approach is to use a "Formula" Aggregate filter:

inline-418202563.png

Comparison (Aggregate)

Another way is to use "Comparison" Aggregate filter:


inline-1848225005.png

In this example, a literal export was added to check against a specific school name ("An Example School").‚Äč

Was this article helpful?
0 out of 0 found this helpful