Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

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}"

Hi

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

Suggest an answer

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

🏊‍♀️ Atlympic Event: Trello

Hello Community!  Quick disclaimer: We are running a contest on Community (The Atlympics!) from July 23rd - August 8th of 2021. If you are interested in participating in this contest (prizes! ...

80 views 0 8
Read article

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