Every column in a Dokki table has a type. The type controls the editor shown in the cell, how filter operators are chosen, how form submissions are validated, and how values are displayed.
Available types
Type | What it stores | Current editor / behavior |
|---|---|---|
Text | Any string, including multiline text | Inline text editor |
Number | Numeric values or blank | Numeric editor; blanks stay blank instead of becoming 0 |
Boolean | True / false | Checkbox |
Date | One date value | Date editor and local-date display |
Date range | Start date and end date | Range value used by Gantt and date-range filters |
Select | One option from the column's option list | Dropdown-style single choice |
Multi-select | Multiple values from the option list | Multi-choice editor; stored as a comma-separated value internally |
Tags | Workspace tags applied to that row | Tag picker backed by the workspace tag list |
Member | One workspace member | Member picker listing current workspace members |
URL | Link-like text | Text editor with URL-oriented rendering where available |
Email-like text | Text editor with email-oriented rendering where available |
Setting a column type
Open the column menu from the header, choose the type action, and pick the new type. Column definitions are stored in the table's collaborative Y.js document, so collaborators see the new type as soon as the table syncs.
Changing a type affects new edits, filters, views, and public form validation. Existing values are not a substitute for a database migration: review important columns after changing their type, especially when moving between free text and structured types such as number, date, select, or multi-select.
Select and multi-select options
Select and multi-select columns use the column's option list as the source of truth. Those options drive:
the cell editor choices;
Kanban grouping, because Kanban groups by a select-style column;
public form validation, because anonymous submitters cannot invent new select options;
filter operators such as
is,is not,includes any, andincludes all.
If you need free-form values, use a Text column instead of Select.
Date and date range columns
Date columns power Calendar views and date filters. Date range columns can power Gantt views directly. Gantt can also use separate start and end Date columns when a date-range column is not available.
Date filters compare by local calendar day for equality-style checks. For date ranges, Dokki treats a range as matching when the target day or filter range overlaps the stored range.
Public form validation
Forms validate against live column definitions at submit time:
required non-boolean fields must be present;
number fields must parse as numbers;
date and date-range fields must parse as dates;
select and multi-select values must already exist in the column options;
email fields must match a basic email format;
disabled fields and deleted columns are ignored.
Current limits
Dokki tables currently do not provide formulas, relational links between tables, or a dedicated file/attachment column type. Use documents, files, or separate tables for those workflows.
