Send an email exactly 15mins before the due_date of a task

[SandaminiM]

Hi Community 😊

I want to send an email to the Assignee (assigned_to) 15mins prior to the Due Date (due_date) of a task, if the task's state is 'Scheduled'. Can I achieve this using flow designer or else how can I achieve this ?? Please help.

Thanks in advance !!!

[Anwesha3 · Accepted solution]

It will require scripting ,
something like this - 
var gdt = new GlideDateTime(<due date field name>); 
gdt.addSeconds(-900);

gs.eventQueueScheduled("<name of event queue > ", current, "", "",gdt);

Kindly mark the reply as a correct answer / helpful if it helped to solve your question.

Thanks,
Anwesha

[Rohini S Sane · Accepted solution]

@SandaminiM ,

You can write schedule job with below code.

var gr = new GlideRecord('task');
gr.addQuery('state', 'scheduled'); 
gr.query();
while(gr.next()) {
var gdt = new GlideDateTime(gr.due_date); //put actual field name
gdt.addSeconds(-900);
gs.eventQueueScheduled("task.remainder", gr, "", "",gdt);
}

[Voona Rohila · Accepted solution]

Hi @SandaminiM 

There are few ways you can achieve this

1. We can write a flow designer which triggers when state is 'scheduled' and you can use 'Wait for a duration of time' with Duration type as Relative Duration to trigger email 15 min before the due date.

2. We can write a scheduled job which runs every few min and checks if due date is in next 15 min and trigger an event from job using gs.eventQueue

3. We can use gs.eventQueueScheduled method to trigger from your BR when state is 'scheduled'.

Syntax -

eventQueueScheduled(String name, Object glideRecord, String parm1, String parm2, Object expiration)

https://docs.servicenow.com/bundle/xanadu-api-reference/page/app-store/dev_portal/API_reference/Glid...

[Anwesha3 · Accepted solution]

It will require scripting ,
something like this - 
var gdt = new GlideDateTime(<due date field name>); 
gdt.addSeconds(-900);

gs.eventQueueScheduled("<name of event queue > ", current, "", "",gdt);

Kindly mark the reply as a correct answer / helpful if it helped to solve your question.

Thanks,
Anwesha

[Rohini S Sane · Accepted solution]

@SandaminiM ,

You can write schedule job with below code.

var gr = new GlideRecord('task');
gr.addQuery('state', 'scheduled'); 
gr.query();
while(gr.next()) {
var gdt = new GlideDateTime(gr.due_date); //put actual field name
gdt.addSeconds(-900);
gs.eventQueueScheduled("task.remainder", gr, "", "",gdt);
}

[Voona Rohila · Accepted solution]

Hi @SandaminiM 

There are few ways you can achieve this

1. We can write a flow designer which triggers when state is 'scheduled' and you can use 'Wait for a duration of time' with Duration type as Relative Duration to trigger email 15 min before the due date.

2. We can write a scheduled job which runs every few min and checks if due date is in next 15 min and trigger an event from job using gs.eventQueue

3. We can use gs.eventQueueScheduled method to trigger from your BR when state is 'scheduled'.

Syntax -

eventQueueScheduled(String name, Object glideRecord, String parm1, String parm2, Object expiration)

https://docs.servicenow.com/bundle/xanadu-api-reference/page/app-store/dev_portal/API_reference/Glid...

[SandaminiM]

Hi @Voona Rohila ,

I am trying your first method. Is the following configurations are correct?