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:

 

Thanks. I only want the email to send once, but surely using this method each record will receive the email everyday if there status is still the same. Is there a way I can only send the email once?

 

Hmm, I’m not following.  It looks for records where the Status was updated yesterday, so tomorrow that record won’t come up since its Status wasn’t updated?

Of course, sorry my mistake. Thanks

Terms & ConditionsAccessibility statement