I am collecting numerical information in the cards, and want to be able to add them up to a total without having to export the data?
Has anyone figured out a way to do this?
@Tim Boyle as far as I know, the Butler power up doesn't have the ability to loop through all cards in a list and sum the values for a given custom field although @Oscar_Triscon or @Katrin Anger would be able to confirm if that's the case.
In the meantime this Trellinator function would set the name of lists to "List Name (XX)" where (XX) is the SUM of all values in the custom field "Something to Tally" whenever a card was moved (it will update the names of the list the card was moved out of as well as the list the card was moved into):
Obviously you might need to tweak that to suit your specific use case. You can see more about Trellinator here:
Hi Tim, yes there is a way to calculate numeric custom fields. Actually, there are two ways.
The first, is setting up a new custom fields that stores the calculated value. And the action for this could look like this:
Alternatively, you could store the calculated value in either the description of a card or in a comment.
Setting up the command's action would look like this:
(I made use of only one example here)
You could even send the result of the calculation off by email (if you have a paid account). And a fourth way would be by using user variables, but that's probably the least comfortable one.
Does that help?
@Katrin Anger that would sum the value of fields on an individual card though... My read of Tim's requirement was to take the value of a field that occurs on multiple cards and present the total.
Could you trigger when a custom field is modified, fetch a "total" card with the current total in it and add the new value set on the card?
If that's really Tim's requirement than I currently see no other way than setting up user variables on this.
One could add values to card variables, and use them in a calculation.
Even if the value in the custom field changes and the card variable is modified accordingly, the calculation should work.
If you had to thrive a new habit during a lockdown, what would it be? Trello
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