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

Right-click the field label in the form and select Configure
Dictionary.

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.

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

Navigate to System Properties > UI Properties.

Select the check box next to Character counter for textarea (journal
and multi line text fields).