- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 23, 2024 11:18 PM
Hello,
I have a column in one of my Airtables that contains the date of when a piece of information was published on my site.
I am trying to set an automation that looks at each row of my table every day and sends an email if any record i have becomes 60 days after the date I enter in the "Date" column.
To test out the automation:
- I set the date for one of my rows of when it was published to 3/20/2024 (this is now 3 days since that date)
- i am setting the trigger to just be 1 day after the date. The condition is "When ["date"] [is after] [number of days ago] [1], send me an email
For some reason, when i set this all up, it tells me that the table does not contain any records that match the provided filters.
I don't quite understand this because in my test above, it is now 3 days after 3/20/24 so based on the conditions i set up, it is at least 1 day after 3/20/24, so shouldn't it return my test record and then be able to send me out a test email?
Appreciate any clarifications about what I'm not doing or understanding correctly.
thanks so much,
Matt
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 23, 2024 11:41 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 24, 2024 01:20 PM
That worked. Thanks for the suggestion.
