Basic Field Types

Text, number, date/time, auto-generated number sequence and checkbox fields

These are the core types of fields by which data can be entered by users (or other sources such as the API or a workflow).


Text fields are the most commonly used. Depending on field options, text can be entered into a standard data entry control, a large box allowing rich formatting (bold, italic etc.), chosen from a dropdown of options or added as tags.


When adding a number field, select a precision from the dropdown. If 0 is chosen, then it will be a whole number (integer) field. If any other value is chosen, it will be a decimal field. The decimal precision can be changed at any time in the field options, but a whole number can’t be converted to a decimal or vice versa via field options.

See changing field types for more information.


Represents a date or date/time, of any precision from year to second.

Auto-generated number sequence

The value of this field will be generated automatically, incremented by one each time a record is created.

Sequence numbers are never rolled back, even on the deletion of a record, so they can’t be used if a gapless assignment of numbers is required. To accomplish that, calculate a value with a cross-referenced field.


Adding a relation creates a link from one table to another. For example, a contacts table may contain a relation linking to an organisations table, to allow a person to belong to an organisation. See relational database concepts for further info.


Represents a boolean (true or false) value.

Last modified November 27, 2023: Pivot table example (80c844c)