A Powerful Combination

[milynnus]

Update (Feb 14, 2023) : this capability is now available on my new Space Bulter app. You can find it at [https://deta.space/discovery/@milynnus/space_butler](https://deta.space/discovery/@milynnus/space_butler)

Update : backend has been migrated see https://trello.com/b/POqPZOwG/just-a-butler-add-on

Many of you have already learned how to generate reports with Trello. Have you wished that you can take actions to effect changes on your board based on the reports you read?

Just last night I stumbled upon a powerful combination in using Butler. I learned that I can use report variables {$report_variable} to feed data to Butler Http Request to an endpoint to effect changes to your board or to return you values via httpresponse.anything the next Butler command.

You get to create report variables when you create a Board Button or a Calendar Command. Here's a simple example to illustrate this powerful combination.

1) it gathers the card ids of all cards that has a yellow label

2) it sends it to an endpoint where it runs a program to increment all the custom field "Number" by 1

create a report in variable "rep_list_card_ids" with all cards with the yellow label using pattern "{cardidlong}", and post to url "https://25368.wayscript.io/butler/?registry=5f216.....80f24ade5c6&module=5f5d92b......85e42bb3b8" with payload "{ \"rep_list_card_ids\" : \"{$rep_list_card_ids}\" , \"cf_name\" : \"Number\" }"

The above can be attached to a Calendar command to run it at the end of the day, 1st day of the month, ...etc or as a board button that you can activate manually.

This picture shows you the various criteria you can use to create your report variable.

Here's a video https://youtu.be/gr5_tWnO-Xw  of the above. (Yes, I need to do a better job when producing video content :{ )

As you can see I have already built the backend for the endpoint and have some pre-built modules. The application supports Butler Http Request, Trello webhook, Code by Zapier and a sandbox Trello board. The input can be fed from within Butler using variables including report variables or hand-coded.

Let me know what you think of the above especially ideas on the kind of processing you like to see and how it can be made available to you. Thanks.