Add linked fields

In cases where user interaction with a pair of fields, which are related and requires a selection of one field before presenting the values that are valid for another, you can include a linked pair of drop-down lists in your topic workflow configuration.

In the following example, the user interface presents linked fields for selecting a MedDRA SOC and MedDRA HLGT:

Linked fields for selecting a MedDRA SOC and MedDRA HLGT

Users must select a value for the parent field, MedDRA SOC, first. The list of values for the subsidiary field, MedDRA HLGT, is then populated with values that are valid given that initial selection.

The list of values for the subsidiary field, MedDRA HLGT

  • You must define valid values for both of the fields in a linked pair. Both fields appear as drop-down lists in the user interface.
  • Both of the fields in a linked pair must be custom fields that you add to the topic workflow configuration.
  • You must define two different fields as the linked pair. A field cannot be selected as its own Link to parent field.
Add the parent field

The first field you add is the parent field.

  1. In the left navigation pane, click the Settings icon (Settings icon).
  2. In the Configure System section, click Manage Topic Workflow Configurations.
  3. Click the Row Action menu (Row action menu icon) for a configuration, and then click Manage Fields.
  4. Click Add Field.
  5. In the Column Name field, enter a column name.
  6. In the Display name field, type a name to display in the user interface.
  7. From the Format drop-down list, select either string or integer as the format.
  8. For a string field, in the Length field, specify a maximum field length.
  9. In the Type section, do not check any options.
  10. In the Context section, select the field context. The field can be used to collect information for a topic, action, attachment, or work team.
  11. To use the field as a filter, check Display as filter field. See Identify a field as a filter field.
  12. Click Save, and then click Back.
  13. On the Manage Fields page, click the Row Action menu (Row menu) for the parent field, and then click Define Values.
  14. Click Add Value.
  15. In the Value field, enter a value for users to select, and then click Save.
  16. Repeat steps 14 - 15 to add all possible values for the field. Alternatively, you can store all field values in a .csv (comma-separated value) file, and then upload it. See Upload a table of valid values.
  17. Modify the display order of the valid values as needed. For more information, see Modify the display order for the values.
Add the subsidiary field

On the Add field page, enter a second, subsidiary, field.

  1. In the Column Name field, enter a column name.
  2. In the Display name field, type a name to display in the user interface.
  3. From the Format drop-down list, select either string or integer as the format.
  4. For a string field, in the Length field, specify a maximum field length.
  5. In the Type section, check Linked and, from the Link to parent field drop-down list, select the field you added as the parent field.
  6. In the Context section, select the same field context(s) as for the parent field.
  7. Optionally, specify the field to be used for filtering by checking Display as filter field. See Identify a field as a filter field.
  8. Click Save.
Define the parent-child values
  1. On the Manage Fields page, click the Row Action menu (Row menu) for the subsidiary field, and then click Define Values.
  2. Click Add Value.
  3. On the Add Value page, supply the values for users to select. For each value that you add, from the Link to parent value drop-down list, identify the value for the parent field that must be selected for this value to be available.
  4. Click Save.
  5. Repeat step 4 to add all possible values for the field. Alternatively, you can store all field values in a .csv (comma-separated value) file, and then upload it. See Upload a table of valid values.
  6. Modify the display order of the valid values, as needed. For more information, see Modify the display order for the values.

    By default, both new fields will be editable for a topic or action in any workflow state, or for any type of document-style attachment. Users can select a value or select " " (blank).

  7. Alternatively, you can make one or both of these fields required (the blank value is not offered, and users must select one of the defined values before saving). Generally, you should apply the same access level to both of the fields in the linked pair. See Manage topic field accessibility by state, Manage action field accessibility by state, or Manage attachment field accessibility by type.