I want to send notification when n number of users added in a group

[Amol Pawar]

Hi All,

I have a requirement where I need to send two notifications. The first notification I want to send is when 45 members are added to a group and the second notification I want to send is when the 50th member is added to that group.

Adding group members is happening by workflow since it requires approval from admins.

Seeking the best and easy approach for this.

Thanks in advance,

Amol

[piyushsain]

Create a after insert BR calling a Script include in condition on table Group member (See screenshot)

if condition is satisfied (count>45 or count >50) trigger an event sending notification

Please let me know if any issues. If you want only one notification you can add the check by GlideRecord the sys_email table.

[piyushsain]

@Amol Pawar please let me know if this solves your issue

[Harshal Aditya]

Hi @Amol Pawar ,

Hope you are doing well.

You can follow below steps -

1. Create two events in event registry.

2. Create a after insert business rule on sys_user_grmember table and count the members added using glideAggregate

3. Trigger the event when count is = 45 and count =50

4 Configure email notifications to trigger

If the email body is same then you can use only one event as well

Please mark this response as correct or helpful if it assisted you with your question.

Regards,
Harshal

[Amol Pawar]

Hi @Harshal Aditya ,

Thank you for your reply, could you please provide a demo script so that I can refer?

Thanks,

Amol