Fields & formulas
Each column in a table is a field with a type. The type decides what can be stored and how it is displayed, filtered and sorted.
Adding and editing fields
- Click + at the end of the header to add a field.
- Click the ▾ next to a field name to rename it, change its type, hide it, sort, filter, duplicate, insert a field left/right, or delete it.
- Changing a type converts existing values where possible. The conversion can be undone with <kbd>Ctrl/Cmd+Z</kbd>.
Field types
| Group | Types |
|---|---|
| Text | Single line text, Long text (optionally rich text), URL, Email, Phone number |
| Numbers | Number (decimals, prefix/suffix, thousand separators), Rating, Boolean, Duration, Autonumber |
| Dates | Date (with optional time and timezone), Created on, Last modified |
| Choices | Single select, Multiple select (with colors) |
| People | Collaborator, Created by, Last modified by |
| Files | File (images, documents; previews in the grid) |
| Relations | Link to table, Lookup, Rollup, Count |
| Computed | Formula, UUID, Password |
| AI | AI field (generates a value from a prompt per row, needs an AI provider) |
Formulas
A Formula field computes its value from other fields in the same row.
Reference a field with field('Name').
field('Price') * field('Quantity')
if(field('Paid'), 'Paid', 'Open')
concat(field('First name'), ' ', field('Last name'))
datetime_format(field('Due'), 'YYYY-MM-DD')
date_diff('dd', field('Created'), now())
Useful groups of functions:
- Text:
concat,upper,lower,trim,left,right,replace,contains,split_part,regex_replace. - Numbers:
round,floor,ceil,abs,min,max,power,mod. - Dates:
today,now,date_diff,date_interval,datetime_format,year,month,day. - Logic:
if,and,or,not,isblank,when_empty. - Lists (with link fields):
lookup('Link', 'Field'),sum,count,join,filter,avg,min,max.
The formula editor shows every function with a description and an example as you type. Errors are shown before you save.
Lookup, Rollup and Count
After creating a Link to table field:
- Lookup shows a field of the linked rows, e.g. the company’s country.
- Rollup aggregates a field of the linked rows, e.g.
sumof deal values. - Count counts linked rows.
Field descriptions and validation
Every field can have a description (shown as a tooltip on the header). Number fields can be restricted to positive values, date fields to a format, and single selects to their options, which keeps data clean for both people and agents.