How to send an email notification when a group manager changes for multiple records

[matthew_hughes]

I'm working on a situation where the 'Group Manager' within a table of records will change. In the below screenshot, the same group can be assigned to multiple records and sometimes, the Group Manager will change 

I've created a notification with the below conditions:

However what I'm finding is that when I change the Group Manager in a group, it will generate the same email multiple times to the new manager:

So I was just wondering if there was a way of sending the email only once rather than multiple times when the Group Manager changes.

[Ankur Bawiskar]

@matthew_hughes 

since you are updating those many records and manager is changing for each of those, it's sending those many emails

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

[shantanu_patel8]

Hi @matthew_hughes ,

If you want to restrict the number of notifications being triggered from the change in group manager then you can follow these steps:

1. Create a new event "manager_change_notify".

2. Change the trigger condition of the notification to "Send when = event is fired".

3. Create a scheduled job which will be triggered at the end of each day to identify the change is group manager in the given table.

4. Use metric instance table to get the records where the group managers are changing.

Mark the answer as correct and helpful if it resolves your issue. Happy Scripting 🙂

-Shantanu