Evaluate multiple dates in a recurring workflow

[easternpointmedia]

I’m trying to create a notification system for my users that will alert them when their inputted contract is X days away from expiration.

I have set up a “set recurring event” when the contract is created to run daily.

c

That starts the backend recurring workflow that actually checks the expiration date against today’s date. This only evaluates for days = 60, but I’d also like it to check for 30, 15 and 5 without having a ton of different workflows. I also have 2 other date types to evaluate (opt out date, auto-renewal date), so I’m not sure how I’ll be able to evaluate these with Bubbles “1 events per thing” constraint. Even on Growth 5 events wouldn’t be enough to cover this. Am I missing something?

[mitchbaylis]

You could do this 3 ways:

1. set a daily recurring event like you’ve done
2. schedule an api to run on the expiry date when that field is changed (much more efficient as it only checks 1 time)
3. create a daily checker that does a search for all expired/expiring and then iterates/changes the results to process them.

For #2 you can store the workflow id and then cancel it and reschedule it when the date changes

I prefer #3 as it’s the simplest and most reliable. #2 is likely the cheapest in WU for a small app, but #3 could be cheaper depending on what you need to do.