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; } } }

add value from one card's custom field to another card's different field

RP_4y07br

I'm trying to add the value from the custom field on one card to a different custom field on another card.

For example, I have a card with the POINTS custom field set to 5. When I move that card to the Done list, I'd like to add those card's POINTS to the TOTAL_POINTS field on another card.

I've fiddled around with Butler's find and lookup options, but can't see how to pass values between a custom field and a different field specified on either the trigger-card or the found-card.

Additionally, it would be nice if I could limit the field TOTAL_POINTS to one card only, without having to include it on every card on the board.

Many thanks--

Accepted answers

Iain Dooley

@RP yeah you can't do arithmetic with custom field values in the butler power up, here's a Trellinator function that does what you need:

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

You can read more about Trellinator here:

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

All comments

Iain Dooley

@RP yeah you can't do arithmetic with custom field values in the butler power up, here's a Trellinator function that does what you need:

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

You can read more about Trellinator here:

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

RP_4y07br

Thanks for writing up that function. I'm sure it's great--if only I had any idea how to use it!

I followed the shorter startup guide in the link, and have it working, but have no idea how to do anything else, including implementing that little function or any other. Does this mean I have to learn to write javascript?

There is one way to perform arithmetic on custom fields in Trello. The problem is that it requires dedicating your card's description fields to storing the value of the custom field you want to sum.

So eg this Butler rule will store Points in the description field:

when custom field "Points" is set by anyone, set the card's description to "{{%Points}}"

Then this rule will transfer that card's Points to another card (WEEK SCORE card), add them to existing Points in that card's description, and copy the total to the custom field SCORE.

when a card is moved into list "Done" by anyone, find a card titled "WEEK SCORE" in list "Done" on board "JNP ToDo", set the card's description to "{triggercarddescription} + {foundcarddescription}", and set custom field "SCORE" to "{foundcarddescription} + {triggercarddescription}"

But it's pretty kludgy.

Iain Dooley

@RP if you were able to get the initial function working from the article, then all you need to do is follow the exact same procedure as you did for installing the code under the heading "Something more interesting". If you set that thing up as a global command then invite your Trellinator bot user to will run the function for any card moved to a list called "Done" with a card called "Points Overview" in it.

RP_4y07br

EDIT: resolved this; I guess I hadn't updated the script editor after changing/correcting that function

Ok thanks--I've been messing around with it a bit more and can now do what you're describing. It's great.

a couple questions:

for some of the functions being run in the Google sheet, I'm regularly getting error messages like this in the info log: "executing realtime function: subtasksNewName","Test Board [5d99ea0bc4081f7cd7ee66cf]subtasksNewName\n98eb8c1a65c299e057b5259b39761243","function: subtasksNewName TypeError: Cannot find function subtasksNewName in object [object Object]."
1. this is for your function subtasks that I renamed subtasksNewName
2. part of what's weird is that the function will eventually run as expected
perhaps relatedly--often the lag between inputting the trigger on the Trello board and having the function run is 10 minutes or more. Is that normal?
I'm doing all this on the Test Board set up per the intro to trellinator article.

Many thanks for your help.

Welcome!

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

Quick Links

Find more posts tagged with

trello