Resend approval email if it has not been approved after 24 hours

bradschamerloh
Kilo Expert

I need to re-send an approval email if it has not been approved/rejected after 24 hours.

I have an approval notification that is sent when a record is inserted or updated.   The notification is NOT triggered by an event.   The problem is, I cannot figure out how to re-send the SAME email 24 hours if state=requested on the sysapproval table.  

WORKFLOW:

find_real_file.png

NOTIFICATION:

find_real_file.png

11 REPLIES 11

please see harshinielath's example below.


What that scheduled job does is:


Everyday at 8:00 am,It checks the state of the approvals generated.If the state is 'requested' and is not updated in last 48 hours , it triggers an event which sends the email notification to the approver. So,you need to trigger the event to send an notification.


Santhana Rajhan
Mega Sage

Hello Brad,


Check if this works for you. Note: Connect the "Notification" back to "Timer" and check if the email is triggered again after another 24 hours, when the ticket is not approved.



find_real_file.png


While this will send out the email after the first 24 hours, what if another day passes, this solution won't work.   Also workflows are designed to only execute a certain number of activities before terminating.   This is a setting in the workflow properties, but the best solution is really a scheduled job.


Got you!