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.

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.

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.