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, Between, Is empty |
| Date | Equals, Before, After, Between, 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