Catalog item field should be filter based on another field value

[chiranjeevi thi]

Hi,

I'm new to the servicenow. I have a requirement in service catalog items that is there is two fields one is "location" field another one is "employee" field both are reference fields u_location and u_employee table respectively. if I select a location then in employee reference field should display only that location related employees in reference field.

can you please provide solution for this?

[Ankur Bawiskar]

@chiranjeevi thi 

should be simple enough.

Do you have any field on u_employee table which refers to u_location? If yes then do this on Employee variable

1) Use correct location field name and correct location variable name and it will work fine.

javascript:'locationField=' + current.variables.locationVariableName;

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@chiranjeevi thi 

Thank you for marking my response as helpful.

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Community Alums]

Hi @chiranjeevi thi ,

Use this logic :

https://www.servicenow.com/community/csm-forum/filter-reference-field-based-on-another-reference-fie...