Tables store structured rows inside your workspace. Think of each table as a spreadsheet with typed columns: your workflows read rows to make decisions and write rows to persist results, all under your workspace’s tenancy and access rules.
#Creating a table
Open Tables in the sidebar and create a new table. Give it a name and define its fields. Rills derives a stable slug from the name; that slug is how workflow nodes reference the table, and it’s frozen after creation, so rename the display name freely but pick the fields deliberately.
#Field types
Each field has a type that controls how values are validated and displayed:
| Type | Shown as | Use for |
|---|---|---|
text | Short text | Names, single-line values |
longtext | Long text | Notes, descriptions, multi-line content |
number | Number | Amounts, counts, scores |
bool | Yes / No | Flags and toggles |
date | Date | Dates and deadlines |
select | Choice | A fixed set of options |
url | Link | Web links |
file | File upload | Attached files (stored in workspace storage) |
Fields can be marked required and given a default value. A select field carries its own list of allowed options.
#Editing rows
Open a table to browse its rows. Add a row, edit values inline, and delete rows you no longer need. Every value is validated against its field type on save, so a number field rejects text and a required field can’t be left blank.
#How workflows use tables
Workflows read and write tables through the Data node, which supports add, find, update, and delete. To roll rows up into totals or averages, use the Aggregate Rows node. To start a workflow the moment a row lands, use the Data Change trigger.
#Limits
A workspace can hold up to 500 tables. This is a uniform anti-abuse ceiling, identical on every plan, not a pricing tier: it stops a runaway script or template from spawning thousands of tables.
The limits that scale with your plan are row-write rate (how many rows you can write per minute) and storage. Both grow with higher tiers; see the pricing page for the current rates.
#Storage
Table rows count toward your plan’s included storage allowance, combined with uploaded files into a single number. Reading, writing, and deleting rows is free: you’re only billed for what’s stored, and only above the included amount. See Data storage for allowances and overage rates.
#Related
- Data nodes: read, write, and aggregate rows
- Forms: capture rows from a public page
- Files & storage: the
filefield and workspace storage - Billing: how stored data is metered