Column Types
Learn about Column Types in WaymakerOS.
Configure columns with the right types to enforce data quality and enable powerful filtering.
Adding columns
- Open a table
- Click the + button at the end of the column headers
- Enter a column name
- Select a column type
- Configure type-specific settings
- Click Add
Available column types
Text
Free-form text entry. Use for names, descriptions, notes, or any unstructured text.
Settings: Maximum length (optional)
Number
Numeric values — integers or decimals. Use for quantities, scores, measurements.
Settings: Decimal places, minimum value, maximum value
Date
Date values with a built-in date picker. Use for due dates, created dates, event dates.
Settings: Date format, allow time component
Select
A dropdown with predefined options. Use for status fields, categories, types — any field where values come from a fixed set.
Settings: Options list (add, remove, reorder options), allow multiple selections
Example: A "Status" column with options: "New", "In Progress", "Complete", "Cancelled"
Boolean
A simple true/false checkbox. Use for flags, toggles, yes/no fields.
Settings: Default value (checked or unchecked)
URL
Clickable web links. Values are validated as URLs and rendered as clickable links.
Settings: None
Email addresses. Values are validated as email format and rendered as mailto links.
Settings: None
JSON
Structured JSON data. Useful for storing complex objects, API responses, or configuration data.
Settings: None (stores raw JSON)
Editing columns
Click any column header to open column settings:
- Rename — change the column name
- Change type — convert to a different type (existing data is converted where possible)
- Required — mark as mandatory for new rows
- Default value — pre-fill new rows with a default
- Delete — remove the column and all its data
Reordering columns
Drag column headers left or right to reorder. The first column is always visible when scrolling horizontally.
System columns
Every table automatically includes:
- id — unique row identifier (auto-generated, read-only)
- created_at — timestamp when the row was created (auto-set)
- updated_at — timestamp of the last edit (auto-updated)
These columns cannot be deleted or renamed.
Next steps
- Filtering & Sorting — find data using column values
- Data Connections — populate columns from external sources
- Introduction to Tables — overview of all table features