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.
DISPLAY
A filter view has three parts
Start with one condition, combine it with more rules when needed, then save the selection as the default view. The source and the table values stay unchanged.
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.
Groups are one level deep: rules inside a group use All or Any; groups themselves connect with AND or OR. Groups cannot be nested.
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.
| Type | Available rules | Use it to |
|---|---|---|
| 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. |
Build a focused view in four steps
Create the rules in the preview, check the rows that remain, then decide whether readers should be able to refine the filters further.
Create a rule in the table
- 1 Enable Filter bar in Display settings.
- 2 Switch the table bar to Filter and select Add filter.
- 3 Choose the column, operator, and value or values to match.
- 4 Apply the filter. The rule appears as a chip that you can edit or remove.
Use the appropriate operator
Available operators depend on the column type. Text supports contains and empty checks; enum and boolean values support multiple values; numbers support comparisons and ranges; and dates support before, after, on, and ranges with suggestions such as Today and Last 7 days.
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 are evaluated against new and existing rows whenever the table loads. Reader changes remain local; only changes in macro settings update the saved default view.
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 and cannot change or remove the conditions.
The published view retains a compact search for text lookup within the already-filtered result. That search does not remove the saved filter.