Make Dependent fields on catalog item

[Rocky5]

Hello Experts,

I have the raw data in excel as below (just sample, we have 100s of lines), And I have created two choice fields called 'Title' and 'Title Family' on the catalog item. And I need dependency between those both fields like when user selects 'Title Family' as 'Audit' the 'Title' field should show options below to 'Audit' like 'Audit I', 'Audit II', 'Audit III', Audit IV'.

what is the best way to put this excel data in servicenow and create dependency between those two fields?

I am trying avoid manual work to put this data manually in choice table and write onchange client script to 'removeoption' and 'addoption'.

Thanks,

Rocky.

[Gopi Naik1]

Hi @Rocky5 ,

If you are allowed to create a custom table, Then create a table with below fields.

Name : populate with values of title and title family

Type: give type as title or title family to separate the records

Dependent : For title family record populate this field with appropriate title 

active (optional): to make a record active and inactive.

Now create two variables of type "lookup select box" or reference and put reference qualifier as follows.

For Title : active true and type is title

For Title family : active true and type is title family and dependent is current.title

If you wish to remove any choices in future just make them inactive.