Narrow what you see in a table without changing the underlying data. Filters and sort are view-level — they don't affect collaborators unless you save them as a shared view.
Sorting
Click any column header → Sort ascending or Sort descending. The column shows a small arrow indicator.
Hold
Shiftwhile clicking to add a secondary sort.Click a sorted column again to clear that sort.
The default order is the row insert order, which Y.js keeps stable across users.
Filtering
Click the Filter button in the table toolbar to add a filter. Each filter targets one column and uses an operator that matches the column type:
Type | Operators |
|---|---|
Text | contains, starts with, ends with, equals, is empty, is not empty |
Number | =, ≠, <, ≤, >, ≥, between, is empty |
Boolean | is true, is false |
Date / date range | on, before, after, between, this week, last 30 days |
Select / multi-select | is, is not, includes any, includes all |
URL / Email | contains, equals, is empty |
Filters combine with AND logic by default. Toggle the group to OR for either-or matching.
Clear and reset
The toolbar shows the current filter / sort state. Click the chip to edit, the × to remove, or Reset view to clear everything.
What's coming
Saved views — name a filter+sort combination and switch between them.
Per-user vs shared views — choose whether your filter only affects you or everyone.
Group by — collapse rows by a column value.
Aggregations — sum / average / count in the footer.