I am setting up a Scheduled Rule so that every Monday at 8:00am the team receives an email notification with all the card names on a specific list that starts on the current week.
However, I want to be able to print 'No campaigns scheduled for this week' when there are no cards that meet the criteria.
Currently, the rule is set as:
every monday at 8:00am
create a report in variable "ComingSoon" with all cards in list "Coming Soon" starting this week using pattern "[{cardname}]({cardlink}): \n\n{carddescription}\n\n ------------- \n\n\n",
and send an email notification to "example@example.com" with subject "Campaings for week #{weeknumber}" and message "Hi team, \nHere’s a quick overview of the campaigns scheduled for this week:\n\n{$ComingSoon}\n\nPlease take a moment to review the campaigns so we’re all across them and ready to go. 🚀\n\n"
Is there a way to achieve this? Thank you! :)