Field types

These field types are available to administrators when creating new fields or changing the type of existing fields.

Note: If you edit a field on a child table that is present on the parent table, you will also change it for the parent table and all other child tables.
Table 1. Field types
Field Type Description
Audio Field for uploading and embedding .mp3 or .ogg audio files.
Choice Drop-down list of choices that can be configured.
Color String field that accepts CSS color declarations (including hex or RGB notation) and displays a preview. See:
Condition String Text field that accepts a plain JavaScript condition statement that is validated automatically for correctness before an update.
Conditions Field that adds the condition builder to a form. You must specify a dependent field that references the table name.
Currency Decimal field with four digits after the decimal point. When displayed on a form, a currency field also includes an additional choice list for selecting the currency type. If there is no default value for the field, empty currency fields use the reference currency. Adding a value causes the field to use the session currency of the active user. See Change currency decimal places for how to use two fraction digits.
Data Structure Field that allows the selection of one of the following data structures and entry of values to organize particular information in the record.
  • String
  • Boolean
  • Integer
  • Decimal
  • Object
  • Array
Date Day, which can be selected with a calendar widget.
Date/Time Day and time of day, which can be selected with a calendar widget.
Decimal Number with up to two digits after the decimal points (for example, 12.34).
Document ID Reference to any field on any table.
Domain ID System field that contains a reference to the domain.
Due Date String input field that stores a date-time.
Duration Length of time. Stored in the database as an integer number of milliseconds, but displays in days, hours, minutes, and seconds.
Encrypted Text Field that is encrypted for security. Depending on the user's encryption context, the field may be hidden, the value may be hidden, or the field and value may display.
Field Name Reference field for a field name in the table selected in a Table Name field type. Make this field dependent on the Table Name field.
Floating Point Number Number with up to seven digits after the decimal point.
HTML String field with a built-in HTML editor.
Icon String field that provides the user access to an icon picker in a form. By default, the favorites icon set is used.
Image Field for uploading and embedding images.
Integer Number with zero decimal points.
Journal Field that accepts text entries and displays previous entries with a user name and timestamp.
Journal Input Field that accepts text entries but does not display previous entries.
Journal List Field that displays the contents of journal fields. You must specify the journal fields as the dependent fields. If a journal list field is dependent on more than one journal field, the entries are displayed chronologically.
List Reference field that accepts multiple references rather than just one.
Long Integer field that can contain a longer number than the integer field.
Password (1 Way Encrypted) Text field that stores passwords with one-way encryption. One-way encryption stores the password as a secure hash value that cannot be decrypted.
Password (2 Way Encrypted) Text field that stores passwords with two-way encryption. Two-way encryption stores the password as a secure encrypted value that can be decrypted programmatically within the instance. You can use Password 2 encryption with form variables. To encrypt text fields on forms, use Encryption Contexts. The length for password2 field values must be at least 255 characters.
Percent Complete Decimal field that renders a percent complete bar in lists.
Phone Number (E164) String field that provides E164-compliant formatting and validation for telephone numbers.
Price A currency field that enables control over conversions and display. See Price fields for more information.
Reference Query that displays records from another table.
Script Text field that accepts JavaScript code input and provides controls, such as syntax checking and formatting. It also provides a list of fields and server APIs. You must specify a dependent field that references the table name for the list of fields.
Script (Plain) Text field that accepts JavaScript code input and provides controls, such as syntax checking and formatting.
String

For 254 characters or less, the string field will be a single-line text field. Anything 255 characters or over will appear as a multi-line text box.

Note: The database may translate the value you provide in the Max length field to the closest matching database field type. For example, a max string length of 80 maps to the nearest database field type of VARCHAR(100).

For Oracle instances, users will not be able to increase the max length of a string field to anything greater than 4000 through the application UI as this requires the CLOB data type in Oracle. If you require a field to be larger than this, you can log an incident to request that our DBA make this change for you.

String (Full UTF-8) A string field that can contain UTF-8 character encoding. The description above about the number of characters applies to this field type.
Suggestion String field that provides suggested values but accepts free-form text. Available when you add a field by configuring a form or list. Otherwise, you must modify the dictionary entry of an existing string or journal field.
Table Name String field that lets you select a table. If you use the Field Name field type, add this field type and make the Field Name field dependent on the Table Name field.
Time Specific time. Stored in the database as a date/time field. Only the time part of this field is used.
Note: This field always stores the date as 1970-01-01, which does not fall within the dates for daylight savings time (DST). As a result, the time is not automatically adjusted for DST. If a custom feature uses time as a start time, it is the responsibility of the feature to adjust for DST, if necessary.
Translated HTML HTML field that displays different translations based on the user's language.
Translated Text Text field that displays different translations based on the user's language.
True/False Boolean field that appears as a check box.
URL String field that is a clickable URL field when locked.
Video Field for uploading and embedding video.
Wiki String field with a built-in Wiki text editor that accepts a simplified version of standard Wiki text formatting.
Workflow Choice list field that displays a stage in a workflow.
Note: When you create a custom field, use one of these supported field types. Other field types, such as User Input, are for internal use only and are not supported for custom fields.