We've updated the ServiceNow Community Code of Conduct, adding guidelines around AI usage, professionalism, and content violations. Read more

How to change referenced tables on one reference field based on other dropdown values.

aastha3
Giga Contributor

I have a requirement where I have three variables   in service catalog

1. CI Type(select box) -> VM , Linux , ESX, JBOSS

2. CI Name (reference field)

3. Sys ID (single line text)

Now I want that whenever the CI type is changing the referenced table in CI Name   should change accordingly with their respective tables.

like for vm ->cmdb_ci_vm similarly for others as well.

My end result is to fetch selected ci name's sys id .

For changing reference field script include and onchange client script will be required .

for sysid fetch also onchange or onsubmit script will be required   . Not sure about this

Please help me with the correct code for my requirement .

Let me know if you need any further information.

1 ACCEPTED SOLUTION

Please replace-


var type=current.u_type;



with


var type=current.variables.u_type;



It should work now. Best of luck.


View solution in original post

26 REPLIES 26

Thats great worked I will include other also in if else code .


Please last favour provide the code to fetch sys id of the CI .



I will be really grateful to you.


Manoj Kumar16
Giga Guru

To provide the sys_id ?   where do you want to fetch the sys_id ? in script include ? or any client script ? what is the requirement ?


See like this in the screenshot



find_real_file.png



Once the ci name is selected by the user its sys id should come in the sys id variable present below .


Any thing would do be it client script or script include . They just want to have the end result the sys id population.



Please help me with the code.



find_real_file.png


Ok no problem I will help you with the code only if you mark one of my answers correct and the rest of them helpful.... is that fair ?


Anyways I would have done that. No need to mention You are really helpful