Help with catalog item form

[cicgordy]

Hi all,

I have created a catalog item and I have two reference fields on the form: "office_location" which references the "cmn_location" table and "choose_the_software" which references the "u_software" table.

If I select "New York" as office location, I want to then be able to hide the software "Cube3D" optionfrom the choose_the_software reference field.

Can anyone help with catalog client script please?

Thanks

[Dr Atul G- LNG]

This is called experience thanks @Sandeep Rajput  sir.

[Sandeep Rajput]

Thanks for the kind words Atul, but I was also thinking in the direction of client script but discovered that both the fields are reference fields hence the client script won't work.

[Dr Atul G- LNG]

I am week in code but try to get some helpful link. 

[cicgordy]

Hi @Sandeep Rajput ,

no, the choose_the_software variable just shows a list of all the software names from the software table, but no conditions are specified

[Sandeep Rajput]

As suggested earlier, you need to create an advanced reference qualifier in this case, please refer to https://www.servicenow.com/community/developer-forum/how-to-write-advanced-reference-qualifier-scrip... to know how advanced qualifier can be written.