I’ve set up a scheduled automation to send me an email reminder everyday for open tickets that I need to resolve. The thing is that I’d like to configure this automation to only be triggered if there are open tickets in the first place, i.e. if the count of open tickets > 0 or if one of the views in my table “Open tickets” has any records in it. I don’t want to keep receiving an email daily that says “You have 0 open tickets”.
How can I set the Scheduled automation to only run based on a condition? Is this even possible?
Any help would be much appreciated.