Hi,
I would like to be able to send weekly reminders to a list of recipients, which have to fill in or complete a form for them to stop.
The algorithm I'm looking at would be:
Input: Multiple email adresses (either in form or in sheet)
1. Generate unique link to a form for each email adress.
2. Send email notifying the recipient of the form, containing the link, so the recipient can finish filling it in.
3.While form isn't submitted [this might cause a problem if I have previously submitted the form containing the email adress, but maybe make it so that "While form isn't submitted for the second time" would work]
a. If recipient does not fill in the report in 1 week since last email
i. Send an email reminding the recipient to fill in the form.
5. Send email to the author of the form to notify of its completion
I hope I'm clear enough. I'm also thinking I'm not the first to want a feature like this, cause it's just regular reminders. But I can't seem to find anything else on the subject, and I've been googling for a couple of hours.
All the best,
Richard