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,299,390
Community Members
 
Community Events
165
Community Groups

How to use the variables to create a report?

Hi

 

I'm trying to create a report that contains all the cards in 3 different list and show them according to my selection of the lists (To do then In Progress then Done) then send this report in an email.

I don't think the variable I'm creating is capturing any info because when I test the email is blank?

 

Please let me know if you can help with creating such reports.

1 answer

1 accepted

3 votes
Answer accepted

@Rodan Kaka 

The way it works is that you construct the report line in the pattern and then select by List and Trello will do the grouping for you.

It will be for all list based on the cards selected using the criteria you set for card selection.

thanks!

can you give an example how to construct a report line in the pattern?

@Rodan Kaka 

here’s a simple example

-{cardname} due on {card due date}

Great thanks!

 

Now I get some results however, its not in a list all the card names are in a paragraph which is not ideal, I tried the group by list and without it but I get the same paragraph style result.

any ideas how to fix this?

 

this is what I have now:

every thursday at 3:00 pm, create a report in variable "done_report" with all cards in list "Done" using pattern "[{cardname}]({cardlink})" group by list, and send an email notification to "xxx" with subject "Admin Snapshot" and message "This week in Admin\n\nDone:\n\n{$done_report}"

@Rodan Kaka 

Your select criteria is looking at "Done" list and you have a group by list option. So unless you have criteria that selects across list the group by list has no effect. The output, however, will be :

List A

- report lines

List B

- report lines

If you want more than this, you have to look at a PowerUp or sending the report variable to endpoint using http request.

Like Rodan Kaka likes this

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,392 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