Populate users based on other field value

[may13]

Hello team I need help with the requirements below

In a record producer, I have created two variables:

Requested By (which refers to the User table) and

Employee ID (which also refers to the User table).

In the Employee ID field, I want to display only those employees whose company matches the company of the Requested By user.

For example, if I select user ABC in the Requested By field, and that user’s company is "Samsung", then in the Employee ID field should only display users whose company is "Samsung".

[Bhuvan]

@may13 

Create a reference qualifier on Employee ID field. Refer below for sample,

https://www.servicenow.com/community/developer-forum/how-to-add-reference-qualifier-to-record-produc...

https://www.servicenow.com/community/developer-forum/help-with-record-producer-advanced-reference-qu...

https://www.servicenow.com/community/itsm-forum/how-to-create-an-advanced-reference-qualifier-for-a-...

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0966617

If this helped to answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan

[Bhuvan]

@may13 

Did you get a chance to review this ?

You would be able to filter the reference field based on the information I provided. If my response helped to answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan

[Sandeep Rajput]

@may13 You need to use a reference qualifier on the the Employee ID variable as follows.

[Sandeep Rajput]

@may13 Thanks for marking the response helpful. Please mark the response accepted solution if it addressed your question.