Rollup

If you are using NocoDB with version 0.90 onwards, please check out the latest documentation here instead. The documentation for previous versions is no longer maintained and will be completely removed on 30 Jun 2022. See v0.90 Important Announcement for more.

Rollup

Sample simple Organization structure:

  • 5 verticals, each vertical has a team name & associated team code
  • 5 employees working at different verticals
  • Vertical has many Employees : relationship has been defined

LookUp

RollUp AGGREGATION functions supported

  • Count
  • Minimum
  • Maximum
  • Average
  • Sum
  • Count Distinct
  • Sum Distinct
  • Average Distinct

Now, we can explore how to extract employee count information per vertical using "ROLLUP" columns

Adding a rollup column

1. Add new column

Click on '+' icon to the left of column headers in Verticals table

1

2. Feed column name

2

3. Select Column type as 'Rollup'

3

4. Choose Child Table

Table Employee in our example

4

5. Choose on ​Child column

Pick appropriate column for aggreagation

5

6. Select ​Aggregate function

Aggregate function will be "count" in our case

6

7. Click on Save

7

8. Column TeamCount is populated with appropriate information

8