Database

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

Grouping

Use the Group By 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 click on the settings icon on each column header to get various options presented to you:

• Pin Column: You can choose to pin the column either to the right or left. This keeps the column always in view as you scroll horizontally.
• Autosize This Column: Ensures that the column width is enough to show all the data in the cells contained in that column.
• Autosize All Columns: Same as “Autosize This Column” but applies to all columns.
• Group by This Column: Group all records by the values in this column, as discussed earlier in this guide.

Show/hide columns

You can easily decide which columns to hide and show when you are viewing the database:

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.