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!
@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:
or via our BenkoBot platform as a "Listener":
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).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@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:
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Cheers
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you for your reply. Unfortunately I couldn’t find anything. Did you find something useful? Thank you.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.