Relations, Lookup & Formula

Relation, Lookup, Rollup, and Formula are the four advanced column types that let you link and compute data across different tables.

---

Relation

A relation links rows in one table to rows in another table (or the same table).

Use cases

• “Shootings” links to “Models” — each shooting knows which models are booked
• “Tasks” links to “Projects” — each task is assigned to a project
• “Equipment list” links to “Equipment inventory” — you always know where each item is

Setting up a relation

1. New column → type Relation
2. Choose the target table (must be in the same workspace)
3. Optionally: give the other side a name (it will appear as a new column in the target table)

Linking rows

Click on a Relation cell → + Link row → select from the list of existing entries. Multiple links per cell are supported.

---

Lookup

A Lookup displays the value of a column from a linked row (read-only).

Setting it up

1. New column → type Lookup
2. Choose the Relation column (must already exist)
3. Choose the target column in the linked table

Example: In the Shootings table, a Lookup on the email address from the Models table. The email appears automatically.

---

Rollup

A Rollup aggregates values from a linked table (via a relation).

Available aggregations

Function	Description
count	Number of linked rows
count_empty	Number of empty values
count_not_empty	Number of non-empty values
count_unique	Number of unique values
sum	Sum (numbers only)
avg	Average
min / max	Smallest / largest value
earliest / latest	Earliest / latest date
checked / unchecked	Number of checkboxes
pct_checked	Percentage checked

Setting it up

1. New column → type Rollup
2. Choose the Relation column
3. Choose the target column
4. Choose the aggregation function

---

Formula

A Formula field calculates a value based on other columns in the same row.

Syntax

Formulas reference column names in curly braces:

{Price} * {Quantity}
{LastName} & ", " & {FirstName}
IF({Status} = "Done", "✓", "–")

Supported operators

• Arithmetic: +, -, *, /
• Text: & (concatenation)
• Comparison: =, !=, >, <, >=, <=
• Logical: AND(...), OR(...), NOT(...)
• Functions: IF(...), ROUND(...), LEN(...), UPPER(...), LOWER(...), TRIM(...)

Entering a formula

Click the column name → Edit formula → type the formula into the input field. A live preview shows the calculated value.