The CreatorCon Call for Content is officially open! Get started here.

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