Field types — Sterodata docs

Every type you can give a field in Add Field: what it holds, the settings it takes, and how it shows in the grid.

Add Field offers 19 types, in five groups: Common, Contact, Linked records, Calculated and Advanced. Under each type the list shows an example of what it is for. Most types also take a Default value under Rules and default: see Default values.

Common

Type	What it holds	Settings	How it shows
Text	Words: names, codes, notes.	Validation pattern, under Rules and default: a pattern the text must match, such as five digits for a postcode, with a Test string box to try it. A value that does not match is shown in red and not saved.	As typed.
Number	Quantities, scores, counts.	Decimal places, from 0 to 10; 2 to start with.	In your workspace's number format, such as `1.234,50` or `1,234.50`.
Currency	Prices and amounts of money.	Decimal places; Currency, your workspace's own to start with; Multi-currency, so each record can have its own currency, with a Default currency and the Currencies offered. Multi-currency is only for tables kept in Sterodata.	The amount with its currency. A multi-currency amount has a currency menu beside it.
Percent	Rates and discounts.	Decimal places.	With a % sign. You type `15` to mean 15%; a formula reads it as 0.15.
Date and time	A due date, a hire date, a delivery slot.	Show Time, on to start with. Switch it off for a date alone.	In your workspace's date format, picked from a calendar. A date with a time is shown in each reader's own time zone; a date alone is the same day everywhere.
Checkbox	Yes or no: paid, approved.	None.	A box to tick.
Single select	One of a few choices, such as a status.	The choices, each with a colour; Sort order; Color-code options. See Choice fields.	A coloured label, picked from a list.
Multiple select	Several of a few choices, such as tags.	The choices, each with a colour; Color-code options.	One coloured label per choice.
Attachment	Photos, PDFs, documents.	Allow multiple files; Allowed file types: Images, Documents, Text Files, or all.	The files, each opening a preview. See Attachments.

Contact

Type	What it holds	Settings	How it shows
Email	An e-mail address.	None. An address that does not look like one is marked.	A link that opens your e-mail program.
Phone	A phone number: digits, spaces, `+ - ( ) .`	None. A number shorter than seven characters is marked.	With a phone icon; on a phone, a tap calls it.
URL	A web address.	Display label, words to show instead of the address; Display style, the link's colour: Default, Success, Error, Info or Warning.	The website's name, such as `example.com`, or your label. A click opens it.
User	A person in this workspace.	The person's fields to show, and Limit records. Not offered in a connected database. See Person fields.	The person's initials and name.

Linked records

Type	What it holds	Settings	How it shows
Linked record	A record of another table, such as an order's customer.	Related table, Display columns, Limit records. See Links between tables.	The linked record's display columns, picked from a searchable list.
Lookup	The records of another table that match a condition, such as the price list row for an order's product code.	The table, Display columns, Limit records, Formula, Allow multiple matches. See Lookups.	Like a link; worked out, never typed.
Rollup	A figure worked out over the records that link to this one, such as a customer's total orders.	Rows of, Linked by, Calculate, Of, Limit records. See Rollups.	As the figure it answers: an amount, a number, a date.

Calculated

Type	What it holds	Settings	How it shows
Calculation	A value worked out from the record's fields by a formula, such as quantity times price.	Formula, and Display as for how the result is formatted. See Calculations.	As its result, always up to date; never typed.

Advanced

Type	What it holds	Settings	How it shows
JSON	Structured data, as an integration sends it.	None.	As data you open and change with Edit JSON. It cannot be sorted, filtered or grouped by; a formula can read values out of it.
Actions	Buttons that run an action on the record, such as sending it to another system.	+ Add button, then Pick an action from your workspace's integrations. See Integrations.	A button per action in each row.

What every table has besides

Each table kept in Sterodata also has Created by, Created at, Updated by and Updated at, filled in by Sterodata: see Who created and changed a record.

An attachment, a JSON field or an actions field cannot be sorted, filtered or grouped by. A multiple select field can be filtered but not sorted or grouped by. A calculation or a rollup cannot be grouped by.