Fields
The Fields panel lets you add, configure, rename and delete columns within a table. Open it from Config → Fields, then select a table from the dropdown.
Adding a field
Click Add field and fill in the field form:
| Property | Description |
|---|---|
| Name | Internal column name (lowercase, underscores; e.g. site_name) |
| Label | Display label shown to users |
| Type | See field types below |
| Required | Prevent saving if this field is empty |
| No duplicates | Reject values already present in another record |
| Default | Pre-filled value for new records |
| Max length | Character limit for text fields |
| Min / Max | Numeric or date bounds |
| Regex pattern | Validation pattern (e.g. ^[A-Z]{2}\d+$ for a site code) |
Field types
| Type | Use for |
|---|---|
text | Short single-line text |
long_text | Long multi-line text (plain, preserves line breaks) |
md | Markdown text — rendered as formatted HTML in read mode; edit mode has a live preview toggle |
date | ISO date (YYYY-MM-DD) with date-picker |
boolean | Yes/No toggle |
select | Single value from a controlled vocabulary or another table |
multi_select | Multiple values from a controlled vocabulary |
combo_select | Free text + vocabulary suggestions |
slider | Integer within a min/max range |
Value sources for select fields
Fields of type select, multi_select and combo_select need a source for their available values. Set exactly one of the following:
| Property | Description |
|---|---|
| Vocabulary | Name of a vocabulary list — values are managed in the Vocabularies panel |
| Values from table | A table and field whose unique values are used as autocomplete suggestions |
| ID from table | A table whose records appear in the dropdown; the record id is stored, but the preview fields are shown to users |
Foreign key fields
A foreign key field stores the id of a record from another table. Use type select and set ID from table to the target table.
The dropdown shows the target table's preview fields; the stored value is the integer id. This is the recommended way to avoid data duplication across tables.
Reordering fields
Drag rows in the field list to change the column order. This order is reflected in RecordView, in all export headers and in the record list columns.
Renaming a field
Use the Rename button. The DB column is renamed and all config references are updated.
Deleting a field
Click Delete. The DB column and all its data are permanently removed.