Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,298,025
Community Members
 
Community Events
165
Community Groups

Sum minutes and seconds of cards to list

Hi there,
I use Trello to organise a tv programme: every list is a episode, every card is a news. I would like to add minutes and seconds to every card and have a card on top of every list which sums times and gives me the exact time of the entire episode. So if an episode is too long I can move a card to the next one.

I've tried Smart Fields power up that does the same with numbers (not minutes and seconds).

Can you help? Thank you!

3 answers

0 votes
Iain Dooley Community Leader Mar 16, 2021

@Daniele Semeraro this Trellinator function would allow you to sum the minute and second values from a custom field value called "Time" whenever a card is moved into a list and set the name of the first card in the list to the sum:

https://gist.github.com/iaindooley/dcaa9d432bd5b7fbb6800bd16afa0a59

You can run it via Google Apps Script:

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

or via our BenkoBot platform as a "Listener":

https://app.benkobot.com/

hi @Iain Dooley thank you for providing this! It's also something I've been dying to find on Trello. Would it be possible for you to walk through what need to be implemented after the code is pasted into google apps scripts and trellinator is activated? I keep getting an error when I try to run it (full disclosure this is my first time ever trying anything close to coding).

Iain Dooley Community Leader Nov 10, 2021

@Tri R if you're not a developer, then you're probably not going to be able to get it working on your own in Google Apps Script. It was always a bit tricky, but recent changes by Google have made it even trickier.

You'd be better off running it under the BenkoBot platform which is a product we developed to replace Google Apps Script hosting for Trellinator functions:

https://app.benkobot.com/

I have created this handy automated install link that will install the code in your BenkoBot account:

Click here to preview the code

You just need to enter your API key/token and then you'll be able to select on which boards you would like this to be active, and review the code, before saving it as a Trello listener.

If you want the code edited/customised/modified we can put you in touch with one of our vetted BenkoBot developers.

0 votes
Hannah Morgan Community Leader Mar 08, 2021

@Daniele Semeraro this chrome extension might help: https://chrome.google.com/webstore/detail/ultimello-the-features-pa/hahbfgjfimnmogoinnenhheepfcphnmm

The idea would be to use a numerical custom field using the custom fields powerup, and the chrome extension would sum up the values from all the cards in each list. 

Thank you very much. The fact is that I don’t need to sum up regular numbers but time. For example 1:50 + 0:20 = 2:10

Thank you for your reply. Unfortunately I couldn’t find anything. Did you find something useful? Thank you. 

Suggest an answer

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

Taco Tuesday: New years' resolutions with Trello

Congratulations to @Laura Holton , our latest winner of Taco Tuesday! And thanks to @Kristján Geir Mathiesen for sharing the picture of Taco having fun with his new friend  B...

2,347 views 28 40
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