Field types

Pick a field’s type from the Type list when you add or edit a field. Title isn’t in the list: every data type already has its one Title field.

Type	What it holds	Rules you can set
Title	The value that identifies each record, such as a code. Every data type has one, and it is always the first field. Spaces between words are allowed.	None. It is always required, unique and shown.
Text	Free text, such as a name or an address.	Default value
Number	A number, such as a price or a weight.	Minimum, Maximum, Decimal places, Default value
Option	One choice from a list you type in Options.	Options, Default value
Multi option	Several choices from the list in Options.	Options, Minimum choices, Maximum choices (no Required switch)
Checkbox	Yes or no.	None
Date	A date.	Minimum, Maximum, Default value
Date & time	A date and a time.	Minimum, Maximum, Default value
Time	A time of day, such as an opening time.	Minimum, Maximum, Default value
Coordinate	A latitude and longitude, such as `-6.2088,106.8456`.	None
Phone number	A phone number of 10 to 16 digits.	Default value
Relation	A link to a record of another data type, or to a user, hub, vehicle, role or flow.	Target, Relationship, Unique

Options

For Option and Multi option, type each choice in Options and press Enter. A field needs at least one option. The same choice can’t be listed twice.

Minimum and maximum

For a Number, the lowest and highest value allowed, and the number of Decimal places, which is how many digits are allowed after the decimal point. When you fill in a record, use a dot as the decimal separator, for example 1250.75. Numbers are stored and shown with a dot in every language.
For a Multi option, how many choices must be picked at least and at most.
For Date, Date & time and Time, the earliest and latest value allowed. Each bound is either A fixed value or another date field of the same data type, so an End Date can be required to be after the Start Date. Choose Same or later / Later only for the minimum, and Same or earlier / Earlier only for the maximum.

The minimum can’t be greater than the maximum.

Relation

A Relation field links each record to another record.

Target: what the field links to. Choose another of your data types under Data source, or a User, Hub, Vehicle, Role or Flow under the built-in data group.
Relationship: One links each record to a single target record; Many links it to several. The collapsed row shows this as Single or Multiple.
Unique: with a One relationship, only one record may point at the same target, which makes the link one-to-one. With a Many relationship, each picked record can appear in only one record of this data type. When the data type has Scope Data by Hub on, this applies within each hub: two records in different hubs may point at the same target.

For a link to a Hub, one more switch appears: Limit to the user’s own hubs, so people can only pick the hubs they belong to. Once a relation field is saved, its target and relationship can’t be changed. The field then says The target and relationship can’t change here: delete this field and add a new one instead. When another data type links to this one, a Related records box appears on this data type’s page, beside Unique together. It lists every field that points here, for example Store, via its “Customer” field. Turn one on to show the linked records on this data type’s records too: a customer then shows all of its stores. See Linked records.

Range types from earlier versions, such as a number range or a date range, can’t be added to a new field.

Getting Started

Analytics

Planning

Monitoring

Activities

Workflow

Export & Import

Settings

Account

Add-ons

Field types

Options

Minimum and maximum

Relation

Options

Minimum and maximum

Relation

Related records on the target