There is a table called 'my meeting' and a field called 'Attendees' having field type 'list' and ano

[Abhishek Kathe]

There is a table called 'my meeting' and a field called 'Attendees' having field type 'list' and another field called 'meeting host' having field type 'reference' . Both refers to the user table so I want to show in the 'Meeting Host' reference field only those users who are present in 'attendees' list field.

[Anil Lande · Accepted solution]

Hi,

On Meeting host field dictionary use the advanced reference qualifier like below:

javascript: "sys_idIN"+current.attendees.toString()

Use correct backend name of your field "Attendees" in above reference qualifier.

[Anil Lande]

Can you please share what you have done?

A screenshot would be helpful.

[SunilKumar_P · Accepted solution]

Hi @Abhishek Kathe, the solution proposed by @Anil Lande should work. I have tested it by limiting the users based on Watchlist.

javascript:'sys_idIN'+current.watch_list.toString(); //Replace watch_list with your field name.

Regards,

Sunil