Mar 04, 2024 08:39 AM
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.
Mar 04, 2024 09:26 AM
Hi, 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 🙂
Mar 04, 2024 07:05 PM
Hm, 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
Mar 06, 2024 09:37 AM
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
Mar 06, 2024 09:46 AM
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