nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to use the variables to create a report?

Rodan Kaka

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.

Accepted answers

milynnus

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

All comments

milynnus

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