Column types

Each column's type defines what it accepts, how it appears and how it is aggregated (summed, counted, calculated). Pick the type when you create the column and adjust its type-specific options in edit structure.

Available types

Text

Free text, for names, descriptions and short notes.

Integer

Whole numbers. Sums, counts and averages in footers and charts.

Decimal number

Numbers with decimal places; you set how many places to show.

Currency

Monetary value formatted with the symbol of the chosen currency.

Select

One option from several predefined ones, shown as a colored label. Also powers the Kanban lanes.

Date

Date picked from a calendar. Also powers the Calendar view.

Checkbox

True/false value, checked or unchecked.

Rating (stars)

A star rating, great for priority, quality or satisfaction.

Progress (%)

A percentage from 0 to 100 shown as a progress bar.

Multi-select (tags)

Several predefined options at once, each as a colored tag; new tags can be created right in the cell.

Formula

A value calculated automatically from other columns in the same row — including columns pulled from a linked table.

Attachment / File

One or more files or links stored with the row.

Image

A picture, from a URL or uploaded (up to 800 KB). In the Gallery view, the first Image column becomes the card cover.

URL / Link

Web address, shown as a clickable link that opens in a new tab.

Email

Email address, with a quick button to compose a message.

Phone

Phone number, formatted and clickable to dial.

Reference

Links the row to a note, contact, appointment or to one or more rows in another table.

Task

Links the row to a task from the Tasks module, with a button to open it there.

Autonumber

A sequential number assigned automatically to each row — a stable, read-only identifier.

Lookup

Pulls a value from the record linked by a Reference column (for example, the client's email via the "Client" reference).

Rollup

Aggregates a value across all records linked by a Reference: count, sum, average, minimum or maximum.

Reverse links

Shows which rows of another table point to this row through their Reference column — the automatic backlink.

Linking tables together

A Reference column pointed at another table is the building block of relations. Once it exists, you can layer on top of it: a Lookup column shows a field of the linked record, a Rollup column aggregates a field across all linked records, and a Reverse links column on the other table shows the relation from the opposite side. Formulas can also reach across with {Reference.Column}.

Options by type

• Currency: choose the currency (R$, US$, €, £, ¥) and the number of decimal places.
• Decimal number and Formula: set how many decimal places to show.
• Select / multi-select: register the list of options (each becomes a colored label).
• Reference: choose the source (note, contact, appointment or another table), and turn on "Multiple" to link several records at once. In the grid, a table reference can display as a chip or as an embedded mini table.
• Lookup: pick the Reference column to follow ("Via reference…") and the field of the target record to pull ("Field to pull…").
• Rollup: pick the Reference column, the field to aggregate and the function (count, sum, average, min, max).
• Reverse links: pick the source table and the Reference column that points here ("Linked via"). On a brand-new table, save the structure first, then pick the source column.
• Image: paste an image URL or upload a file of up to 800 KB.

System columns

Besides the columns you create, each table keeps automatic properties filled in by the app itself. They are hidden by default — show them through the system properties menu:

Created at

Date and time the row was created.

Created by

Who created the row.

Last edited by

Who made the last change.

Last edited

Date and time of the row's last change.

Last visited at

When the row was last opened.