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