We have a requirement to send email notification 5 business days before the selected date in catalog variable and it should not be sent on weekends

krishna191 · ‎10-14-2020

We need to trigger notification 5 business days before the date selected in the date catalog variable (new hire date) and it should not trigger on weekends

asifnoor · ‎10-15-2020

Hi Krishna

1. create an event on RITM table

notify.user

2. Create a notificaton and listen to your event under whne to send

3. Then write a after insert/update Br on RITM table with

Fitler conditions:

selected date changes AND

selected date is NOT empty

script

var gdt = new GlideDateTime();
gdt.setDisplayValue(current.selected_date);//put right field name
gdt.addDays(-5); //deduct 5 days form the selected date
//put yoru scheduled sys_id here
var schedule = new GlideSchedule('08fcd0830a0a0b2600079f56b1adb9ae'); 
while(true) {
   if(schedule.isInSchedule(gdt)) {
     break;
   } else {
     gdt.addDays(-1);
   }
}
gs.eventQueueScheduled('notify.user',current,'','',gdt);

Mark the comment as a correct answer and also helpful if it helps to solve the problem.

View solution in original post

Swapnil Pujari · ‎01-17-2022

Hello,

Please check this link:

https://community.servicenow.com/community?id=view_idea&sysparm_idea_id=c346306e1b01451038739979b04b...

Please mark correct if it is helpful.

Thanks,

Swapnil Pujari

Vaishnavi Bhagw · ‎03-22-2022

we have to send email notificatio to the software manager when the assignment group is set to software what we can do?