Database

The Database view displays workspace records in a spreadsheet-style table. Use it to edit fields, organize records, and review large datasets.

Group records

Select Group in the toolbar, then select a field. You can group by list, status, assignee, tag, due date, or a supported custom field.

Supported custom fields include select, date, and lookup fields.

Blue places the records into collapsible groups for the selected field.

For a date field, you can group by date ranges or relative periods such as overdue, today, and upcoming. You can also configure how far backward and forward Blue displays groups.

Add nested groups

You can add up to three grouping levels. For example, group by status, then assignee, then tag.

Use the chain picker in Group to add, replace, or remove a level.

If a record belongs to multiple groups at one level, Blue counts it once in each applicable group. Blue adjusts the totals so the grouped breakdown remains consistent.

Add a record

1. Select the quick-add row at the top of the table.
2. Enter the record name.
3. Press Enter. Blue creates the record without closing the Database view.

Edit and arrange columns

Each field appears as a column. Select a cell to edit its value.

Drag a column header to change the column order. Drag a column edge to change its width.

To rename a custom-field column, rename its custom field. You cannot rename default fields.

Select + in the table to add a custom-field column.

Scroll through records

The table uses infinite vertical scrolling. You can continue scrolling through datasets with tens or hundreds of thousands of records.

Open record details

Select a record to open its details panel. Right-click a record to open actions for renaming, assigning, tagging, setting due dates, and other changes.

Column totals

A sticky footer at the bottom of the table shows the selected calculation for each column. Available operations depend on the column type:

• Most columns provide Count empty and Count filled.
• Number fields provide Sum, Average, Min, Max, Median, and Range.
• Numeric formula fields provide Sum, Average, Min, and Max.
• Date fields provide Earliest, Latest, and Range.
• Select and country fields provide Unique. Custom fields of these types can also provide Most frequent.
• Checkbox fields provide checked and unchecked counts and percentages. The Status column uses complete and incomplete labels.

Open a column menu and select Summarize to choose an available operation. Blue recalculates totals when you filter, search, or edit records.

Blue remembers the selected operation for each column.

Sort and manage columns

Select a column header to sort records by that column. Select it again to reverse the direction, then select it once more to clear the sort.

The Database view sorts by one column at a time.

Right-click a column header to open its management options:

• Pin Left or Pin Right: Keep the column visible while you scroll horizontally.
• Autosize Column or Autosize All Columns: Resize one or all columns to fit their cell content.
• Summarize: Select a footer calculation from Column totals.
• Reset Columns: Restore the default column order, width, and visibility.
• Add Column: Open the field manager to add a custom-field column.
• Visible Columns: Show or hide columns. Use All or None to change all columns.

Show or hide columns

Open Visible Columns from a column header menu. Select the columns that you want the table to show.