Column Types
A complete guide to every column type available in Wyatt databases.
Choosing the Right Column Type
Every column in a Wyatt database has a type that determines what kind of data it holds and how it behaves. Choosing the right type helps you keep data consistent and unlocks useful features like filtering, sorting, and formulas.
You select a column type when you create a new column. You can change it later, though some conversions may adjust your existing data.
Available Column Types
Text
A general-purpose field for any free-form text — names, descriptions, notes, and so on. Text columns support single-line and multi-line content.
Best for: Names, titles, descriptions, comments.
Number
Stores numeric values. You can configure the format to display as plain numbers, currency, or percentages.
Best for: Prices, quantities, scores, budgets.
Select
A dropdown with a predefined list of options. Each row can have exactly one selected value. Options are color-coded for easy scanning.
Best for: Status fields, categories, priority levels.
Select columns work especially well with kanban view — your options become the kanban columns.
Multi-Select
Like Select, but each row can have multiple values chosen from the list. Tags appear as colored chips.
Best for: Tags, labels, skills, categories where items can belong to more than one group.
Date
Stores a date (and optionally a time). Date columns support calendar pickers and can be filtered by ranges like "this week" or "last month."
Best for: Due dates, start dates, birthdays, event dates.
Checkbox
A simple true/false toggle. Displays as a checkbox you can click to turn on or off.
Best for: Completion status, yes/no flags, approval fields.
URL
Stores a web address and renders it as a clickable link.
Best for: Website links, reference URLs, social media profiles.
Stores an email address and renders it as a clickable mailto: link.
Best for: Contact emails, support addresses.
Person
References a member of your workspace. Person columns let you assign rows to specific teammates and filter by who's responsible.
Best for: Assignees, owners, reviewers, created-by fields.
Person columns only show members who have been invited to your workspace.
Formula
Computes a value automatically based on other columns in the same row. Formulas support arithmetic, text manipulation, date math, and conditional logic.
Examples:
Price * Quantity— calculates a totalIF(Status = "Done", "Yes", "No")— conditional outputDAYS_BETWEEN(Start Date, End Date)— date difference
Best for: Totals, derived fields, calculated statuses.
Formula columns update in real time. When you change a value that a formula depends on, the result recalculates instantly.
Relation
Links rows in one table to rows in another table. Relations let you build connections across your databases — for example, linking tasks to projects, or contacts to companies.
When you create a relation column, you choose the target table. Each row can then reference one or more rows from that table.
Best for: Connecting related data across tables, building relational structures.
Summary
| Type | Stores | Key Feature |
|---|---|---|
| Text | Free-form text | Multi-line support |
| Number | Numeric values | Currency and percentage formatting |
| Select | Single choice | Color-coded dropdown |
| Multi-Select | Multiple choices | Colored tag chips |
| Date | Dates and times | Calendar picker and range filters |
| Checkbox | True / false | Click to toggle |
| URL | Web addresses | Clickable links |
| Email addresses | Clickable mailto links | |
| Person | Workspace members | Assign and filter by teammate |
| Formula | Computed values | Real-time calculation |
| Relation | Linked rows | Cross-table connections |