Product documentation Docs
    • English
    • Deutsch
    • 日本語
    • 한국어
    • Français
  • More Sites
    • Now Community
    • Developer Site
    • Knowledge Base
    • Product Information
    • ServiceNow.com
    • Training
    • Customer Success Center
    • ServiceNow Support Videos
  • Log in

Product documentation

  • Home
How search works:
  • Punctuation and capital letters are ignored
  • Special characters like underscores (_) are removed
  • Known synonyms are applied
  • The most relevant topics (based on weighting and matching to search terms) are listed first in search results
Topics are ranked in search results by how closely they match your search terms
  • A match on the entire phrase you typed
  • A match on part of the phrase you typed
  • A match on ALL of the terms in the phrase you typed
  • A match on ANY of the terms in the phrase you typed

Note: Matches in titles are always highly ranked.

  • Release version
    Table of Contents
    • Now Platform administration
Table of Contents
Choose your release version
    Home Orlando Now Platform Administration Now Platform administration Field administration Field types

    Field types

    • Save as PDF Selected topic Topic & subtopics All topics in contents
    • Unsubscribe Log in to subscribe to topics and get notified when content changes.
    • Share this page

    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, it is also changed in the parent table and all other child tables.
    Note: If a table column identifier is created using Kanji characters, it is ignored in any update or insert operation from a form. Kanji characters are not currently supported.
    Table 1. Field types
    Field Type Description
    Audio Field for uploading and embedding .mp3 or .ogg audio files.
    Choice List of configurable choices.
    Collection Dictionary entries with the Collection type represent the table rather than a field on the table. Changes such as attributes or the Read only check box applied to this entry are applied to the table rather than a specific field. This entry is automatically created when a table is created. There should not be more than one entry for a table of this type.
    Color String field that accepts CSS color declarations (including hex or RGB notation) and displays a preview. To learn more, see https://developer.mozilla.org/en-US/docs/Web/CSS/color_value.
    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 default currency decimal places for how to use two fraction digits.
    Note: Once you assign this type to a field, you cannot change it to an FX Currency type.
    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 record 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 appears 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.
    File Attachment Field for holding a file. A field holds one file. All file types are supported.
    Floating Point Number Number with up to seven digits after the decimal point.
    FX Currency Also known in internal code as Currency2 fields, this field type is an alternative to the standard (default) currency fields found in most Now Platform® applications. This type of currency field is highly configurable, supports custom rate tables, report aggregations, and provides for improved visibility into conversion calculations. To learn more about the FX Currency field type, see Setting up and using FX Currency fields.
    Note: Once you assign this type to a field, you cannot change it to an Currency type.
    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.
    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.
    IP address Variable character field that stores IPv4 and IPv6 addresses. See IP address field type for more information.
    Journal Field that accepts text entries and displays previous entries with a user name and time stamp.
    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 depends 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.
    Name-Value Pairs

    Field that maps text values. Each mapping is one-to-one, however a single Name-Value Pairs field can contain multiple mappings. Each mapping must use a unique name, and the name cannot 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.

    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. You can convert any existing decimal field to a percent complete field.
    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 255 characters or less, the string field is a single-line text field. 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 are not 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 (Full UTF-8) A string field that can contain UTF-8 character encoding. This field has the same restriction as the String data type as to maximum length that a user can define within the application UI. &&&&

    Emoji Support: The String (Full UTF-8) field type does, and should be used if we expect to use emojis in a field. There is slightly more overhead when using the Full UTF-8 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 that are based on the user's language.
    Translated Text Text field that displays different translations that are based on the user's language.
    True/False Boolean field that appears as a one-digit integer, typically 1 (true) or 0 (false).
    URL String field that is a clickable URL field when locked.
    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.
    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.

    Tags:

    Feedback
    On this page

    Previous topic

    Next topic

    • Contact Us
    • Careers
    • Terms of Use
    • Privacy Statement
    • Sitemap
    • © ServiceNow. All rights reserved.

    Release version
    Choose your release version

      Field types

      • Save as PDF Selected topic Topic & subtopics All topics in contents
      • Unsubscribe Log in to subscribe to topics and get notified when content changes.
      • Share this page

      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, it is also changed in the parent table and all other child tables.
      Note: If a table column identifier is created using Kanji characters, it is ignored in any update or insert operation from a form. Kanji characters are not currently supported.
      Table 1. Field types
      Field Type Description
      Audio Field for uploading and embedding .mp3 or .ogg audio files.
      Choice List of configurable choices.
      Collection Dictionary entries with the Collection type represent the table rather than a field on the table. Changes such as attributes or the Read only check box applied to this entry are applied to the table rather than a specific field. This entry is automatically created when a table is created. There should not be more than one entry for a table of this type.
      Color String field that accepts CSS color declarations (including hex or RGB notation) and displays a preview. To learn more, see https://developer.mozilla.org/en-US/docs/Web/CSS/color_value.
      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 default currency decimal places for how to use two fraction digits.
      Note: Once you assign this type to a field, you cannot change it to an FX Currency type.
      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 record 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 appears 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.
      File Attachment Field for holding a file. A field holds one file. All file types are supported.
      Floating Point Number Number with up to seven digits after the decimal point.
      FX Currency Also known in internal code as Currency2 fields, this field type is an alternative to the standard (default) currency fields found in most Now Platform® applications. This type of currency field is highly configurable, supports custom rate tables, report aggregations, and provides for improved visibility into conversion calculations. To learn more about the FX Currency field type, see Setting up and using FX Currency fields.
      Note: Once you assign this type to a field, you cannot change it to an Currency type.
      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.
      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.
      IP address Variable character field that stores IPv4 and IPv6 addresses. See IP address field type for more information.
      Journal Field that accepts text entries and displays previous entries with a user name and time stamp.
      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 depends 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.
      Name-Value Pairs

      Field that maps text values. Each mapping is one-to-one, however a single Name-Value Pairs field can contain multiple mappings. Each mapping must use a unique name, and the name cannot 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.

      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. You can convert any existing decimal field to a percent complete field.
      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 255 characters or less, the string field is a single-line text field. 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 are not 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 (Full UTF-8) A string field that can contain UTF-8 character encoding. This field has the same restriction as the String data type as to maximum length that a user can define within the application UI. &&&&

      Emoji Support: The String (Full UTF-8) field type does, and should be used if we expect to use emojis in a field. There is slightly more overhead when using the Full UTF-8 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 that are based on the user's language.
      Translated Text Text field that displays different translations that are based on the user's language.
      True/False Boolean field that appears as a one-digit integer, typically 1 (true) or 0 (false).
      URL String field that is a clickable URL field when locked.
      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.
      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.

      Tags:

      Feedback

          Share this page

          Got it! Feel free to add a comment
          To share your product suggestions, visit the Idea Portal.
          Please let us know how to improve this content

          Check any that apply

          To share your product suggestions, visit the Idea Portal.
          Confirm

          We were unable to find "Coaching" in Jakarta. Would you like to search instead?

          No Yes
          • Contact Us
          • Careers
          • Terms of Use
          • Privacy Statement
          • Sitemap
          • © ServiceNow. All rights reserved.

          Subscribe Subscribed Unsubscribe Last updated: Tags: January February March April May June July August September October November December No Results Found Versions Search preferences successfully updated My release version successfully updated My release version successfully deleted An error has occurred. Please try again later. You have been unsubscribed from all topics. You are now subscribed to and will receive notifications if any changes are made to this page. You have been unsubscribed from this content Thank you for your feedback. Form temporarily unavailable. Please try again or contact  docfeedback@servicenow.com  to submit your comments. The topic you requested does not exist in the release. You were redirected to a related topic instead. The available release versions for this topic are listed There is no specific version for this documentation. Explore products Click to go to the page. Release notes and upgrades Click to open the dropdown menu. Delete Remove No selected version Reset This field is required You are already subscribed to this topic Attach screenshot The file you uploaded exceeds the allowed file size of 20MB. Please try again with a smaller file. Please complete the reCAPTCHA step to attach a screenshot
          Log in to personalize your search results and subscribe to topics
          No, thanks Login