How to customise email notification message with conditionals?

[Andressa Pamplona]

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! :) 

[Luciana Munhoz · Accepted solution]

Hi Andressa!

I'm afraid that isn't currently possible with Trello automation. But we do have a couple of features suggestions that you can track here:

• https://jira.atlassian.com/browse/TRELLO-837
• https://jira.atlassian.com/browse/TRELLO-267

I have also added this post as an internal comment to those suggestions, so our engineering team can reference it and use it to help align priorities. I would also recommend visiting them, logging in with your Atlassian account, and clicking Start watching this issue in the right panel. This will help our product and engineering team understand more about which functionalities our users are interested in. Additionally, when our product team updates the ticket, you'll be notified via email.

[Andressa Pamplona]

Hi @Luciana Munhoz 

Thank you for your reply. I’m currently following up on both issues and am hopeful we’ll have some good news soon.

In the meantime, do you happen to know of any workaround I could put in place to achieve a similar result?

[Luciana Munhoz]

Hi @Andressa Pamplona , you're welcome! I'm afraid we don't have a workaround for that one for now, besides creating the report, and then if no cards match the criteria, the report would go empty. If we find a workaround for this, it will be added to the feature request.