Help

Trigger for TODAY - keeps sending email past the due date

Topic Labels: Automations
333 4
cancel
Showing results for 
Search instead for 
Did you mean: 
serteksales
4 - Data Explorer
4 - Data Explorer

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.   

4 Replies 4
Sara
8 - Airtable Astronomer
8 - Airtable Astronomer

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.

 

 

Sara_0-1709572772511.png

Sara_1-1709572785439.png

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. 

 

Sara_2-1709572982714.png

Sara_3-1709573044252.png

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 🙂

 

 

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

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

Hi, Have you created the column Clock in the table?

 

Have you selected "When record matches conditions?

Sara_0-1709746913854.png

Have you clicked on "Add condition"? 

Sara_1-1709746943762.png

and changed the "variable" clicking here? 

Sara_2-1709746985763.png

Sara_3-1709747009151.png

and last Have you clicked on "Contains"? 

Sara_4-1709747055127.png

 

Have you selected the "Due date" that is the function, not the date? 

Sara_5-1709747160476.png 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