How to trigger scripts when you're not around?
Here is my problem. I have a membership database. And I have members who get subscribed to certain contact lists when their membership is active. When the membership lapses they have to be unsubscribed from the list.
So I have a script that says if their subscription status says "Lapsed" to go and find them in the list and delete them.
This works great. When I'm testing it manually. But now I realise, it doesn't trigger when the membership lapses when it reaches the expiry date.
Does anyone have a suggestion for how I can get this to trigger without having to manually do it?