Column types

Every column type, and what each one does to the data inside it.

Every column has a type, and the type does real work: it validates what can be typed, formats what's shown, and picks the right editor (a date picker for dates, a star row for ratings, a color picker for colors).

Text	Short free text — names, titles, SKUs.
Long text	Longer notes; the editor grows to fit.
Number	Plain numbers. Sums appear in the table footer.
Currency	Money, always shown with two decimals. Sums in the footer.
Date	A calendar date, picked from a date picker.
Time	A time of day, stored 24-hour, shown as 12-hour with AM/PM.
Date & time	A date and a time together, in your local timezone.
Checkbox	A simple on/off tick.
Email	Validated as a real email address format.
Phone	Validated as a phone number.
URL	Validated as a web link.
Dropdown	One choice from a list of options you define.
Rating	A star rating out of 5.
Formula	Calculated live from other columns — see the Formulas article.
Checklist	A list of sub-items you can tick off, shown as “2/5 done”.
Color	A color value with a native color picker.
Address	A structured address (street, city, state, postal code, country).
Link to table	Points at a row in another table (or several, if you tick “allow multiple”) — e.g. an order line linking to its Product. The row-details view (the link icon on any row) also shows the reverse side: every row that links back to it.
File	An uploaded file (PDF, document, anything) stored privately in your workspace — click to open via a secure, expiring link.
Image	A picture upload, shown as a thumbnail in the grid — the same private storage as File, picked from your photo library or camera roll.
Created at	Set automatically to when the row was created. Read-only.
Created by	Set automatically to who created the row. Read-only, can't be faked.
Team member	Somebody on your team. Pick a person and the row is theirs — they can filter the table down to just their own rows with “Assigned to me”. It stores the account, not a typed name, so it keeps working when somebody’s name or email changes.
Lookup	Shows a value from a row you have linked to — follow one of this table's link columns and pick a column on the other side. An order line can show its product's SKU, price or category without anybody copying it across, so it can never fall out of step with the product row. Read-only.
Button	A button on every row. Choose what it does when you add the column: Invoice / PDF opens that row's printable bill, and Ship via courier books the parcel with NCM or Pathao using the credentials in Settings. Both are things you could already do by opening the row — the column puts them next to the row instead. Holds no value of its own, so it exports blank and an import cannot write to it.