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

How can I use the variable days in list on Butler report?

Hi everyone!
I want to make a report showing how many days the card is in the list.
I'm using this pattern
- [{cardname}]({cardlink}) - Days in list: {carddaysinlist} \n

But unfortunately the report isn't work as I want.

Do you have any idea what I am doing wrong?

Thanks so much!

7 answers

2 accepted

1 vote
Answer accepted
Mike Atlassian Team Mar 27, 2020

Hi all,

 

Thanks, Mark, for bringing this to our attention—​I did a little digging, and unfortunately, this is expected. There are a handful of variables that are extremely taxing on Trello's API, so they aren't available for use in reports, specifically.

 

{carddaysinlist} is one of those, but I'm especially sorry that this isn't documented anywhere on help.trello.com. Our team is fixing that as we speak. Moving forward, we'll keep looking into other ways that we might be able to get this working for reports too.

0 votes
Answer accepted
Iain Dooley Community Leader Mar 27, 2020

@Giles_Camargo since @Mike has confirmed this isn't available, if it's something you still want to achieve something like this Trellinator function will do it:

https://gist.github.com/iaindooley/8e0b962ff1a3a1ea599df8db7ccee5bd

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

1 vote
Iain Dooley Community Leader Mar 13, 2020

@Giles_Camargo What output are you getting from the report? 

@Iain Dooley can you confirm and/or validate that using the pattern Giles provided actually works?  Or can you provide an example pattern with this variable that does work?

Iain Dooley Community Leader Mar 25, 2020

@Mark_D I don't have a paid plan so I can't test it

Iain Dooley Community Leader Mar 25, 2020

@Mark_D oh actually I can test it by creating a card and setting the description to the variable instead of sending an email. Indeed none of the card*inlist variables seem to be set. Seems like a job for support@trello.com what do you think @Torben ?

Like Jeffrey Hubbard likes this

Just in case, I submitted something to support@trello.com.  We're on enterprise so hopefully that speeds things up.  Thanks for your help all -- I'll let you know what I find out.

I'm surprised that community leaders aren't automatically given business-class or enterprise-type access.  Can't Atlassian do something better here for their community supporters?

I'm having the same issue this morning.

My output shows a blank:

Days card has been in this list: <<result should be here>>

code : Days in List: {carddaysinlist}\n\n

I suspect this isn't avail for reports 

I'm having the same issue.  I think a key use case for reports is expediting items that are stale in the list.  Outside of an assigned deadline -- I would think time-in-list would be a critical variable.

Thanks Mark. I hadn't had time to submit yet..

 

Jeff

 

oops replied to wrong reply.

Hi everyone!
What do I want to do? I want to show how many days the card is in the current list. For exemple: I moved a card to the list WAITING FOR two days ago. In my report i want to show that the card is stoped there for two days.

thank you all!

Hi @Iain Dooley!
I appreciate your attention.
I`m a business analyst and I will send this topic for our developer team!

Thanks!

Hello. When can we expect a fix or an workaround? It is a key piece of information.

Thank you.

Suggest an answer

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

Develop a new Habit during Lockdown

If you had to thrive a new habit during a lockdown, what would it be? Trello

1,597 views 14 6
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