AnsweredAssumed Answered

Emailing script based on date condition

Question asked by mdc91 on Mar 26, 2017
Latest reply on Mar 27, 2017 by philmodjunk

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!