Filters & Sorting
Filtering Data¶
Filters help you focus on specific records by showing only those that match your criteria.
Adding a Filter¶
- Click the Filter button in the toolbar
- Select the field to filter by
- Choose the operator (equals, contains, etc.)
- Enter the filter value
- Click Apply
Filter Operators¶
| Field Type | Available Operators |
|---|---|
| Text | Equals, Contains, Starts with, Ends with, Is empty |
| Number | Equals, Greater than, Less than, Is empty |
| Date | Equals, Before, After, Is empty |
| Select | Equals, Is any of, Is empty |
| Checkbox | Is true, Is false |
| Relation | Equals, Is empty |
Multiple Filters¶
Combine multiple filters to narrow down results:
- All filters are applied with AND logic
- Each additional filter further restricts results
Removing Filters¶
- Click the X on individual filter chips
- Click Clear all to remove all filters
Sorting Data¶
Sorting determines the order records appear.
Adding a Sort¶
- Click the Sort button in the toolbar
- Select the field to sort by
- Choose ascending (A-Z, 0-9) or descending (Z-A, 9-0)
- Click Apply
Multiple Sorts¶
Add multiple sort levels:
- First sort is primary
- Subsequent sorts apply within groups of equal values
Quick Column Sorting¶
Click any column header to sort:
- First click: Ascending
- Second click: Descending
- Third click: Remove sort
Saving Filter and Sort Settings¶
Filters and sorts are saved with the view:
- Configure your filters and sorts
- Click Save to update the current view
- Or click Save as new view to create a variant
Related¶
- Table Views — group by feature
- Views Overview — building and managing views