Column types
Column types define which values a column accepts and how they are edited. Each type has two presentation roles: When modeling (schema panel) and When maintaining data (table and entry detail). See Work modes and Column.
| Type | Description |
|---|---|
| Short text | Short single-line text |
| Long text | Multi-line text with Markdown |
| Number | Integers and decimals |
| Currency | Numbers with currency symbol |
| Percent | Percentage values (0–100) |
| Date | Date and optional time |
| Duration | Time span |
| Yes/No | Boolean toggle |
| Choice | One value from a list |
| Multi-choice | Several values from a list |
| Rating | Stars or points |
| Email address | |
| Phone | Phone number |
| URL | Web address or file path |
| File | Arbitrary files |
| Image | Images and photos |
| User | Reference to a user account |
| Link | Relation to entries in another block |
| Self-reference | Parent entry in the same block |
| Automatic ID | Immutable ID |
| Auto number | Sequential number |
| Created at | Automatic creation timestamp |
| Created by | Creating user |
| Updated at | Last change timestamp |
| Updated by | Last changing user |