Hello Everyone,
I have request to send the Reminder Email for the Survey. The Survey Active period is 5 days( say for ex: if the survey is
generated on 12/08 the due date will be on 12/13)
The Reminder email should trigger on 12/11, which is two days before due date. I have tried the below query
due_dateRELATIVEGT@dayofweek@ahead@3^state=ready in the Assessment Instance table.
But it is pulling all the records which is relative after 3 days. I just need the exact record count not all the records which is after 3 days? Say if 10 record has the due date on 12/13, i just need only the 10 records.
Can anyone help me out of this?
Regards,
Prem
@Ankur Bawiskar - we are doing something similar with our surveys - When our surveys are triggered, they have a due date of 5 days. However we have written a business rule to ensure the due date actually follows business days, excluding weekends, and this is working great!
We are currently in the process of setting up a scheduled script to ensure reminder notifications are sent out 2 days before the due date of the surveys, however we have an issue as we also want the reminder notification to follow business days excluding weekends - please see our script below.
Our below script works as expected whenever the Due date of a survey is on a Wednesday, Thursday or a Friday, because 2 days before would never be a weekend. However! if the due date of the survey is on a Monday or Tuesday, 2 days before will either be Saturday and Sunday! and we dont want the reminder notifications to be sent out on a Saturday or Sunday.
Can you please provide your support here - is there a wa we can also ensure the reminder notification is triggered on the correct business days. So for e.g. if the due date of a survey is on a Monday the reminder notification still follows the 2 days before but on business days, so the reminder is in fact sent on the Thursday, and if the due date is on a Tuesday, the Reminder is sent on the Friday.
