How to I automate certain events to happen on cards with specific labels on the first of the month

Question

Hi there,

My business has recently developed a sort of subscription service where people can pay monthly fees to get a selection of benefits along with either 1 or 2 visits per month depending on the package they selected.

What I'm looking for on Trello is a way to have cards with the yellow label (signifying that they're a member of the program) to increase a custom field by 1 (or 2, depending on the label) every month on the first of the month when the payments come out.

So ultimately I'm looking for a way to make a rule that states "On the first of every month, increase the custom field "number of sessions available" by 1 on cards with the yellow subscription label"

It doesn't seem on my end that this is possible in Butler, but I don't understand why. Is there any plans to adjust Butler to allow for these kind of automations or is there a power-up I can use to make this happen instead?

milynnus · Answer

@Megan @Iain Dooley

Here's a demo of the above implementation. The report variable is just {cardidlong} and I added in the payload the custom field name.

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=5f216a81.....6&module=5f5d92b5.......2bb3b8" with payload "{ "rep_list_card_ids" : "{$rep_list_card_ids}" , "cf_name" : "Number" }"

The only additional code to handle the report variable is

card_ids = para['rep_list_card_ids'].split("
")
card_ids.pop() #remove last element

The rest of the coding of module remains pretty much the same.

This new approach opens up new ways to enhance your Butler experience.

https://youtu.be/gr5_tWnO-Xw

(my apologies - my video production need much improvement)

milynnus · Answer

@Megan @Iain Dooley

Did this simple test see how to use a report variable together with a Butler HTTP Request

create a report in variable "ycard" with all cards with the yellow label using pattern "[{cardname}]({cardlink}) - {cardidlong}", and post to url "https://28084.wayscript.io/mailchimp/webhook" with payload "{ "ycard" : "{$ycard}")"

Below is the json received at the end point (just used an existing one). It does mean, with a better ycard pattern I can then passed it to a module that will use the card id to update the CF for each of the cards or

{ "ycard" : "[Checklist Item 1](https://trello.com/c/V6A07wxl) - 5f56118......264726
[Checklist Item 2](https://trello.com/c/GtOyG59k) - 5f56131.....d6930b
[Checklist Item 3](https://trello.com/c/Rijhlhri) - 5f5611.....33e95c05
")

I could return as httpresponse.something that Butler can continue work to update the CF.

Megan_8g7ksf · Answer

Thank you so much! I will give this a try!