Field types
- UpdatedJan 30, 2025
- 11 minutes to read
- Xanadu
- Platform Field Administration
These field types are available to administrators when creating fields or changing the type of existing fields.
Field type | Platform name | Supported in configurable workspace | Description |
---|---|---|---|
approval_rules | Approval Rules | No | |
audio | Audio | No | Audio field for uploading and embedding .mp3 or .ogg audio files. |
auto_increment | Auto Increment | Yes | |
auto_number | Auto Number | Yes | |
boolean | True/False | Yes | True/False field that holds a true or false value, typically displayed as a check box. |
bootstrap_color | Bootstrap Color | No | |
breakdown_element | Breakdown Element | No | |
calendar_date_time | Calendar Date and Time | No | |
catalogue_preview | Catalog Preview | No | |
char | Char | Yes | |
choice | Choice | Yes | Choice field that restricts values to a list of options, which is ideal for fields with a limited set of valid entries. For example, a priority field or a category field. |
collection | Collection | No | Collection field type that applies any changes made to the assigned field also to the entire table For example, changes such as attributes or the Read only check box that are applied to a table entry with this field type are applied to the table rather than a specific field. This entry is automatically created when a table is created. There shouldn't be more than one entry for a table of this type. |
color | Color | No | String field that accepts CSS color declarations,including hex or RGB notation, and displays a preview. For more information on CSS color declarations, go to the Mozilla developer web docs. See the "<color>" article. https://developer.mozilla.org/en-US/docs/Web/CSS/color_value. |
color_display | Color Display | No | |
composite_field | Composite Field | Yes | |
composite_name | Composite Name | No | |
compressed | Compressed | No | Compressed field that stores large binary data in a compressed format, reducing database storage requirements. It's used for files like images or documents, automatically compressing and decompressing data to optimize performance. This field type helps maintain efficient storage and database performance, especially when handling large volumes of data. |
condition_string | Condition String | Yes | Text field that accepts a plain JavaScript condition statement that is validated automatically for correctness before an update. |
conditions | Conditions | Yes | Field that adds the condition builder to a form. You must specify a dependent field that references the table name. |
counter | Counter | No | |
css | CSS | Yes | |
currency | Currency | Yes | Decimal field with four digits after the decimal
point. When displayed on a form, a Currency field also includes an additional list of choices for selecting the currency type. If there isn't a default value for the field, then empty Currency fields use the reference currency. Adding a value causes the field to use the session currency of the active user. See Change default currency decimal places for how to use two fraction digits. Note: After
you assign this field type to a field, you can’t change it to the FX Currency field type. |
currency2 | FX Currency | Yes | |
data_array | Data Array | No | |
data_object | Data Object | No | |
data_structure | Data Structure | No | Data structure field where you can select one of the following data structures and enter values to organize particular information in the record:
|
date | Other date | Yes | Date field that displays a day, which can be selected with a calendar widget. |
datetime | Date/Time | No | Date/Time field that can be selected with a calendar widget. It's used for date-specific entries and is ideal for timestamps and scheduling. |
day_of_week | Day of Week | No | |
days_of_weeks | Days of Week | Yes | |
decimal | Decimal | Yes | Number field with up to two digits after the decimal points. For example, 12.34. |
document_id | Document ID | Yes | Document ID field that references a record on a table. |
documentation_field | Documentation Field | Yes | Documentation field used by admins to add the label during table or field creation. |
domain_id | Domain ID | Yes | Domain ID field that contains a reference to the domain. |
domain_path | Domain Path | Yes | String field that contains a domain path, which is a series of three-character codes separated by a slash delimiter that uniquely identifies a domain. For more information on domain paths, see Domain Separation- Advanced Concepts and Configurations [KB0716268] article in the Now Support Knowledge Base. |
due_date | Due Date | Yes | Date field that stores a date and time. |
Yes | |||
email_script | Email Script | No | Email script field that provides the ability to use field name notation (${fieldname})to represent the value of that field. This is a combination of text area and variable picker component and can be used to create text templates that have variables. |
expression | Expression | No | |
external_names | External Names | No | |
field_list | Field List | Yes | |
field_name | Field Name | Yes | Reference field for a field name in the table that is selected in a Table Name field type. Make this field dependent on the Table Name field. |
file_attachment | File Attachment | Yes | File attachment field that can hold one file. All file types are supported. |
float | Floating Point Number | Yes | |
formula | Formula | No | |
geo_point | Geo Point | No | Geo point field for holding longitude and latitude coordinates. |
glide_action_list | Action List | No | |
glide_date | Date | Yes | |
glide_date_time | Date/Time | Yes | |
glide_duration | Duration | Yes | |
glide_list | List | Yes | |
glide_precise_time | Precise Time | No | |
glide_time | Time | Yes | |
glide_utc_time | UTC Time | Yes | |
glide_var | Var | No | |
glyphicon | Glyph Icon | No | |
graphql_schema | GraphQL Schema | No | |
GUID | Sys ID (GUID) | Yes | |
html | HTML | Yes | String field with a built-in HTML editor. It supports formatted text with rich text editor and is useful for descriptions that need enhanced readability. |
html_script | HTML script | Yes | HTML script field that provides the ability to add variables in the form of field name notation (${fieldname}) via a variable picker within the HTML editor. This field is used to create rich text content that also has dynamic values. |
html_template | HTML template | No | |
icon | Icon | No | String field that provides the user access to an icon picker in a form. By default, the favorites icon set is used. |
image | Image | No | Image field used for uploading and embedding images. |
index_name | Index Name | No | |
insert_timestamp | Insert Timestamp | No | |
int | Int | No | |
integer | Integer | Yes | Number field with zero decimal points. Note: To search for an integer, input = followed by the integer in the search bar. For example, if you want to search for an
Order of 100, input =100. |
integer_date | Integer date | Yes | |
integer_time | Integer time | No | |
internal_type | Internal Type | No | |
ip_addr | IP Address (Validated IPV4, IPV6) | Yes | |
ip_address | IP address | Yes | Variable character field that stores IPv4 and IPv6 addresses. See IP address field type for more information. |
journal | Journal | No | Journal field that accepts text entries and displays previous entries with a user name and timestamp. |
journal_input | Journal Input | Yes | Journal input field that accepts text entries but doesn't display previous entries. |
journal_list | Journal List | No | 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 depends on more than one journal field, the entries are displayed chronologically. |
json | JSON | Yes | |
json_translations | JSON Translations | No | |
language | Language | No | |
long | Long | Yes | Long field that stores large whole numbers, which can be useful for high-value data. This field handles values that exceed standard integer limits, which is essential in high-volume contexts like serial numbers or counting operations. This field ensures that numeric data is stored accurately without overflow. |
longint | Longint | Yes | Longint field that stores large whole numbers, which can be useful for high-value data. This field handles values that exceed standard integer limits, which is essential in high-volume contexts like serial numbers or counting operations. This field ensures that numeric data is stored accurately without overflow. |
mask_code | Mask code | No | |
metric_absolute | Metric Absolute | No | |
metric_counter | Metric Counter | No | |
metric_derive | Metric Derive | No | |
metric_gauge | Metric Gauge | No | |
mid_config | Mid Config | No | |
month_of_year | Month of Year | No | |
multi_small | Multi Small | Yes | Text area field that stores shorter texts like short descriptions and notes. |
multi_two_lines | Two Line Text Area | Yes | |
name_values | Name-Value Pairs | No | Name-value pairs field that maps text values. Each mapping is one-to-one, but a single Name-Value Pairs field can contain multiple mappings. Each mapping must use a unique
name, and the name can’t be empty. For example, you can use a Name-Value Pairs field to hold header information for a web service request. In this example, the name of each mapping is the header such as Content-Type and the value is the header value, such as Application/json. For information on scripting Name-Value Pairs fields, see Name-value pairs field type. |
nds_icon | NDS Icon | No | |
nl_task_int1 | NL Task Int1 | No | |
order_index | Order Index | Yes | Order index field that defines the display order of records in lists or hierarchies. By assigning a numeric value to each record, it enables admins to control the visual sequence, which is helpful for logically organizing tasks, categories, or items. This field type helps improve user experience by making the interface intuitive and orderly. |
password | Password (1 Way Encrypted) | Yes | Text field that stores passwords with one-way encryption. One-way encryption stores the password as a secure hash value that can't be decrypted. |
password2 | Password (2 Way Encrypted) | Yes | 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, see Password2 encryption with KMF. The length for password2 field values must be at least 255 characters. |
percent_complete | Percent Complete | Yes | Decimal field that renders a percent complete bar in lists. You can convert any existing Decimal field to a Percent Complete field. |
ph_number | Phone Number | Yes | |
phone_number | Phone Number (Unused) | Yes | |
phone_number_e164 | Phone number (E164) | Yes | String field that provides E164-compliant formatting and validation for telephone numbers. |
price | Price | Yes | Currency field that enables control over conversions and display. See Price fields for more information. |
properties | Properties | No | |
radio | Radio | Yes | Radio field that displays mutually exclusive options as radio buttons, letting users select only one choice. It’s suitable for simple, definitive decisions, like priority level or yes/no responses. This field type helps improve usability by presenting clear options for single-selection inputs. |
records | Records | No | |
reference | Reference | Yes | Query field that displays records from another table, which is crucial for relational data structures. |
reference_name | Reference Name | No | |
related_tags | Related Tags | No | |
reminder_field_name | Reminder Field Name | No | |
repeat_count | Repeat Count | No | |
repeat_type | Repeat Type | No | |
replication_payload | Replication Payload | No | |
schedule_date_time | Schedule Date/Time | No | |
schedule_interval_count | Schedule Interval Count | No | |
script | Script | Yes | 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_client | Script Client | No | |
script_plain | Script (Plain) | Yes | Text field that accepts JavaScript code input and provides controls, such as syntax checking and formatting. |
script_server | Script Server | No | |
short_field_name | Short Field Name | No | |
short_table_name | Short Table Name | Yes | Text field that stores a compact version of a table name, often used for efficiency in system configurations, URLs, or logs. It helps map the full table names to shorter identifiers, mainly for internal system use rather than direct user interaction. |
simple_name_values | Name-Value Pairs | Yes | |
slushbucket | Slushbucket | Yes | |
snapshot_template_value | Snapshot Template Value | No | |
source_id | Source ID | No | |
source_name | Source Name | No | |
source_table | Source Table | No | |
string | String | Yes | String field that holds a string of characters. Strings of up to 255 characters appear in a single-line text box. Anything 256 characters or over appears as a multi-line text box. Note: The database may translate the value that 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 aren't able to increase the max length of a string field to a value greater than 4000 through the application UI. Changes greater than 4000 require the CLOB data type in Oracle. If you require a field to be larger than 4000 characters, log an incident to request the change. |
string_boolean | String Boolean | No | |
string_full_utf8 | String (Full UTF-8) | Yes | String field that contains UTF-8 character encoding. This field type is restricted to the same maximum length that can be defined within the application UI as the String data type. Emojis are supported in the String (Full UTF-8) field type. |
structure | Structure | No | |
sys_class_name | System Class Name | Yes | System field that holds the table name. |
sys_class_path | System Class Path | No | |
sysevent_name | System Event Name | No | |
sysrule_field_name | System Rule Field Name | No | |
table_name | Table Name | Yes | 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. If you're in a scoped application, you can view only the tables of that scope. |
template_value | Template Value | Yes | |
time | Time | No | Time field that stores a time in the database as a Date/Time field, but only the time part of this field is used. Note: This field stores the date as 1970-01-01, which
doesn't fall within the dates for Daylight Savings Time (DST). As a result, the time isn't adjusted automatically for DST. If a custom feature uses time as a start time, the feature must adjust for DST, if
necessary. |
timer | Timer | Yes | |
translated | Translated | No | |
translated_field | Translated Field | Yes | |
translated_html | Translated HTML | Yes | HTML text field that displays translations based on the user's language. |
translated_text | Translated Text | Yes | Text field that displays translations based on the user's language. |
tree_code | Tree Code | No | |
tree_path | Tree Path | No | |
url | URL | Yes | String field that is a selectable URL field when locked. When configuring, there’s an option to allow/disallow links with or without HTTPS. Note: In the mobile UI, this field appears as a multi-line text field. The field saves as a single line with the line breaks removed. |
user_image | Image | Yes | |
user_input | User Input | No | User input field that captures input provided by users, typically in the context of workflows, surveys, or other interactive processes. This field enables users to enter text, select options, or provide other
types of input that can then be processed or stored for further use. The data collected through User Input fields is often used to guide decision-making in workflows or to gather information for reporting and analysis. It's a flexible field type that can be customized to fit various use cases where user interaction is required. |
user_roles | User Roles | Yes | |
variable_conditions | Variable Conditions | No | |
variable_template_value | Variable Template Value | No | |
variables | Variables | No | |
version | Version | Yes | |
video | Video | No | Video field for uploading and embedding video. |
week_of_month | Week of Month | No | |
wide_text | Wide Text | Yes | |
wiki_text | Wiki | Yes | String field with a built-in wiki text editor that accepts a simplified version of standard wiki text formatting. |
wms_job | WMS Job | No | |
workflow | Workflow | Yes | List field that displays a stage in a workflow. |
workflow_conditions | Workflow Conditions | No | |
xml | XML | Yes |