Field types reference

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

表 : 1. Field types

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. 注: 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: String Boolean Integer Decimal Object Array
date	Other date	Yes	Field used to store date and time values without requiring a time zone. Unlike glide_date_time, which is converted to UTC in the database, this field retains the date and time exactly as entered, without any conversion.
datetime	Date/Time	Yes
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.
email	Email	Yes
email_script	Email Script	Yes	Field used to create dynamic email templates. It provides the ability to use field name notation (${fieldname}) to represent the dynamic value of variable. This field is a combination of text area and variable picker.
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	Floating Point Number fields use a default scale of 7, and the maximum length can't be set below 7 to ensure values can be stored and displayed correctly.
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	Yes
integer	Integer	Yes	Number field with zero decimal points. 注: 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	The int field type is used to store alphanumeric values similar to string field type.
integer_time	Integer time	Yes	Field used to store time values, similar to glide_time, but with a few key differences: The glide_time field stores the time as a fully formatted string (e.g., 1970-01-01 16:04:32), whereas the integer_time field stores it as a 6-digit string in a 24-hour format (e.g., 160432). glide_time supports time zones, meaning the displayed value changes based on the user's time zone settings. In contrast, integer_time does not support time zone adjustments and always displays the same time regardless of the user's location.
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. As of the Zurich release, radio buttons can be displayed both horizontally and vertically in the form view.
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	Yes	Field used to categorize and organize records by assigning tags. In the record page, The tags are editable using the option on the form and the same tags get reflected on the related_tags field type in a read only mode.
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. 注: 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. 注: 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. 注: 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	Yes	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