Manage forms: Filters and ranges

• 2 minutes

Basic filters and ranges

It’s easy to limit the data that shows in a form. Filtering is most commonly done in list pages, which use grids, but can be used anywhere.

Select the drop-down to the right of a field and notice your options for sorting and filtering.

The filtering criteria options are: is exactly, is not, contains, does not contain, begins with, is one of, after, before, and matches.

You can’t do multiple levels of sorting on the basic sort, by sorting multiple fields. You can use multiple ranges.

Advanced filter

To use the advanced filter, Select Options, then Advanced filter or sort.

The resulting screen will allow you to modify the query used in the form by:

• Specifying a range for fields

• Specifying sorting

  Note

  here you may specify multi-level sorts

• Adding datasources via joins

You can also save the query for future use, and it will be available until user data is cleared.