Field types
Every column in a table has a type. Relations connect tables; formula, lookup, and rollup fields derive values from other fields or linked records.
Reference
Each type is available when you add a column in Setup → Data or when you ask the AI agent for fields.
Text & values
Single-line text for names, titles, short labels, and keywords.
Multi-line text and notes; rich formatting where supported.
Integers or decimals; optional display formatting.
Money values with symbol and formatting for revenue, costs, and budgets.
Dates & scheduling
Calendar dates for deadlines and milestones—no time component.
Full timestamps for scheduling, logging, and precise events.
Choice & status
One option from a list you define—ideal for status, stage, or category.
Multiple tags or labels from a predefined list.
True/false toggles for done flags, approvals, and yes/no fields.
Contact & links
Email addresses with validation.
Phone numbers with formatting.
Web links with validation.
Files & location
Uploads for documents, images, and attachments.
Addresses; geocoding where available.
Relations & lookups
Link to a record in another table (many-to-one). Stacker adds the inverse link on the other table automatically.
Links to another table by matching values—e.g. this row’s email equals a row in Clients. Updates when matched data changes; use lookups on top like a normal relation.
Show a field value pulled from a linked record (e.g. client email on a project).
Computed
Computed value from an expression on the same record (e.g. quantity × price).
Aggregate over related records—sum, count, average, min, or max (e.g. total invoice amount per client).
How to create a new field
New columns are added from the grid under Setup → Data. You can also use the AI agent in the builder to add or adjust fields in plain language—see the example below, and more patterns under Ask the AI agent.
- Open Setup → Data and select the table where you want the field.
- In the header row, click the + (plus) at the far right, after your existing columns.
- In the dialog, enter a field name, choose a type, and complete any extra settings (select options, related table for a relation, formula, etc.).
- Save—the new column appears in the grid. To change the field later, use the menu on that column's header.
Example (AI agent)
“On Projects, add a Budget field as currency (required) and a Kickoff date as a date field.”
Ask the AI agent
In the AI builder chat, say which table to change and list each new field with its name and type. Mention requirements (required, options for selects, which table to link for relations) so the agent can configure them correctly.
Example
On the Projects table, add: - Budget — currency, required - Kickoff date — date - Status — select with options: Planning, Active, On hold, Done - Link to Clients table — relation field called "Client" (many projects to one client)
For more on the builder, see Using the AI Builder.
Computed values (formula, rollup, lookup) and automatic link fields stay in sync when source data changes and can be filtered and sorted like other columns.