Online Help

Types of user-defined fields

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

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

  • Logical - a boolean value (True or False). Logical fields appear on the screen as check boxes 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: If needed, you can customize the currency format.

  • String - a text up to 1000 characters long.

  • Memo - a block of binary data or text up to 1 GB in size. Memo fields appear on the screen as text boxes with the button in the upper-right corner to open the field contents in a new window.

  • Date - a date value.

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

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