Skip to main content

Record Filters

Record Filters narrow the records in one Data Type. They do not select Members or Chats. The filter editor uses that Data Type's fields and the saved-filter selector lists filters for that Data Type.

This guide applies to Data Types that store records. Public Forms have a separate, read-only submissions table and do not offer these saved record filters.

Filter Records​

  1. Open Data and select the Data Type.
  2. Open its Records view.
  3. Expand the condition row with Edit.
  4. Add conditions using the fields, operators, and values offered by the editor. Use AND or OR groups when the conditions need to be combined.
  5. Review the matching records as the list updates. Changing a condition returns the table to the first page.

The search box searches External ID, the name of the Member who owns the record, and the text of every field you can read; a field marked Admin only is searched only for admins. To filter by a field's value with operators, use the condition editor. To find the records one Member owns, add an Owner condition and pick them by name, or type their Member ID if you cannot open the Member directory. Record reference fields are not searched. The page number is kept in the page address; the search text is not. When nothing matches, Clear filters returns to every record.

Records created by test runs are hidden from All records (some records from older test runs may still appear); choose Test records from the filter menu to see them. Export includes all records.

Save and Reuse a Filter​

  1. Add complete conditions to the records view.
  2. Choose the Save control, enter a filter name, and confirm with the checkmark.
  3. Select the saved filter from the filter selector when you return to the Data Type.

When a saved filter is selected, change its conditions and choose Save to update that filter. Choose All records in the selector to return to the default view.

Reading records and saving filters have different permissions. You can select an available saved filter with access to read records; saving requires permission to write records. If the Save control is absent, ask your workspace administrator about your access.

  • Data Types — define the fields and record scope of a Data Type.
  • Member Filters — select Members, including conditions involving their Data Type values.
  • Chat Filters — select Chats.