I’m building the process using a tally form and airtable.
1. User fills in a form that includes a question as follows - when do you want to start the challenge?
2. The answer which is a date is feed into airtable (formatted as friendly date, time and time zone)
3. Then, I want to sent an email reminder on this date (from point 2) at 11 a.m. How can I do this in airtable? i tried using a formula but couldn’t find one that gives me the same time output - at 11 a.m.
If I were you, I would try the following: 1. Create an automation that triggers every day at 11am 2. "Find Records" action that looks for all records where the date is today 3. Repeating group with a "Send email" action
This would thus send an email to each person whose start date is set to today