Field types

These field types are available to administrators when creating 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 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 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. Specify a dependent field that references the table name.
Currency Decimal field with two digits after the decimal point. When displayed on a form, a currency field also includes an extra choice list for selecting the currency type. If there is no default value for the field, empty currency fields use the default system currency. Adding a value causes the field to use the preferred currency of the active user.
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 a positive integer number of milliseconds, but displays in days, hours, minutes, and seconds. Negative duration values are not supported.
Encrypted Text Field that is encrypted for security. Depending on the user's encryption context, the field can be hidden, the value can be hidden, or the field and value can 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.
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. 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.
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.
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 Decimal field with an additional list for currencies.
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. 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 is a single-line text field. Anything 255 characters or over appears as a multi-line text box.

Note: The database translates 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 are not able to increase the max length of a string field to anything greater than 4000 through the application UI because the increase requires the CLOB datatype in Oracle. If you require a field to be larger than the max length, you can log an incident to request that a DBA change the max length for you.

String (Full UTF-8) A string field that can contain UTF-8 character encoding. The string restriction on 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 string in milliseconds, but displays in hours, minutes, and seconds.
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 Wikitext editor that accepts a simplified version of standard Wikitext 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.

Modify string field length

You can modify the maximum character limit for a string field.

Before you begin

Role required: personalize_dictionary

Procedure

  1. Right-click the field label in the form and select Configure Dictionary.
  2. Change the Max length field to the desired length.
    Note: You can change between string-based data types as long as length changes do not cause any data loss from truncation. For example, you can change from a MEDIUM database type to a VARCHAR(100) database type if none of the existing data is greater than 100.
  3. Click Update.
    The system cancels any length change that results in data loss due to truncation.

Enable the text field character counter

By default, multi-line text fields have a 4000 character limit. To help users see how many characters remain before they reach the limit, you can enable the glide.ui.textarea.character_counter property.

Before you begin

Role required: admin

About this task

This property adds a counter under text fields, such as the Additional Comments and Work notes fields. The counter is dynamically updated as users enter text.

Procedure

  1. Navigate to System Properties > UI Properties.
  2. Select the check box next to Character counter for textarea (journal and multi line text fields).
  3. Click Save.
    Characters left