How to use the variables to create a report?

[Rodan Kaka]

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.

[milynnus · Accepted solution]

@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.

[Rodan Kaka]

thanks!

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

[milynnus]

@Rodan Kaka 

here’s a simple example

-{cardname} due on {card due date}

[Rodan Kaka]

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

[milynnus]

@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.