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

  1. Open Tutorial Base → Requests. Click the plus beside the view tabs and select 【Grid view】.
  2. Right-click the new tab, choose 【Rename】, enter Open Requests, and press Enter.
  3. Open 【Filter】 → 【Add condition】 and set Status to is Open.
  4. Open 【Hidden fields】, hide Notes, and close the panel.
  5. Switch to All Requests to see all four records, then return to Open Requests to see the two open requests.

Sort and group

This example uses a numeric Priority field with the values 1, 2, 3, and 4.

  1. In All Requests, open 【Sort】, select Priority, and keep ascending order.
  2. Open 【Group】 and select Status. Records appear in Done and Open groups.
  3. Click the arrow beside a group to collapse or expand it.
  4. Reopen the grouping panel and delete the condition. The flat list keeps its Priority sort.

Find a missing record

Confirm the table and view, then check filters, field values, and hidden columns.