Tables

Column Types

Learn about Column Types in WaymakerOS.

ColumnsTypes

Configure columns with the right types to enforce data quality and enable powerful filtering.

Adding columns

  1. Open a table
  2. Click the + button at the end of the column headers
  3. Enter a column name
  4. Select a column type
  5. Configure type-specific settings
  6. 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

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