Is it possible to send user responses by email a year from now?
Need to make the answers reach them on a specific date
Best answer by john.desborough
View original
Userlevel 7
+5
Hi
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?
Userlevel 7
+6
- Certified Partner & Champion
- 4784 replies
-
9 January 2023
- 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
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.