Hi all,
Is it possible to trigger an email that is eg: 4 hours after the time that was entered into a form field:- date/time using a sequence flow Condition?
Or is there another way it could be done?
Regards
Shane
The timer event itself doesn't support this. What you can do is, add another datetime(such as datetime2) field on the form, and use it to calculate the exact time the email need to be sent out based on datetime(such as datetime1) user select the and value selected in the dropdown, and use the datetime2 in the timer catch event to wait based on 0 days after datetime2. Following is how to setup these fields and the calculation.
The calculation configured is "=Datetime1+IF(Drop_down_1=1,TIME(1,0,0),IF(Drop_down_1=2,TIME(2,0,0),IF(Drop_down_1=4,TIME(4,0,0),IF(Drop_down_1=8,TIME(8,0,0),IF(Drop_down_1=336,DAY(14),TIME(0,0,0))))))".
You can use field rule to hide datetime2 always if you don't want user to see that field, it will just be used to store the value:
You can add two timers to archive it:
1. Timer catch event 1: wait based on variable 0 days after variable specified
2. Timer catch event 2: wait for 4 hours
Following are the screenshots for the sample:
Great, thank you.
Is it possible to set time that it is overdue from a time set in a form?
Eg:
They want to Choose 1 of these times 1hr / 2hr / 4hr / 8hr or 14days
So in the form they set the time 12:30pm and the drop down a field and choose one of the above such as 2hr then they would be notified at 2:30pm
Regards
Shane
The timer event itself doesn't support this. What you can do is, add another datetime(such as datetime2) field on the form, and use it to calculate the exact time the email need to be sent out based on datetime(such as datetime1) user select the and value selected in the dropdown, and use the datetime2 in the timer catch event to wait based on 0 days after datetime2. Following is how to setup these fields and the calculation.
The calculation configured is "=Datetime1+IF(Drop_down_1=1,TIME(1,0,0),IF(Drop_down_1=2,TIME(2,0,0),IF(Drop_down_1=4,TIME(4,0,0),IF(Drop_down_1=8,TIME(8,0,0),IF(Drop_down_1=336,DAY(14),TIME(0,0,0))))))".
You can use field rule to hide datetime2 always if you don't want user to see that field, it will just be used to store the value:
That's it!!!
Perfect, thank you very much Xiuhong
Regards
Shane