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. |