User-Defined Fields Screen Field Reference

Each row in the grid is a user defined field for the selected function or record. Click to add a row to the grid. Click to delete the active row from the grid. Click next to a row to display the card view. A card view shows the notable information for a row on a single screen, eliminating the need to scroll back and forth. See Grids for tips on using grids.

Field

Description

Sort

Displays a five-digit numeric value used to sort user-defined fields on the screen. If you want to override the sort value for the user-defined field, enter a new number.

Note: Sort values must be unique for each user-defined field within a given function.
Tip: You may want to leave gaps in your Sort values, such as intervals of ten. This makes it easy to insert or rearrange fields later.

Field Type

Click to select the field type for the user-defined field. .

  • Date - Creates a field with a icon that displays a date picker.

  • Yes or No - Creates a field with a icon that drops down to display Yes and No values (and a null value).

  • Rich Text - Creates a Formatted Text Editor field.

  • Text - Creates a plain text field.

  • Masked Text - Creates a masked text field, which enables advanced users to format the content of the user-defined field. You must specify the input mask for the masked text.

  • Item List - Creates a field with a icon that drops down to display a list of valid values that you specify.

  • Number (Integer) - Creates a number field that uses whole numbers (no decimals). You can specify upper and lower limits for the number.

  • Number (Decimal) - Creates a number field with decimals. You must specify the length and the number of decimal places for the decimal. You can specify upper and lower limits.

Field Name

Enter the label for the user-defined field that will appear in the interface.

Required

Select the checkbox to make the user-defined required in the interface.

Length

For a plain text field or a decimal field, enter the total length for the user-defined field.

Decimal Places

For a decimal field, enter the number of decimal places for the user-defined field. If more than the specified number of decimal places is entered, the application rounds the decimal to two places using standard rounding.

Item List

Enter the valid values for the user-defined field separated by commas. Note that the list will contain a null value as the first item.

Input Mask

For a masked text field, enter the input mask for the user-defined field.

Character

Description

#

Digit placeholder. Character must be numeric (0 through 9) and entry is required.

.

Decimal placeholder. The actual character used is the one specified as the decimal placeholder by the computer's international settings. This character is treated as a literal for masking purposes.

,

Thousands separator. The actual character used is the one specified as the thousands separator by the computer's international settings. This character is treated as a literal for masking purposes.

:

Time separator. The actual character used is the one specified as the time separator by the computer's international settings. This character is treated as a literal for masking purposes.

/

Date separator. The actual character used is the one specified as the date separator by the computer's international settings. This character is treated as a literal for masking purposes.

\

Treat the next character in the mask string as a literal. This allows you to include characters with special meanings in the mask (including #, &, A, and ?). This character is treated as a literal for masking purposes.

&

Character placeholder. Valid values for this placeholder are ANSI characters 32 through 126 (standard characters) and 128 through 255 (keyboard and foreign symbol characters).

Convert all the characters that follow to uppercase.

<

Convert all the characters that follow to lowercase.

A

Alphanumeric character placeholder. For example, a through z, A through Z, or 0 through 9. Character entry is required.

a

Alphanumeric character placeholder. For example, a through z, A through Z, or 0 through 9. Character entry is not required.

9

Digit placeholder. Character must be numeric (0 through 9) but entry is not required.

-

Minus sign when followed by a number section defined by series of n placeholders (for example, -nn,nnn.nn) indicates that negative numbers are allowed. When not followed by a series of n placeholders, it is taken as a literal. The minus sign will only be shown when the number is actually negative.

+

Plus sign when followed by a number section defined by series of n placeholders (for example, +nn,nnn.nn) indicates that negative numbers are allowed. However, it differs from - character in that it will always show a plus sign or a minus sign depending on whether the number is positive or negative.

C

Character or space placeholder. Character entry is not required. This operates exactly like the & placeholder, and ensures compatibility with Microsoft Access.

?

Letter placeholder. For example, a through z or A through Z. Character entry is not required.

n

Digit placeholder. A group of n placeholders can be used to create a numeric section where numbers are entered from right to left. Character must be numeric (0 through 9), but entry is not required.

mm, dd, yy

- or -

mm, dd, yyyy

The combination of these three special placeholders can be used to define a date mask: mm for months, dd for days, yy for two-digit years, and yyyy for four-digit years. For example, mm/dd/yyyy, yyyy/mm/dd, and mm/yy.

hh, mm, ss, tt

The combination of these four special placeholders can be used to define a time mask: hh for hours, mm for minutes, ss for seconds, and tt for AM/PM. For example, hh:mm, hh:mm tt, hh:mm:ss.

{date}

Short date placeholder. The date mask is derived using the computer's international settings.

{time}

Short time placeholder. Short time typically does not include seconds. The time mask is derived using the computer's international settings.

{longtime}

Long time placeholder. Long time typically includes seconds. The time mask is derived using the computer's international settings.

{double:i.f:c}

Floating point input placeholder. The i specifies the number of digits in the integer and the f specifies the number of digits in the decimal. The c is optional and it specifies that the inputting of the value is continuous across integer and decimal portions. For example, with the c in the mask, in order to enter 12.34 the user enters 1234 without entering the decimal separator character.

{double:-i.f:c}

Same as {double:i.f:c} except that negative numbers are allowed.

{currency:i.f:c}

Same as {double:i.f:c} except the mask is constructed based on currency formatting information of the computer's international settings. It typically has the currency symbol and also displays the group characters.

{currency:-i.f:c}

Same as {currency:i.f:c} except that negative numbers are allowed.

All characters that don't have special meanings as an input mask are displayed literally. Use the backslash (\) to display input mask characters—such as #, &, A, and ?—literally.

You can also escape the mask with {LOC} character sequence to indicate that symbols in the following table should be mapped to the associated symbols in the computer's international settings.

Character

Description

$

Currency symbol.

/

Date separator.

:

Time separator.

,

Thousands separator.

.

Decimal separator.

+

Positive sign.

-

Negative sign.

Lowest Value

For an integer or a decimal, enter the minimum value for the user-defined field.

Highest Value

For an integer or a decimal, enter the maximum value for the user-defined field.

Status

Click to select the status of the user-defined field. .

  • Active - User-defined field is available for use and appears on screens, forms, and reports.

  • Inactive - User-defined field is not available for use and does not appear on screens, forms, and reports.

Memo

Enter any comments or notes about the user-defined field.