Base
Views and filters
A table can have multiple views, each with its own filters, sorting, grouping, and visible columns.
Create an open-request view
- Open
Tutorial Base→Requests. Click the plus beside the view tabs and select 【Grid view】. - Right-click the new tab, choose 【Rename】, enter
Open Requests, and press Enter. - Open 【Filter】 → 【Add condition】 and set
Statustois Open. - Open 【Hidden fields】, hide
Notes, and close the panel. - Switch to
All Requeststo see all four records, then return toOpen Requeststo see the two open requests.
Sort and group
This example uses a numeric Priority field with the values 1, 2, 3, and 4.
- In
All Requests, open 【Sort】, selectPriority, and keep ascending order. - Open 【Group】 and select
Status. Records appear inDoneandOpengroups. - Click the arrow beside a group to collapse or expand it.
- Reopen the grouping panel and delete the condition. The flat list keeps its
Prioritysort.
Find a missing record
Confirm the table and view, then check filters, field values, and hidden columns.