Every column in a Dokki table has a type. The type controls how cells are validated, edited, displayed, sorted, and filtered.
Available types
Type | What it stores | Editor |
|---|---|---|
Text | Any string | Inline text input |
Number | Integers and decimals | Numeric input with parsing |
Boolean | True / false | Checkbox toggle |
Date | Single date | Calendar picker |
Date range | Start + end date | Range calendar picker |
Select | One option from a defined list | Dropdown |
Multi-select | Many options from a defined list | Multi-pill picker |
URL | Validated link | Text input + clickable link |
Validated email | Text input + mailto link |
Setting a column type
Click the column header → Type → pick from the menu. Existing cell values are coerced when possible:
Text → Number: parses numeric strings, blanks the rest.
Text → Select: existing values become options if they match; otherwise blank.
Date → Text: serialised to ISO string.
A coercion preview shows what will happen before you confirm — no silent data loss.
Select and multi-select options
For select-type columns, define options in the column settings:
Label — what the user sees
Color — pill background
Order — drag to reorder
Options are shared across the column. Renaming an option updates every cell. Deleting an option blanks the cells that used it (with a confirm).
Cell colors
Independent of column type, you can set a background color on any individual cell — handy for status, priority, or visual grouping inside a sea of text.
Validation behavior
Invalid input shows a red outline; the cell stays in edit mode until valid.
Pasting bulk data validates each cell as it lands.
Copilot honors the column type when filling cells — it won't write "TBD" into a number column.
What's not yet supported
Formulas (cross-cell or cross-row computation) — coming.
Relations between tables — track relationships with a select column for now.
File / attachment column type — coming.