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

Is there a code I can use to input the "time in list" to a Butler report?

I'm hoping to include the amount of time a card has been in a list on a report made through Butler. "Time in list" is an option to sort a list by so I know Trello has that information. Is there a code I could use to input the "time in list" to a Butler report?

 

Thanks!

 

Rachel

1 answer

There are a bunch of "time in list" variables you have access to which you can find here, scroll down to "Card time in list" section.

Essentially it is {carddaysinlist}. You can replace days with hours/minutes. And/or replace list with previouslist. And/or add round to the end of the command to round the value to the nearest whole number.

You can insert that in to your report (or anywhere in a butler command) and it'll replace it with the value for you.

Cheers.

The list of variables you linked too was so helpful! Thanks! I tried the {carddaysinlist} and nothing is pulling up in the report. Any chance you know if there is something else I need to add. See below for the pattern section of the rule:

[{cardname}]({cardlink}) ({carddaysinlist}) ({cardmemberusernames})\n\n

Ahhh, I've never done reports before, so hadn't looked at this page

Of note: 
There are certain variables that cannot return data in a Butler report [...] Variables that return any card's time in list data, such as {carddaysinlist} or {carddaysinpreviouslist}.

One way to get around this could be to use either a rule or card button to essentially save the value in to an accessible custom-field before hand.

The command would probably be: Remove checklist Iterate, Collect all cards in to links in checklist Iterate, For each card linked from an item in checklist Iterate, Set custom field tempTime to {carddaysinlist}.
Edit: Changed Collect in to links, not linked items. Or else every single card will end up with an attachment which will be annoying to discover! oops.

(Or you can manually remove the temp Iterate checklist if you don't want it just lying around. I don't think you can get rid of it at the end of the command because you'd be looping.. but on second thought I don't actually know hmm)

Anyways, wrap all that up in either a Rule that only triggers if you label a specific card that you're using to iterate through all this. Or a Card Button that is hardcoded to Find said specific card (or create one).

Then in your Board Button, have the report use {{%tempTime}} instead of {carddaysinlist}.

Miiight need some extra rules to either remind you to do all this before hitting a board-button-generated report. Or if its a schedule-generated report, might need to schedule another rule that triggers a little earlier, which triggers the Rule outlined above.

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