Tables & Fields
Tables are the foundation of your app's data structure. Learn how to create and configure tables and fields to store your data.
Creating Tables
Similar to spreadsheets or databases, Stacker has a built-in database where you can upload your data and configure the fields in multiple ways:
- AI Generation — Ask the agent to build specific tables with specific fields, including field names and field types.
- Manually Create Tables — Under Setup → Data, use Add Table, then add fields and rows in the grid.
- Import — Upload your existing data from a CSV into Stacker.
- External Data — Use a data connector to bring in data from your existing data sources.
| Name | Status | Client | Due Date |
|---|---|---|---|
| Website Redesign | In Progress | Acme Corp | Jan 15, 2026 |
| Mobile App MVP | Complete | TechStart Inc | Dec 20, 2025 |
| Brand Guidelines | Planning | StartupXYZ | Feb 1, 2026 |
1. AI Generation
Use the AI chat in the builder to describe what you need—table names, field names, and types (for example relations, selects, dates, currency). Ask for changes in plain language; the agent can add or adjust tables and fields so you can review the result in Setup → Data.
Example
“Add a Projects table with title, status (select: Planning, Active, Done), due date, budget in USD, and a relation to my Companies table. Then add a Tasks table linked to Projects with assignee and priority.”
2. Manually create tables
- In the top navigation, click Setup, then open the Data tab.
- In the upper right of the data area—beside your existing table tabs—click Add Table.
- Finish naming your table in the dialog. You’ll land on an empty grid for that table.
- Add fields: click the + at the far right of the column headers, choose a name and field type, and repeat for each column. See Field types for options.
- Add records with Add Row in the toolbar (or edit cells like a spreadsheet).
3. Import
From Setup → Data, choose the table to import into (or create one first). Click Import in the toolbar, upload your CSV or Excel file, map columns to fields (or use AI-assisted mapping), then review and confirm. See Importing Data for formats and tips.
4. External data
Go to Setup → Connections, add a connector (e.g. Salesforce, Airtable, Stripe), authenticate, and choose which objects to sync. Stacker creates matching tables and fields and keeps them updated on a schedule. Read Data Sync and Supported Connectors for next steps.
Field types
Each field has a type (text, number, relation, formula, and more). For a compact list of every type—including how relations and computed fields work—see Field types.
How to create a new field
You can add columns in the grid yourself, or use the AI agent in the builder—describe the field in plain language and review the result in Setup → Data.
- Go to Setup → Data and open the table where you want the new column.
- In the column header row, click the + at the far right.
- In the dialog, set the field name, pick a type, and fill in any required options for that type.
- Save. The column appears in the grid; use the column header menu later to edit the field.
Example (AI agent)
“On my Tasks table, add a Priority field—single select with Low, Medium, and High, default Medium, and make it required.”
Field Settings
Each field can be configured with additional settings:
Required
Mark a field as required to ensure it's always filled in when creating or editing records.
Default Value
Set a default value that's automatically populated when creating new records.
Unique
Ensure no two records have the same value for this field (e.g., email addresses).
Hidden
Hide a field from portal users while keeping it visible to admin users.