Sending regular reminders as long as you haven't filled in a form

14 views
Skip to first unread message

ITa

unread,
Jan 30, 2015, 11:45:53 AM1/30/15
to forme...@googlegroups.com
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

 

Henrique Abreu

unread,
Jan 30, 2015, 12:22:48 PM1/30/15
to FormEmailer on behalf of ITa
FormEmailer does not provide these features. It simply acts once for each form submitted / row-entry on a sheet.
To achieve this you'll probably have to write your own code. I don't know any tool that does this right out of the box.

Regards,

Henrique Abreu

--
You received this message because you are subscribed to the Google Groups "FormEmailer" group.
To unsubscribe from this group and stop receiving emails from it, send an email to formemailer...@googlegroups.com.
To post to this group, send email to forme...@googlegroups.com.
Visit this group at http://groups.google.com/group/formemailer.
For more options, visit https://groups.google.com/d/optout.

Reply all
Reply to author
Forward
0 new messages