# Summarize connected records with a Rollup field

> Count connected records, or total, average, find the lowest or highest of, or list a field across them, with optional conditions.

Source: https://tadabase.com/docs/data/rollup  
Status: Verified Nov 17, 2026. Checked against the current product

A Rollup field looks at the records connected to each record and returns one value: how many there are, a total, an average, the lowest or highest value, or a list of values. For example, a customer's number of jobs, or the total of their invoices. Conditions let you count or total only some of the connected records.

The table needs a connection to the records you want to summarize. See [Connection fields](https://tadabase.com/docs/data/connection-fields).

## Add a Rollup field

In this example each customer gets an **Open Jobs** count of their jobs that are not completed.

1. **Open the table** In the **Data Builder**, open the **Customers** table and click the **Fields** tab.
2. **Choose the field type** Click **Add New Field**. Under **Equation**, click **Rollup**, then click **Add and Configure**.
3. **Name it** Enter a **Name**, for example `Open Jobs`.
4. **Choose the connected records** Under **Showing Connected Tables**, pick the connection to roll up through, for example **Jobs**.
5. **Choose what to calculate** Set **Formula Function** to **Count Records**. For any other function, also pick the field to calculate with.
6. **Add a condition** Under **Add Data Conditions**, click **Add** and set the condition, for example **Status** is not **Completed**.
7. **Save** Click **Save**. Each customer now shows how many open jobs they have.

![A Rollup field on the Customers table rolling up the connected Jobs, with Formula Function and Add Data Conditions](https://tadabase.com/docs-shots/data-rollup-settings.webp)

## Choose the connected records

The list under **Showing Connected Tables** has two kinds of entries:

- This table's own connection fields, by field name.
- Tables that connect to this table, shown as the table name with the connection field in brackets, for example **Jobs (Customer)**. Use these to roll up child records, such as all jobs of a customer.

On some plans, the arrow next to **Showing Connected Tables** also offers **Show All Tables**, which rolls up records of any table and matches them with conditions instead of a connection.

## Formula functions

| Formula Function | Returns | Field to calculate with |
| --- | --- | --- |
| **Count Records** | How many connected records match | None |
| **Sum Value** | The total of the field | A number field such as Number, Currency, Number Formula, Equation, Rollup, Rating or Slider |
| **Average Value** | The average of the field | As for Sum Value |
| **Minimum Value** | The lowest value | A number field, or a date or time field for the earliest |
| **Maximum Value** | The highest value | A number field, or a date or time field for the latest |
| **Concatenate** | The field's values from all connected records, in one line | Any field except Link |
| **Concatenate Unique** | Like Concatenate, but each value only once, sorted by value | Any field except Link |

The field list label tells you what you are choosing, for example Select the field in Jobs data table to get the SUM values. Text, option, connection, file and signature fields are not offered for Sum, Average, Minimum or Maximum.

## Concatenate settings

| Setting | What it does | Default |
| --- | --- | --- |
| **Value Separator** | The text between values. Spaces are kept, so `, ` gives `A, B, C`. | `,` |
| **Sort By** | The field and direction (**ASC** or **DESC**) that sets the order of the values. **Concatenate Unique** always sorts by the value itself. | **ASC** |
| **Limit Records** | **All Records**, or **Limited Records** with a number. The number is only applied to a rollup set to **Show All Tables**; leave it on **All Records** for a rollup through a connection. | **All Records** |

## Count or total only some records

Under **Add Data Conditions**, click **Add** to add a condition on a field of the connected table. Only connected records that match are counted, totalled or listed. Add more conditions with **Add**; remove one with its delete button.

Examples: count only jobs whose **Status** is **Completed**, or total only invoices whose **Paid** box is unchecked.

## Number format

When the field you calculate with is a number field, you can also set **Decimal Places** and **Thousands Delimiter**. For fields other than Number, such as Currency or Number Formula, you can set a **Currency Type** and its **Format** (**None**, **Suffix** or **Prefix**) too.

## If a rollup is slow or wrong

- Use conditions to include only the records you need, and remove rollups you no longer use.
- If a calculation fails, the field settings show **Last calculation failed** with the error. Check the fields the rollup uses, then save the field to run it again.
- On plans that include it, the **Optimized Query** switch (beta) calculates the rollup for the whole table in one pass. When you save, the result is tested against your data; if it differs, the field keeps its original query.
- **Enable** is on by default. Turning it off stops the field recalculating; values already saved stay as they are.

## Older Count, Maximum, Minimum, Average and Sum fields

Before Rollup, Tadabase had separate Count, Maximum, Minimum, Average and Sum field types (also called Complex Formula). Rollup replaces them: they are no longer offered in **Add New Field**, and Rollup does the same and more, such as **Concatenate**.

Fields you already have keep calculating. When you open one, it has the same settings as a Rollup: **Table**, **Formula Function** (**Count Records**, **Minimum Value**, **Maximum Value**, **Average Value** or **Sum Value**), the field to calculate with, **Add Data Conditions**, **Currency Type**, **Format**, **Decimal Places** and **Thousands Delimiter**. The field to calculate with can be a Number, Currency or Number Formula field.

An older field cannot be changed into a Rollup. To move to Rollup, add a Rollup with the same settings, switch anything that used the old field to the new one, then delete the old field. A [Number Formula](https://tadabase.com/docs/data/number-formula) can use older fields from the same table, but not Rollup fields; an [Equation](https://tadabase.com/docs/data/equation) can use both.
