nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Sum minutes and seconds of cards to list

Daniele Semeraro

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!

Accepted answers

All comments

Vero Rivas

Hi @Daniele Semeraro

Look at this posts, maybe can help you:

https://trello.com/power-ups/5c592ae4d74ac4407f4e3af3/activity

https://trello-guide.vizydrop.com/calculations

https://py-trello-dev.readthedocs.io/en/latest/_modules/trello/card.html

https://community.atlassian.com/t5/Trello-questions/Can-you-generate-a-sum-of-numeric-custom-fields-on-all-cards-on/qaq-p/1448061

Cheers

Daniele Semeraro

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

Hannah Humbert - Simpla Workflows

@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

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

Iain Dooley

@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

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

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

trello

time