New to automations - I would like send a reminder email to trigger when date is TODAY. The field in the record is Target Date. The automation states "when Target Date is TODAY". This works, but the trigger continues to send a reminder email beyond the date in the record. For example, the date is 3/1/24. The reminder email was sent on 3/1/24. However, I notice over the weekend that the reminder email was sent on Saturday 3/2 and Sunday 3/3.
Trigger for TODAY - keeps sending email past the due date
+2
+16Hi, you could use a different method. Create a calculated field where you see how many days there are between the due date and the "Today" date and you can set up the automation on when the new column is equal to 0.
So the automation will send a reminder every time is equal to 0. I prefer to setup also a clock column, so I can manage better the time when I want to send the reminder.
For example, airtable will send a reminder every time the due date is equal to 0 and the clock is 9 (note: that the reminder could arrive from 9:00 to 9:45, there is some delay in the formula).
I use the same for my job.
Let me know if you have any Question 🙂
+31Hm, that's odd. And it happens consistently? I'd love to take a look at this if you could DM me a link to your base so I could look at the automation and record revision history
+2Hi, you could use a different method. Create a calculated field where you see how many days there are between the due date and the "Today" date and you can set up the automation on when the new column is equal to 0.
So the automation will send a reminder every time is equal to 0. I prefer to setup also a clock column, so I can manage better the time when I want to send the reminder.
For example, airtable will send a reminder every time the due date is equal to 0 and the clock is 9 (note: that the reminder could arrive from 9:00 to 9:45, there is some delay in the formula).
I use the same for my job.
Let me know if you have any Question 🙂
Thank you for responding. Unfortunately when I add Conditions in my Automation, I do not see "=" as an Operator (I do see IS) and I do not see "CLOCK" as an option
+16Thank you for responding. Unfortunately when I add Conditions in my Automation, I do not see "=" as an Operator (I do see IS) and I do not see "CLOCK" as an option
Hi, Have you created the column Clock in the table?
Have you selected "When record matches conditions?
Have you clicked on "Add condition"?
and changed the "variable" clicking here?
and last Have you clicked on "Contains"?
Have you selected the "Due date" that is the function, not the date?
you should select the variable with the letter f, and = will appear
I'm sorry if I'm asking so many questions, but I don't know what is your level
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.