Help

Re: Automation for an email to send 2 days after record updated

553 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Jwatson1
4 - Data Explorer
4 - Data Explorer

Is it possible to create an Automation so an email send 2 days after record updated?

1 Reply 1
Josh_Colina
6 - Interface Innovator
6 - Interface Innovator

There's a couple of ways I can think of to accomplish this! First you'll need to have a Last Modified Time field inspecting either the record or a specific field, depending on your needs. Then, you could:

  • Create a view with the filter "Where Last Modified Time is number of days ago 2." Create an automation with the trigger "When a record enters a view" and the action "Send email,"
  • You could also create a formula field that reads, for example:
IF(
  DATETIME_DIFF(
    TODAY(),
    {Last Modified},
    'd'
  ) >= 2,
  "Send Email"
)

This will return "Send Email" if the difference in days between when the record or field was last modified was and today  is greater than or equal to 2 days. From there, create an automation with the trigger "When a record matches the conditions" and set the conditions to this field returning "Send Email", with the action of "Send email."

For some reason, I've occasionally noticed that DATETIME_DIFF requires a modifier or + or - 1 when formatted to days, so just something to be mindful of if you want to go that route. Hope this helps!