Field types
Every field type a table can use, what it accepts, how it validates, and how it appears in the dashboard and the API.
Last updated September 17, 2026
On this page
| Type | Accepts | Dashboard control | In the API |
|---|---|---|---|
string | Short text | Single-line box | JSON string |
text | Long text | Multi-line box | JSON string |
number | Integers and decimals | Number box | JSON number; compares numerically |
boolean | true or false | Toggle | JSON boolean |
date | A calendar date | Date picker | YYYY-MM-DD; compares chronologically |
datetime | A date and time | Date and time picker | ISO 8601 with time zone |
email | An email address | Single-line box | JSON string, format email |
url | A web address | Single-line box | JSON string, format uri |
enum | One of a fixed list | Dropdown | JSON string, one of the listed values |
json | Any structure | JSON editor | Any JSON; reachable in filters with dotted names |
Rules that apply to every field
- A field may be marked required; a row without it is refused.
- Every write is validated the same way from the app, the dashboard, a backend function and the API.
- A field name is fixed once the builder chooses it; ask the builder to add or change fields.
- Large content, documents and images, belongs in uploads or generated media rather than in a json field.
Fields every row has
| Field | Set by |
|---|---|
id | The platform, on creation |
created_date | The platform, on creation |
updated_date | The platform, on every change |
created_by_id | The platform: the user who created the row, when there was one |
Was this page helpful?