Catalog item field should be filter based on another field value

chiranjeevi thi
Tera Contributor

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?

 

3 REPLIES 3

Ankur Bawiskar
Tera Patron
Tera Patron

@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.

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

@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.

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader