Sum minutes and seconds of cards to list

Daniele Semeraro March 6, 2021

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
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 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/

Tri R November 10, 2021

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
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 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 Humbert - Simpla Workflows
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 8, 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. 

Daniele Semeraro March 13, 2021

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

0 votes
Vero Rivas
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 7, 2021
Daniele Semeraro March 8, 2021

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

Like José Ferro likes this

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events