If you have activated another script / add-on triggered upon a form submission, you might want this script to finish its work before beginning the mail merge.
Some general use cases
For example, you can use this delay mail merge option to:
- Wait until a specific calculation is made in one column based on the data entered by the user + some other variables
- Wait until a file has been created so it can be attached to the email sent
How to activate this delay option?
In the configuration panel for notification rules, you can see a checkbox 'Wait until a specific column is filled before sending the email'. Check this box, select the appropriate column to control and save.
When the mail merge begins, if the value is missing in the column that you have selected, it will wait for 60s to let another process complete its task and then start the merge.
If for some reason the other process can't finish during those 60s, an error will be displayed but no mail will be send. Next time someone submit a form, it will try again on all rows tagged with an error.
Comments
2 comments
I was able to get it to send emails to the person I want them to go to, but I still get a "Failed to send email: no recipient - error code:157" error every time, which means on next form submission it sends the notification email again.
Help?
This function is great by the way, but would love to see it use this method to "filter" if a message needs to be sent or not, rather than just waiting for another script to run.
I have a form submission that may or may not have a certain field filled in depending on the submission. If it is I'd like to send the email, if not, then it doesn't need to be sent. The "wait until" works in this situation, but takes about 2-3 minutes to move on from a blank field, and can get a bit "stuck" every now and again.
As the forms can be filled out at any time, this can cause a few issues with times of email delivery
Please sign in to leave a comment.