Grouping Records

Grouping in NocoDB organizes records into categories with Groups and Subgroups. You can group records by up to five levels. Grouping makes complex datasets easier to analyze and navigate.

Add or edit groups

1. In the toolbar, click Group By.
2. Select the field to group records by.
3. (Optional) Sort the groups in ascending or descending order.
4. (Optional) To create a subgroup in the selected group, use + New Subgroup.

You can group by a Link field when each record links to one parent. This applies to belongs-to, one-to-one and many-to-one links. NocoDB groups the records by the display value of the linked record. When you add a record in a group, NocoDB fills in the belongs-to or many-to-one link with the record of that group.

Enable or disable a group

You can turn a grouping off without removing it. Later, you can turn it on again with the same settings.

1. In the toolbar, click Group By.
2. Next to a group, select or clear the checkbox to enable or disable the group.

A disabled grouping keeps its field and sort configuration. Use it to flatten the view for a time, or to compare grouped and ungrouped layouts without building the setup again.

Delete groups

1. In the toolbar, click Group By.
2. Next to the group to remove, click the 🗑 icon.

Expand and collapse groups

To collapse or expand a group, click its group header. For bulk actions, open the ... menu on a group header:

Move a record to another group

Dragging a record onto another group moves it there and sets the grouping fields to that group's values, so a record dragged out of the In progress group and into Done ends up with its Status set to Done. Dropping it on a parent group changes only the levels that parent covers, and the deeper groupings keep the values they had. Press Escape while dragging to cancel the move.

A move is refused when the target group's value cannot be written to the record: when the view is grouped by a link field, by a Date Time field, by a read-only field such as a formula or a lookup, or by a field you are not allowed to edit, and when moving a record into the group of records with no value would clear a required field. NocoDB names the field and the reason instead of moving the record.

Moving records between groups needs permission to edit records, and is unavailable on tables without a primary key and on tables kept in sync with an external source.

Group level field aggregations

You can calculate aggregations on fields at each group level. Use them to summarize the data in each group, for example to calculate totals or averages.