DISPLAY
Filters
Filters let editors define a precise table view and decide how much control readers have over it. Unlike quick search, filters are typed rules that determine which rows are included in a table. New tables open in Filter mode by default; an explicitly saved Search mode remains in place.
Build a focused view in three steps
Create the rules in the preview, check the rows that remain, then decide whether readers should be able to refine the filters further.
- 1
Create a rule in the table
Enable Filter bar in Display settings. Switch the table bar to Filter and select Add filter. Choose the column, operator, and value or values to match. Apply the filter. The rule appears as a chip that you can edit or remove.
- 2
Save a default view
Enable Filter bar and choose Filter as the default view. Build the rules in the live macro-settings preview, then save the macro. Saved rules apply to new rows too; reader changes remain local.
- 3
Hide the saved filter from readers
After saving at least one rule, you can hide the filter bar for readers. The rules continue to run, but readers see only the filtered result. A compact search remains available for finding text within that result.
Tip
Use filters for deliberate, column-specific conditions. For quick text lookup in the current view, search is a better fit; both tools can work together.
The rule follows the data type
Simple Tables offers only the operators that fit the selected column type. That keeps conditions understandable and results reliable.
| Column type | Rules | Use it for |
|---|---|---|
| Text | contains · does not contain · is · is not · is empty | Find titles, names, IDs, or free text. |
| Selection and Yes/No | is any of · is none of · is empty | Choose multiple statuses, categories, or boolean values. |
| Number | equals · greater/less than · at least/at most · between | Narrow amounts, quantities, percentages, or scores. |
| Date | is on · before · after · between | Use suggestions for Today, last 7 or 30 days, this month, or last month. |
Combine conditions with AND and OR
Use groups when the logic needs more than a simple list of conditions. Inside each group, choose All or Any; between groups, choose AND or OR.
All / AND inside a group
Status is Open AND due date is in the next reporting period. A row must satisfy both rules.
Any / OR inside a group
Priority is High OR Priority is Critical. A row matching either value is included.
Groups for parenthetical logic
Create separate groups for expressions such as (Team is Support OR Team is Success) AND Status is Open.
Group rules
Groups are one level deep: rules inside a group use All or Any; groups themselves connect with AND or OR. Groups cannot be nested.
Editor-only data stays out of saved filters
Saved rules cannot use values from columns that readers should not see.
Invisible and Incognito columns are unavailable when building saved filters in macro settings. A confirmed page editor can use a hidden column in a personal filter while viewing the page. That choice is never saved for readers.