Field data types

This guide explains the different field data types available, what each type is used for, and how to recognise them in the interface. Each field shows an icon next to its name to indicate its data type.

Number

Use number fields to store numeric values. When you choose a number field, you also select a numeric type to control how the value is interpreted and displayed.

Number type fields can have additional formatting applied using a formatting expression when you need more control over how values are displayed.

Icon: 123, % or $ depending on the numeric type

Numeric types

• Number: Stores a plain numeric value. Use this when you do not want a predefined display format such as currency or percentage.
• Currency: Stores a numeric value formatted as a currency. By default, this uses the currency of the root table unless you apply a currency expression.
• Percentage: Stores a numeric value displayed as a percentage.
• Unit: Stores a numeric value associated with a unit of measure. This requires an additional input of a unit expression.
• Identifier: Stores a numeric value used as an ID or reference number.

Text

Use text fields to store words or free‑form strings, such as names or descriptions.

Icon: abc

Yes/No

Use yes/no fields to store a true or false value.

Icon: Check box

Date

Use date fields to store a calendar date without a time.

Icon: Calendar

Date & time

Use date & time fields to store both a date and a time value.

Icon: Calendar

Image

Use image fields to store images.

Icon: Picture

Binary

Use binary fields to store raw binary data, such as encoded files or system-generated values.

Icon: 1010

Dynamic fields

Dynamic fields use a parameter value instead of a fixed field. These fields are identified by a star icon next to the field name.

Icon: Star