Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,298,772
Community Members
 
Community Events
165
Community Groups

Pattern for creating a scheduled report using Butler in Trello

I am a total novice at this Trello lingo.... and beginning to think I am in over my head. 

My end goal is to be able to receive an automatic report in my email inbox of all cards from a list (Meeting To-Do Items). 

What am I doing wrong? 

every monday at 9:00 am, create a report in variable "Doing" with all cards in list "Meeting To-Do Items" using pattern "- [{cardname}]({cardlink}) ({cardmemberusernames}) {{%Priority}} => DUE on {cardduedate}", create a report in variable "Done" with all cards in list "Done!" using pattern "- [{cardname}]({cardlink}) ({cardmemberusernames}) {{%Priority}} => DONE on {{%Completion Date}}", and send an email notification to "(my email)" with subject "Progress Report for Week #{weeknumber}" and message "Doing:\n\n{$Doing}\n\nDone:\n\n{$Done}"

 

Currently, it looks like this when I receive it: 

 

Trello.JPG

2 answers

Hi

You should try by adding "space" before and after \n sequence.

0 votes
Iain Dooley Community Leader Mar 18, 2020

@Kristina B The command looks correct, if you're certain you haven't got any typos in the list names, what I would recommend is testing each part manually. So create a board button that creates a report for just one list with a simpler card pattern and instead of emailing it, create a new card with the report variable in the description.

If that works, try making the pattern more complicated, adding 2 variables, and so on, adding things one by one until you find what breaks.

Here's a silly question -- does the variable have to match anything on the list? Currently, the two list names I'm trying to get a report on are 'Meeting To-Do Items' and 'Done!'.

I put 'Doing' and 'Done' as variables in the command so they show up in a easy to read format through email. Could that possibly be throwing it off? 

Thank you so much for your time! 

Update: 

I was able to get the report to come through but the priority levels are not showing up in the emailed report. It's not pressing so I am going to just roll with it. 

Thanks again for your feedback! 

Hi Kristina! I'm having a similar issue, but my report does not line break my tasks, did you find a way around this? Here's my automation: 

every 2 weeks on monday, create a report with all cards with custom field "Area of site" set to "Front-End" using pattern "- [{cardname}]({cardlink})" group by list, and send an email notification to "myemailaddress@test.com" with subject "Front-End Application Support Ticket Status" and message "{$report}"

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Trello

Taco Tuesday: New years' resolutions with Trello

Congratulations to @Laura Holton , our latest winner of Taco Tuesday! And thanks to @Kristján Geir Mathiesen for sharing the picture of Taco having fun with his new friend  B...

2,384 views 28 41
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you