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

Creating a weekly report for the newly added cards?

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.

2 answers

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

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

0 votes
Iain Dooley Community Leader Sep 21, 2020

@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

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

Like Iain Dooley likes this

Suggest an answer

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

Taco Tuesday: Your favorite Trello blog takeaway

Hello friends! From the community that brought you Welcome Wednesday, Throwback Thursday and Friday Fun, welcome to Taco Tuesday, a weekly discussion about all things Trello. The best part? One Tac...

237 views 11 10
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