Is it possible to send user responses by email a year from now?
Need to make the answers reach them on a specific date
Answered
How to send form results to the email of the user who filled it out
Best answer by john.desborough
you would need to do a little customization to the fields in your Sheet by adding in a ‘send on’ date column and then having a macro that runs on the ‘send on’ field to push the record to a tab in the spreadsheet (where the Document Studio app is running and monitoring for new records on this tab) or use a variant of the arrayformula() function with logic something like this:
- =arrayformula(if today() dec 31, 2023 AND there is data in column a2 of the source sheet, then pull the record(s) into this tab )
- once the records are there you can have Document Studio either process them using a scheduled job or ‘every hour’ as the records arrive
just a thought..
or generate a pdf of the employees’ inputs and create the draft emails and schedule them to be sent on a specific date from the employer’s email system
des
+5Hi
We don’t offer this feature in our email notifications feature, but you could use an email integration to do this.
So, the intention was to have an employee answer a form of goals for 2023And at the end of the year he will receive what he put in at the beginning of the yearHave no possibility of making this happen?What would be the best integration to use?
+6- Certified Partner & Champion
- 5316 replies
- Answer
you would need to do a little customization to the fields in your Sheet by adding in a ‘send on’ date column and then having a macro that runs on the ‘send on’ field to push the record to a tab in the spreadsheet (where the Document Studio app is running and monitoring for new records on this tab) or use a variant of the arrayformula() function with logic something like this:
- =arrayformula(if today() dec 31, 2023 AND there is data in column a2 of the source sheet, then pull the record(s) into this tab )
- once the records are there you can have Document Studio either process them using a scheduled job or ‘every hour’ as the records arrive
just a thought..
or generate a pdf of the employees’ inputs and create the draft emails and schedule them to be sent on a specific date from the employer’s email system
des
If your third coffee of the day is not helping you with your Typeform, maybe we can help you find your answers...
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.