Column override functionality allows a field in a child table to have a different value than the same field in a parent 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.
How to define a column override
- Navigate to {your_instance_url}/record/sys_db_column_override;
- Click New, fill in the fields, and click Save.
Column Override form fields
| Field | Description |
|---|---|
| Base Table | The table containing the field to override. |
| Table | Select the table to which the override applies. |
| Column | Select a column to be overridden. |
| Display by ref override | Select this checkbox if you need to override the Display by ref setting which is responsible for column displaying on lists. |
Default value override | Select this checkbox to display the Default Value field, which overrides the default value for the field on the extended table. |
| Default value | Enter the default value that will override the original one. This field appears if the Default value override checkbox was selected. |
| Reference qualifier override | Select the checkbox to display the Reference qualifier fieldset, which overrides the reference qualifier for the field on the extended table.
|
| Mandatory override | Select the checkbox to display the Mandatory field, which overrides whether the field on the extended table must contain a value to save a record. |
| Read-only override | Select this checkbox to display the Read-only field, which overrides whether a user can change the field value on the extended table. |
| Dependent on column ID override | Select this checkbox to display the Dependent on column field, which overrides the field on which the current field depends. |
