Skip to main content

I am trying to set up an email automation that sends an email the next day at 9am after a status change. I have created a formula field: IF(
  {Status Changed},
  SET_TIMEZONE(
    DATEADD(
      DATETIME_PARSE(DATETIME_FORMAT({Status Changed}, 'YYYY-MM-DD') & "T09:00:00"),
      1,
      'days'
    ),
    'Europe/London'
  )
)

The automation is triggered using a status condition and when the formula field is ‘today’. and This creates the correct time and date in the formula field, but it is not triggering the automation. 

 

Hmm, what if you used an ‘At scheduled time’ trigger instead? I’ve set it up here for you to check out

The idea would be to create a ‘Last modified time’ field that looked at the ‘Status’ field:

And then we’d have an automation that would trigger at 9am on every weekday, and it would look for all the records where the Status was modified yesterday and carry out the action you wanted:

Thanks. When configuring the email automation how can I ensure it sends to the correct email addresses?

Hey ​@Jwatson1,

I believe  this is what you are looking for:
 



Completely different matter, but would love to have you join our Airtable Hackathon! Make sure to sign up!!

Mike, Consultant @ Automatic Nation 
YouTube Channel

Specifically min 2:00 from the video above probably!

I’m assuming the records have the email addresses needed?  If so, you would use the ‘Email’ field value from ‘Current item’ like so:

 

Terms & ConditionsAccessibility statement