question Populate users based on other field value in Community Central forum

Populate users based on other field value

may13 — Sun, 31 Aug 2025 13:39:02 GMT

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

Re: Populate users based on other field value

Bhuvan — Sun, 31 Aug 2025 14:09:52 GMT

@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-producer-variable/m-p/1829285

https://www.servicenow.com/community/developer-forum/help-with-record-producer-advanced-reference-qualifier/m-p/1827003

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

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

Re: Populate users based on other field value

Sandeep Rajput — Sun, 31 Aug 2025 14:11:44 GMT

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

Re: Populate users based on other field value

Shashank_Jain — Sun, 31 Aug 2025 14:29:59 GMT

@may13 ,

To achieve this functionality, you can use advanced reference qualifier on employee id variable -

Refer the below screenshot :

Hope it helps!

Re: Populate users based on other field value

Ankur Bawiskar — Sun, 31 Aug 2025 14:28:53 GMT

@may13

Solution is already shared by @Sandeep Rajput .

Please check that and share the feedback.

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

Re: Populate users based on other field value

Bhuvan — Sun, 31 Aug 2025 15:10:04 GMT

@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

Re: Populate users based on other field value

Sandeep Rajput — Sun, 31 Aug 2025 16:07:17 GMT

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