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!