Types of User-Defined Fields

Updated 1 year ago by Isabelle

You can create different types of user-defined fields depending on the types of values required for the field. Maximizer defines the following types of user-defined fields:

  • Alphanumeric user-defined fields – These fields record any alphanumeric text (letters and numbers) up to a specified maximum number of characters. You can encrypt alphanumeric fields for security protection. Note that you cannot disable or enable encryption once you have created the field.

Encrypted user-defined fields cannot be transferred, imported, or exported. They are also not searchable.

You can use alphanumeric user-defined fields to record URLs for entries. The fields are displayed as hyperlinks in Key Fields lists.

  • Date user-defined fields – These fields store a specific date or an annually recurring date.

  • Duration user-defined fields – These fields calculate the duration between another date basic or user-defined field and the current date. Because they are calculated from values of other fields, values for duration fields can be viewed in entries but cannot be set manually.

  • Formula user-defined fields – These fields calculate values based on other basic or user-defined fields. Formula user-defined fields can return alphanumeric, date, or numeric values. Because they are calculated from values of other fields, values for formulas fields can be viewed in entries but cannot be set manually.

  • Numeric user-defined fields –  These fields record numeric values. You can specify a number of decimal places. For example, specify two decimal places to use this type of field for monetary values. You can also specify that currency symbols are displayed with the field.

  • Table user-defined fields – These fields enable you to select a value or values from a list. This type of field is very useful for multiple choice or multiple value fields. If you create a table user-defined field with the “single value only” attribute, only one value can be selected from the list.

  • Yes/no user-defined fields – These fields record either yes or no values. Since the fields must contain one of these values, these user-defined fields are always mandatory.


How did we do?