Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

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

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

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

Suggest an answer

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

📹 What is Trello?

Hello Community!  My name is Brittany Joiner and I am a Trello enthusiast and Atlassian Community Leader. I'll be sharing with you a series of videos with my top tips on how to best use Trello...

752 views 13 30
Read article

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