New custom field

Use this form to create a new custom field.

Options:

• Custom field name - enter the name of the custom field under which the field will be displayed in the application to users. The custom field name must not match any other field of the entity (custom or system) or any other column of the reporting views.

• Order - specify the order in which the field should appear in the forms. Fields are displayed in ascending order based on the Order value. If two fields have the same Order value, their relative order will be random.

• Type - select the type of custom field from the menu.

  Type	Meaning	UI element in forms
  bit	logical value yes/no	checkbox
  date	date	date picker
  datetime	date and time	date picker and time input box
  float	decimal number with specified decimal places; For integer value use zero decimal places. Values are displayed with thousands separators.	text input box
  int	integer; Values are displayed as plain numbers without thousands separators. This type is suitable for numeric identifiers, e.g., a record number in an external system.	text input box
  nvarchar	text string	single-line or multi-line text input box
  user	a user of Alvao; In the database, this type is represented as type int containing the ID of a user (see tPerson.iPersonId).	dropdown menu

  • Decimal places - if you want to unify the format of displaying the values of the float data type, specify how many decimal places you want to display. Values will be rounded to the specified decimal places or trailing zeros will be added. If you leave this field blank, the values won't be rounded and no trailing zeros will be displayed in decimal section. This setting only affects the format of the display of values. The values will be stored in the database and can be edited as entered. This field is available from version 25.2.

  • Source group - if you want to offer only members of a user group in the user type field, select the user group.

  The following additional fields are only displayed for type nvarchar:

  • Multi-line text - turn on if you want forms to display a larger input field for entering multi-line text. If disabled, only single line input fields are displayed.

    This option cannot be combined with a list of values.

  • Length - specify the maximum length of text in characters that can be written to the entry.

  • Maximum length - turn on if you want to store long text in the field.

• Description - enter a description of the field that will be displayed in forms to help users fill in the field.

• Table - select the entity for which you want to create a custom field:

  Value in the menu (name of the table in the database)	Entity
  tHdTicketCust	Ticket
  tPersonCust	Person
  tAccountCust	Organization
  tHdSectionCust	Service
  tSlaCust	SLA
  LicHistCust	License
  ProductCust	Products
  TicketStateCust	Ticket status

• Column - enter the name of the column in the database where the value of this custom field will be stored. The name must be unique and must not contain spaces or special characters. It is recommended to name columns in English and to follow the recommendations for naming identifiers in the database.

• Use value list - the custom field will appear as a text box with a drop-down menu on forms. After enabling this option, populate the list of values with Edit - List of values.

  The list can only be used for nvarchar and int types. A value that is not listed in the list of values can also be written to a custom field of type nvarchar. The values of custom fields of type int are limited only to the values listed in the list of values, no other value can be written to them, and when modifying a value in the list of values, the value of the custom field is automatically changed.

• Enable translation of value list - enable this option if you want the values from the value list to be exported for translation into other languages and then displayed to users in their preferred language.