Administration Guide

User-defined field types

Updated in 2022.1

Alloy Navigator Express supports the following types of user-defined fields:

  • Integer — an integer value between -99999999 and 99999999.

  • Logical — a boolean value (True or False). Logical fields appear as check boxes in object details windows and forms or as check marks in grids.

  • Currency — a currency value, which consists of a decimal value and a currency symbol, e.g. $500.00.

    NOTE: You can customize the currency format, if needed. For details, see Customizing the currency format.

  • Float — a decimal floating-point value. A Float field allows up to 15 digits, of which 9 can be to the right of the decimal. When creating fields of this type, you can specify a number of decimal places which will be used as a format for input and display of values.

  • String — a text up to 1000 characters long.

  • Memo — a text up to 1 GB in size. Memo fields appear in object details windows and forms as text boxes with a special icon in the upper-right corner that opens the field contents in a new window.

  • Encrypted — a text up to 1000 characters long that should be stored securely. The field of this type allows users to store and display sensitive data in encrypted form. Encrypted values can be read by business logic operations. Encrypted fields with no data or NULL value are displayed as blank.

  • Date — a date value.

  • Date/Time — a date and time value (a timestamp).

  • Duration — a time duration value.

    NOTE: You can customize the duration format, if needed. For details, see Customizing the duration format.

  • Lookup — a select field where the user can choose a value from a list of available items. These fields appear as drop-down lists.

  • Multi-select — a select field where the user can choose multiple values from a list of available items. These fields appear as drop-down lists.

  • Reference — a reference to another object in the Alloy Navigator database. Reference fields appear on the Form as searchable drop-down lists. You can filter this list to display only certain items to the user.

  • Lookup — a field where the user can choose a value from a list of available items. Lookup fields appear in object details windows and forms as drop-down lists.
  • Reference — a reference to another object in the database. Reference fields appear in object details windows as searchable drop-down lists.

    NOTE: Currently, Alloy Navigator Express supports references to Person records only.