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

Abhishek Kathe
Mega Guru

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.

2 ACCEPTED SOLUTIONS

Anil Lande
Kilo Patron

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.

 

 

Please appreciate the efforts of community contributors by marking appropriate response as correct answer and helpful, this may help other community users to follow correct solution in future.
Thanks
Anil Lande

View solution in original post

SunilKumar_P
Giga Sage

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.

 

 

 

SunilKumar_P_2-1704272846355.png

 

 

 

SunilKumar_P_1-1704272823407.png

 

Regards,

Sunil

 

 

View solution in original post

6 REPLIES 6

Anil Lande
Kilo Patron

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.

 

 

Please appreciate the efforts of community contributors by marking appropriate response as correct answer and helpful, this may help other community users to follow correct solution in future.
Thanks
Anil Lande

Hi,
I want to show the list of attendees in my meeting host reference field(I have to restrict users, only those users who are present in attendees)

 

Did you try the solution proposed by me?

You have to use reference qualifier on Meeting Host field.

https://www.servicenow.com/community/now-platform-articles/how-to-reference-qualifier-on-dictionary-...

 

Please appreciate the efforts of community contributors by marking appropriate response as correct answer and helpful, this may help other community users to follow correct solution in future.
Thanks
Anil Lande

It's not working and my application is global