Set Data Type

In this step you select what data type and formatting you want for your field.

Actions

Choose data type and format for your custom field.

Data Type Description Format
Text A field where text can be entered.
  • Unformatted
    Both uppercase and lowercase letters can be entered and shown.
  • Uppercase
    Only uppercase letters can be entered and shown.
  • Lowercase
    Only lowercase letters can be entered and shown.
Number A field where numbers can be entered.
  • Unformatted
    The number is displayed without any formatting.
  • Decimal
    The number is displayed with decimal representation.
  • Currency
    The number is displayed with currency formatting.
Date A field where dates can be entered.
  • Date
    Only the date section of the date is displayed.
  • Date & Time
    Both date and time is displayed.
  • Time
    Only the time section of the date is displayed.
Enumeration A field where you can select a value from a predefined set of values.
  • Normal
    One value can be selected from a set of values in a combo box.
  • Boolean
    One of two values can be selected in the form of a check box.
  • Multi
    Multiple values can be selected from a set of values in a combo box.
Reference A field where you can reference one existing record from another LU.
  • Restricted
    Referenced records cannot be deleted without removing this reference.
  • Set Null
    Referenced records can be deleted, this reference will be set to null if so.