Field types - Product Documentation: Washington DC

Field types

Administer the Now Platform > Configure Now Platform Core Features > Now Platform forms, fields, and lists >

Field types

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

Table 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 " " 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: String Boolean Integer Decimal Object Array 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. email Email 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

Choice list field type A choice list is a type of field that lets the user select from a pre-defined set of choices. Condition field types A condition field specifies when to run business logic such as a business rule or workflow. Database field type Several field types are available in the system. Dictionary entry data types You can only change a dictionary entry's data type when the change does not result in data loss. Use the following guidelines to change a dictionary entry's data type. Document ID field You can create document ID fields to reference any record on any table. Function field Create function fields and scripts in the Now Platform to perform common database transformations and calculations. Geo point field type The geo point data type stores longitude and latitude coordinates. HTML field type The HTML editor provides WYSIWYG (what you see is what you get) functionality and HTML source mode editing. Administrators can customize some of the functionality associated with HTML fields. Image field type Image fields enable you to add images to forms. IP address field type The IP Address (Validated IPV4, IPV6) [ip_addr] field type stores valid IPv4 and IPv6 addresses. Journal field type There are three types of journal field: journal, journal_list, and journal_input. Name-value pairs field type You can access the values stored in a name-value pairs field in scripts using the name. Percent complete field type Administrators can create percent complete fields, which accept decimal input and appear as progress bars when displayed in lists. Phone number field type The E.164 phone number standard ensures that all necessary information for a phone number is included and properly formatted to successfully route an international call over a territory's public telephone network. Reference field type A reference field stores a reference to a field on another table. For example, the Caller field on the Incident table is a reference to the User [sys_user] table. Suggestion field type To help users find what they are looking for, you can add a suggestion field to any form. Wiki field type Wikitext fields use the basic wiki markup language and support links to external URLs and to sources within the system.

Parent Topic: Field administration