Filter, Sort, Group
Filters, sorting, grouping, row colors, and frozen columns are view-specific: you can set up different configurations for each view without affecting any other view.
Filtering
Section titled “Filtering”Filters show only entries that meet certain conditions.
Adding a filter
Section titled “Adding a filter”- Click Filter in the top-right corner
- + Add filter
- Choose column → operator → value
AND / OR logic
Section titled “AND / OR logic”Multiple filters default to AND logic. Between any two filter rows an AND / OR pill appears — click it to switch all filters to OR. The logic applies globally to all filters in this view.
Available operators by type
Section titled “Available operators by type”| Column type | Operators |
|---|---|
| Text / URL / Email | contains, does not contain, is, is not, is empty, is not empty |
| Number / Rollup | =, ≠, >, <, ≥, ≤, is empty, is not empty |
| Date | is, before, after, is empty, is not empty |
| Select | is, is not, is empty, is not empty |
| Multi-Select | contains, does not contain, is empty, is not empty |
| Checkbox | checked, not checked |
| Relation | linked, not linked |
Sorting
Section titled “Sorting”Sort rows ascending or descending by one or more columns. Multiple sort rules are applied in order — the first rule takes priority.
Adding a sort
Section titled “Adding a sort”- Click Sort
- Choose column and direction (ascending / descending)
- + Add sort for a secondary level
Grouping
Section titled “Grouping”Grouping organises rows by a column — as sections in the table or as columns in Kanban.
Supported column types for grouping
Section titled “Supported column types for grouping”- Select
- Multi-Select
- Checkbox
- Date (by day, week, month)
- Assignee
Enabling grouping
Section titled “Enabling grouping”Click Group → choose a column. Each group shows the entry count and can be collapsed or expanded.
Hiding columns
Section titled “Hiding columns”In table view you can hide columns without deleting them:
- Click Fields
- Deactivate the columns you want to hide
Hidden columns remain visible and editable in the row detail view.
Freeze columns
Section titled “Freeze columns”Frozen columns stay pinned on the left while you scroll horizontally — useful when you have many columns and always want the name or first column visible.
Freezing a column
Section titled “Freezing a column”- Click the column header of the column up to which everything should be frozen
- Choose Freeze column
- All columns from the first up to and including this one are pinned
To unfreeze, click the frozen column header → Unfreeze.
Row colors
Section titled “Row colors”Row colors highlight specific rows — based on conditions you define (e.g. mark all rows with status “Urgent” in red).
Setting up color rules
Section titled “Setting up color rules”- Click Color in the toolbar
- + Add color rule
- Choose column → operator → value → color
Multiple rules are evaluated in order — the first matching rule determines the row’s color.
Table search (⌘F)
Section titled “Table search (⌘F)”Press ⌘F (Mac) or Ctrl+F (Windows/Linux) to jump directly into the table search field. The table filters all rows that contain the search term in any cell — without saving a filter.
Aggregations (Column Footer)
Section titled “Aggregations (Column Footer)”The table view has an aggregation row at the bottom — below the last data row, marked with a ∑ symbol on the left.
Setting up an aggregation
Section titled “Setting up an aggregation”Click any cell in the aggregation row to open the menu. Choose the desired aggregation — the value is calculated and displayed immediately.
Available aggregations by column type
Section titled “Available aggregations by column type”| Aggregation | Description | Available for |
|---|---|---|
| None | Disable aggregation | all |
| Count | Total number of rows | all |
| Empty | Number of empty cells | all |
| Not empty | Number of filled cells | all |
| Unique values | Count of distinct entries | all |
| Sum | Sum of all numeric values | Number, Formula, Rollup, Rating, Auto-number |
| Average | Arithmetic mean | Number, Formula, Rollup, Rating |
| Min | Smallest value | Number, Formula, Rollup, Rating |
| Max | Largest value | Number, Formula, Rollup, Rating |
| Earliest date | Earliest date | Date, Created at, Modified at |
| Latest date | Most recent date | Date, Created at, Modified at |
| Checked | Number of ticked checkboxes | Checkbox |
| Unchecked | Number of empty checkboxes | Checkbox |
| % Checked | Percentage of ticked boxes | Checkbox |
Formatting
Section titled “Formatting”Aggregation values for number and formula columns are displayed using the configured column format (currency, percent, decimal places).
Persistence
Section titled “Persistence”Aggregation settings are saved per view — each view can have its own aggregations, and they persist after reloading.
Multi-Select & Bulk Edit
Section titled “Multi-Select & Bulk Edit”In the table view you can select multiple rows and edit them at once.
Selecting rows
Section titled “Selecting rows”- Click the checkbox at the far left of a row
- Select all: Click the checkbox in the column header
Bulk editing
Section titled “Bulk editing”When rows are selected, a floating action bar appears at the bottom of the screen:
- Choose a column from the dropdown
- Enter the new value
- Click Apply — all selected rows are updated
Bulk delete
Section titled “Bulk delete”Click Delete in the action bar → confirm the dialog. All selected rows are permanently deleted.
Resetting a view
Section titled “Resetting a view”Click Filter / Sort / Fields → Reset to restore all configurations of a view to their defaults.