Online Help | Desktop App

Types of user-defined fields

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

NOTE: UDFs for Network Inventory do not support the reference type.

  • Integer: An integer value between -99999999 and 99999999.

  • Logical: A boolean value (True or False). Logical fields appear on the screen as checkboxes or as check marks in data grids.

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

    TIP: You may want to customize the currency format as needed.

  • 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.

  • 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.

  • Memo: A multi-line text up to 1 GB in size. Memo fields appear on the screen as text boxes with the button in the upper-right corner that opens the field contents in a new, separate window.

  • Date: A date value with a date picker.

  • Date/Time: A date and time value (a timestamp) with a date/time picker.

  • Duration: A time duration value.

    TIP You may want to customize the duration format as needed.

  • Reference: A reference to another object in the database. Reference fields appear on the screen as searchable drop-down lists.

    NOTE: Currently, Alloy Navigator Express supports references to Person records only, allowing to choose any person fro the list of persons or a techician from the list of technicians.

  • Lookup: A select field where the user can choose a single item from a list of available items. Lookup fields appear on the screen as drop-down lists.

  • Multi-Select: A select field that allows users to choose multiple items from a list. Fields with up to 5 items appear as checkboxes on forms, while fields with 6 or more items are displayed as drop-down lists with multi-selection enabled.