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

Capture Checklist percentage complete as a custom field for Butler

Mike Moran_uo91sb

Is there a way that I can capture the percentage complete (currently 29% as shown below) within a custom field which can then be displayed on the card front and used in Butler reports? The value would need to dynamically update as checklist items were ticked off.

Annotation 2020-08-21 111758.jfif

I have 164 cards, each with a milestone checklist and I have been asked to report the percentage complete for each Card.

Accepted answers

Iain Dooley

@Mike Moran this Trellinator function would do it:

https://gist.github.com/iaindooley/884bd51ca75f3278b41d39c7ca1bf40b

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

milynnus

@Mike Moran I lost my longer version of this reply so here's the gist of it.

(1) the % are not stored on the card object. I am not aware of any way to intercept Trello as it computes and updates the countCheckItem such that you can keep it in a CF

(2) there are 4 actions for Webhooks fr items e.g. updateCheckItemStateOnCard. You probably have to use this route if you want to do it yourself

(3) I read the Board Export now handles checklist. You might want to export your checklist and work with spreadsheets for your reporting. I have not tried it .

Iain Dooley

@Mike Moran this Trellinator function would do it:

https://gist.github.com/iaindooley/884bd51ca75f3278b41d39c7ca1bf40b

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

milynnus

@Iain Dooley I read in the gist that your have new Notification.... does it mean that this function behaves like a webhook and it gets triggered and the update the CF ? So far, my new Butler add on can be embedded in Butler rules and commands but cannot sit in the shadow waiting for some event to be triggered.

Iain Dooley

@milynnus yep Trellinator adds a webhook to the member object itself and when you first initialise it, to every board the Trellinator user is a member of. Then, whenever the member is removed from or added to a board, the webhooks are updated. Whenever a notification is received, any function installed for that board (you can install a function for one board, a group of boards, or globally) is given the opportunity to deal with the notification.

milynnus

@Iain Dooley Thanks for sharing. I know that for webhook you need to associate with a token which is member specific. Is that what you meant by “add webhook to member object” ? I also know that there is a callback URL for webhook, is this the endpoint and where the function sits? In your case, where is this endpoint ‘hosted’ ?
I am trying to imagine how I can do it, perhaps like https:123455.wayscript.io/?user=something&func=abc .... can start to see the complexity. Your answers to above will be very helpful. Thanks in advance. Learning from the guru.