Data tables
Filter, sort, and group
Build bounded AND/OR filter trees, apply ordered multi-field sorts, and group by text, single-select, or checkbox fields.
Updated
By Kition Docs
Verified against Kition 0.2.0 (7d49036f) on 2026-11-06
Filter with AND and OR groups
Open Filter and add field/operator/value conditions. A group combines its children with AND or OR. You can add one nested subgroup level: the root group and a nested group make the maximum depth of two.
There is no NOT group. Use field operators such as is not, does not contain, is none of, or has none of when the selected field type supports them.
Note
Filters update the active view as their configuration changes; there is no separate Apply button.
Operators depend on field type
Not every field type is filterable. document_link, link_to_record, lookup, rollup, formula, and button do not offer filter operators.
- Text, long text, and URL — is, is not, contains, does not contain, empty checks
- Number, rating, and auto number — equality, comparisons, and empty checks
- Date, datetime, created time, and modified time — equality, before/after bounds, and empty checks using a date value
- Single select and user fields — equality, any-of/none-of, and empty checks
- Multi select — has any, has all, exact-set comparisons, has none, and empty checks
- Checkbox — is checked or unchecked
- Attachment — empty or not empty
Sort by multiple fields
Add more than one sort rule. The list order is the priority order: Kition compares the first sort, then uses the next sort when earlier values compare equally.
Each rule can be ascending or descending. Remove or reorder rules in the Sort panel to change that priority.
Group by supported fields
Grouping is available only for text, single_select, and checkbox fields. You can add multiple group rules; they produce nested group headers in the configured order and direction.
Kanban uses a group field for its columns. Grid grouping renders group headers that can be collapsed.
Footer summaries
The footer reports the current record count. It also displays sum and average for up to three visible number fields that contain numeric values.
Test large operational tables with representative data and the actual view configuration.