6 Replies Latest reply on Mar 27, 2017 8:13 AM by philmodjunk

    Emailing script based on date condition

    mdc91

      Hi Guys,

      I wonder if anyone can help me.

      The solution in question here is a booking platform/CRM platform for an events company:

       

       

      I’d like to create a script that runs on startup (or eventually use it with a scheduling plugin) that:

       

      searches the database for Bookings that are 30 days away

       

      Find all records (if any) that match the above criteria and then send an email out to each of them with a copy of the event’s invoice (on a layout) to remind them the balance is due and to pay.

       

      I hope that makes sense as I see it in my head!

       

      Thanks in advance!

      Michael