# Fields you can use in equations and formulas

> Which field types a Text Formula, Number Formula, Date Formula, Equation, Rollup or Dynamic field can read, from its own table and from connected tables.

Source: https://tadabase.com/docs/data/which-fields-are-referenceable-in-equations-and-formulas  
Status: Verified Nov 17, 2026. Checked against the current product

Each kind of calculated field only offers some field types when you build its formula. Use this page to pick the right calculation before you start, or to find out why a field is missing from the **Add Field** list.

## At a glance

| Calculation | Reads fields from | Good for |
| --- | --- | --- |
| **Text Formula** | This table and connected tables | Joining text and values into one line |
| **Number Formula** | This table and connected tables | Adding, subtracting, multiplying and dividing numbers |
| **Date Formula** | This table and connected tables | Time between two dates, or a date plus or minus some time |
| **Equation** | This table only | Functions, IF logic, text and date functions |
| **Rollup** | The connected records only | Counting, totals, averages and lists across many connected records |
| **Dynamic** | This table and connected tables | Display output worked out when the record is shown, not stored |

> **Connected values come from one record:** When a Text Formula, Number Formula or Date Formula uses a field from a connected table, it reads that field from one connected record. To count, add up or list values from several connected records, use a [Rollup](https://tadabase.com/docs/data/rollup).

## Field types by calculation

A field never appears in its own formula.

| Calculation | Field types you can pick | Not offered |
| --- | --- | --- |
| **Text Formula** | Text, Long Text, Rich Text, Email, Phone Number, Link, Number, Currency, Rating, Slider, Radio, Select, Checkbox, Multi-Select, Decision Box, Equation, Rollup, and the parts of Person Name and Address fields (for example **Name - First Name** or **Address - City**). The same types from connected tables. | Date, Time, Date & Time, Date Range, Date Formula, Text Formula, Number Formula, File, Image, Signature and connection fields |
| **Number Formula** | This table: Number, Currency, Slider, Auto Increment, Equation fields whose output is a number, Date Formula fields (as seconds, minutes, hours or days), and older Count, Maximum, Minimum, Average and Sum fields. Connected tables: Number, Currency, Number Formula and Equation fields whose output is a number. From both: Radio, Select, Checkbox and Multi-Select fields that store a number for each option (**Score Value**). | Text and personal fields, dates, Rating, Rollup, other Number Formula fields in the same table, and everything else not listed |
| **Date Formula** | Date and Date & Time fields from this table and connected tables. Number fields from this table and connected tables, as an amount of time to add or subtract. | Everything else, including Time, Date Range and Auto Increment |
| **Equation** | Every field in this table except the ones in the next column, including the record ID, Auto Increment, other calculated fields and the parts of Person Name, Address and Date Range fields. | File, Attachments, Image, Signature, Checkbox, Multi-Select, connection fields, and any field from a connected table |
| **Rollup** | Fields of the connected table. **Count Records** needs no field. **Sum Value**, **Average Value**, **Minimum Value** and **Maximum Value** are for number fields such as Number, Currency, Number Formula, Equation, Rollup, Rating and Slider; the list also offers date and time fields. **Concatenate** and **Concatenate Unique** take any field except Link. | For Sum, Average, Minimum and Maximum: Text, Long Text, Rich Text, Email, Person Name, Radio, Select, Checkbox, Multi-Select, Decision Box, Text Formula, Link, File, Image, Signature and connection fields |
| **Dynamic** | Fields of this table and of connected tables (listed as connection > field), and the parts of Person Name, Address and Date Range fields. | File, Attachments, Image, Signature, Checkbox and Multi-Select |

## When the field you need is missing

- **You need a date in a text value.** Text Formula does not take date fields. Use an [Equation](https://tadabase.com/docs/data/equation) instead.
- **You need another Number Formula from the same table.** Number Formula fields cannot be nested. Repeat that formula inside parentheses in the new one, for example `(Hours * Rate) + Trip Fee`, or use an [Equation](https://tadabase.com/docs/data/equation).
- **You need a total of many connected records.** A formula reads one connected record. Add a [Rollup](https://tadabase.com/docs/data/rollup) on this table first.
- **You need a connected value in an Equation.** Equations only read fields of their own table. Use a Text Formula, Number Formula or Date Formula, which can read connected fields, or a [Rollup](https://tadabase.com/docs/data/rollup).
- **An Equation field does not show as a number.** Number Formula only lists Equation fields whose output type is a number.
