Skip to main content
Version: 1.21.3

Column Override

The override functionality allows you to change the column value and attributes in the child tables extended from the base table. For example, a column override changes the default value of the Impact field from Low in the Task table to Medium in the Incident table.

To create a column override, complete the following steps:

  1. Navigate to System Settings → Column Overrides.
  2. Click New and fill in the fields.
  3. Click Save or Save and exit to apply the changes.

Alternatively, you can create a record using the Column Override related list.

Column Override form fields

FieldMandatoryDescription
Base tableYSelect a table containing the field to override.
TableYSelect the child table that will be affected by overriding.
ColumnYSelect a column to be overridden.
Display by ref overrideNSelect this checkbox to use the values of the Column as the Display Name in the Reference fields that refer to the Table.
Default value overrideNSelect this checkbox to display the Default value field. In the field that appeared, enter the default value that will override the original one.
Note that using the override functionality for read-only fields that have the dynamic default value may cause validation errors. As a workaround, you can set a read-only attribute for these fields with a client script using the SimpleForm methods.
Dependent on column overrideNSelect this checkbox to display the Dependent on column field. In the field that appeared, define the column on which the current field depends.
Reference qualifier overrideNSelect the checkbox to display the Reference Qualifiers field setTo override the reference qualifier, complete the fields:
  • In the Reference field, select a table that the overriding column refers to.
  • In the Reference qualifier type field, select the reference qualifier type (Simple or Dynamic).
  • In the Reference qualifier condition field, build a reference filter that will meet the necessary conditions.
  • In the Dynamic reference qualifier field, select the reference qualifier type from the table. (This field appears when the Reference qualifier type field value is Dynamic.)
Title overrideNSelect the checkbox to display the Title field. To override the field, enter the new title. That is, a child table will inherit the properties of the parent table's column, but the title will be different.
Mandatory overrideNSelect the checkbox to display the Mandatory checkbox to override the behavior of the field on the extended table.
Read only overrideNSelect this checkbox to display the Read only checkbox to override the behavior of the field on the extended table.

Override example


For example, you need to override the Email field in the User (user) table. The field should be non-mandatory and have a new title Work mail in the Employee (employee) table. At the same time, the Email field on the User form must remain mandatory with the same title.

To create the appropriate override, complete the following steps:

  1. Create an override entry via the navigator menu or the Related List of the Email column record.
  2. In the Table field, select the level at which the override will be performed. All tables containing the column are available for the selection.
  3. Select the Mandatory override checkbox and specify a new mandatory value. According to the conditions above, leave the Mandatory checkbox clear.
  4. Select the Title override checkbox and enter a new title value in the Title field.
  5. Save the record.
warning

When doing so, keep in mind that incorrect changes may harm your system, so double-check the changes and verify them on a test instance if possible.