Send Notifications to users in a list collector field

pramodkumar
Tera Expert

Hi All,

I want to send notification to users in list collector field. I have a custom table with one list collector field reference to user table. I want to send notification to all users in this field, but the notification is on different table so I cannot directly access the list collector field in notification users or groups field.

How can I send notification to all users in list collector field with business rule or email script?

 

Thanks!

10 REPLIES 10

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

you can use gs.eventQueue() and include the recipients from the business rule

Ensure you create event and link that event with the email you want to trigger.

What script did you start with? what's the link between those 2 tables?

regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

Hi @Ankur Bawiskar I've started with email script.  I used glide record for querying the table on which list collector field exists. I got all user sysid's with comma separated in a variable.

How can I now send notification to all users in the above variable.

Hi,

why to use email script to send email notification?

email script is used to show data in email

Did you check my above comment to use gs.eventQueue()

regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

@pramodkumar 

Thank you for marking my response as helpful.

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

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader