Trello - Sum of Checked Custom Fields in Emailed Report

Question

Hello,

We have enabled Butler and Custom Fields, and are hoping to implement a solution that will send a Report of a Sum of the number of checked custom field items across a board.

For example, the Button to create a report with the following command works, but lists all the cards with a checked item, instead of giving us a sum number of them:

"

create a report with all cards with custom field "IUS" checked using pattern "- [{cardname}]({cardlink}) ({cardmemberusernames}) => DUE on {cardduedate}

", and send an email notification to "me@myemail.com" with subject "Number of IUS Deliverables Complete for week {date}" and message "All Cards with IUS Complete:

{$report}"

"

I get the attached report with all the cards listed out - but I would like a sum of the amount of cards that are listed instead. Is that possible?

Thanks,

Ariel

Ludo_gn7289 · Answer

Hi

As checklist count, some variables are available like

{cardchecklistcount} the number of checklists on the card.

{cardcompletechecklistcount} the number of complete checklists on the card.

{cardincompletechecklistcount} the number of incomplete checklists on the card.

But it doesn't concern custom field.

An alternativ is to create a card in which a number custom field is increased for each checked custom field.