How to show only values in reference field which are in the list field?

[SKy Nachiket]

Hi Everyone,

So I have a requirement where I am working on a form and it has two fields : Project Manager(reference field : User) and Additional Project Manager(List field-referenced to User) where additional project manager can be assigned.

So now let's say there are four members added in the Additional Project Manager field and saved it, now when I click on the lookup icon of the Project Manager field, only those users should be visible which are selected in the Additional Project Manager Field.

Please help if anyone has a solution.

[Sai Kumar B · Accepted solution]

@SKy Nachiket 

You can add the below advance reference qualifier to the Project Manager field

javascript:'sys_idIN'+current.<additional project manager field name>

[Pradeep Kumar7]

Hi Sky,

Good day,

I think this can be done by using advance condition in target reference field. By passing the current field information to build query condition on the target field.

Please check the below link which may help you..

javascript needed for reference qualifier for lookup value field dependent on more than one variable...

Regards,

Pradeep Kumar

[Ankur Bawiskar]

Hi,

What ref qualifier have you applied? please share screenshot

You can check comment mentioned by Sai.

Regards
Ankur

[SKy Nachiket]

Hi so for Primary Project Manager(Reference field) : 

and here is for Additional Project Manager(List Field):

My query is that let's say Additional Manager has these four values and I save it, then when I click on the reference icon of Primary Project Manager onlt these four people names should be populated.