Database

This view is ideal for managing large datasets, enabling powerful filtering, sorting, and editing capabilities.

Grouping

Use the Group control in the toolbar to group records by specific properties. Supported grouping dimensions include list, status, assignee, tag, due date, and any custom field (select, date, or lookup fields).

Once you have selected a grouping field, your record database will be organized into collapsible groups:

Date-based grouping supports both actual date ranges and relative grouping (overdue, today, upcoming, etc.), with configurable options for how far back and forward to display.

Nested grouping

Stack up to three levels of grouping for more granular breakdowns — for example, group by Status, then by Assignee, then by Tag. Use the chain picker in the Group dropdown to add, swap, or remove levels.

Header counts are smart: a record that belongs to multiple groups at a level (e.g. multiple tags) is counted once per group, with the totals adjusted so the breakdown still adds up sensibly.

Quick Add

Add new records directly from the database view using the quick-add row at the top of the table. Type a title and press Enter to create a record without leaving the view.

Interactive Columns

Each column represents a custom field, with the ability to instantly edit data within cells. Rearrange column order via drag-and-drop, and resize columns by dragging their edges.

Note that to change the column names, you have to change the names of the related custom fields. Default fields cannot be renamed. You can also add new custom field columns directly from the table using the “+” button.

Infinite Scroll

• The database table enables infinite vertical scrolling to manage vast datasets spanning tens or hundreds of thousands of records.

Easily Access Record Details

• Click any record to open a details panel showing the full record information. Right-click a record to access a context menu with quick actions like renaming, assigning, tagging, setting due dates, and more.

Column Totals

A sticky footer row at the bottom of the table shows per-column aggregations. Open the column menu and pick an operation:

• Sum — total of all values in the column
• Average — mean value
• Min / Max — smallest / largest value
• Median — middle value
• Count — number of records
• Count empty — number of records with no value
• Count filled — number of records with a value
• Most frequent — the most-common value in the column

Totals recalculate instantly as you filter, search, sort, or edit records. Each column remembers its chosen operation, so the footer stays useful as you customise the view.

Bulk Actions

If it’s a number/formula field you can instantly see the total sum.

Column Management

You can click on a column header to sort all your records by that column. Sort by any column, and even multiple columns!

You can also right-click a column header to get various options presented to you:

• Pin Left / Pin Right: Keeps the column always in view as you scroll horizontally.
• Autosize Column / Autosize All Columns: Ensures the column (or every column) is wide enough to show all the data in its cells.
• Summarize: Pick the footer aggregation for this column — the same operations listed under Column Totals above.
• Reset Columns: Restores default column order, width, and visibility.
• Add Column: Opens the field manager to add a new custom field column.
• Visible Columns: A checklist to show or hide individual columns, with “All” / “None” shortcuts.

Show/hide columns

You can also decide which columns to hide and show from the same column header menu’s Visible Columns checklist above.

With spreadsheet-style interactions, grouping, filtering, and editing tools, the Database View delivers powerful data management and analysis capabilities to handle even your largest datasets.