Creating a weekly report for the newly added cards?

[Célia Robillard]

Hi,

I'm wondering if it's possible to create a report via email that would extract the cards created within the last 7 days ?

I don't use due date for this kind on board and what I found was mostly based on that.

Thanks for your help.

[milynnus]

@Célia Robillard if you a * label with no colour each time a card is created you can use collect all cards into a checklist with a formatted link with {cardname} and {cardcreationdate}. Use can use {cardagedays} if you just want to know the days. In the example below I used a card movement as a trigger but you can attach the same to another trigger mechanism. The * label is removed after each run.

when a card in list "Control" is moved into list "Completed", collect all cards with the "*" label into links in checklist "temp" using pattern "[{cardname}-Created on:{cardcreationdate}]({cardlink})", for each card linked from an item in checklist "temp", remove the "*" label from the card, find a card titled "{triggercardname}" in list "Completed", and move the card to the top of list "Control"

The same can be done using a report variable and sending the a meaningful string via email like 

[Yellow 1-September 19, 2020](https://trello.com/c/KGU4aR2s) 

[Célia Robillard]

Thanks a lot for your answer, it's appreciated. I'll look into your solution too!

[Iain Dooley]

@Célia Robillard I don't think you can access card creation date in a Butler report, this Trellinator function would do it, you could run it weekly:

https://gist.github.com/iaindooley/55b17e34389c8f78ac2cc1e94e70a288

You can read more about Trellinator here:

https://community.atlassian.com/t5/Marketplace-Apps-Integrations/Introducing-Trellinator-Automate-Trello-with-Google-Apps-Script/ba-p/925271

[Célia Robillard]

Thanks a lot for your answer, it's appreciated. I'll have a look in Trellinator I'm not (yet) familiar with.