Discussions

Expand all | Collapse all

How to automate emails based on [Date Received] and at different intervals thereafter?

  • 1.  How to automate emails based on [Date Received] and at different intervals thereafter?

    Posted 09-06-2018 17:54
    For example, I have an order come in for a customer, how can I automate an email to that specific customer based on [Date Received], then another 15days after [Date Received], then finally a third at 30 days? 


  • 2.  RE: How to automate emails based on [Date Received] and at different intervals thereafter?

    Posted 09-06-2018 21:08
    An email only triggers when a single or multi record operation has occurred. there is no trigger for something becoming true via formula.  

    Solutions I have seen in the past used a server side cron script to query the records that would need the next email sent out, and edit those records using the api individually in a loop to send single record notifications, or in mass for multi record operations. 

    Now... automations based on a daily schedule, running a Table to Table import if date X = today, to set a checkbox to true for triggering the next email event should work. This will trigger a Multi record email notification however. 

    For sending a single record notification out one at a time to each customer, you may need a server side script to run on a schedule. 


  • 3.  RE: How to automate emails based on [Date Received] and at different intervals thereafter?

    Posted 09-10-2018 05:27
    I have solved this requirement using a Table to Table import and 2 Automations using a formulaic relationship to a parameter table. I am now able to send single record notifications for many records on a daily basis by triggering a looping automation. If you are interested, I can see if I can document this for you.