Basic Field Types
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.
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.