I am looking for a way to update all dates in a custom field at once on all cards in that board

Tim B._8v648b

I have a butler rule stating that if a date is "set" in a custom field and that date is between "so many days from now" (ex: from 120 to 150) then to move that card to a specific list (ex: 120 days to 150 days).

So unfortunately the rule only goes off when the date is "set", so I would have to set the date again for the rule to go off again. 

Temporarily I set up a button that "sets" the custom field to itself, so essentially its sets itself, and the rule runs when I hit the button which is a success. However, I have to go into each card and press the button. 

My question is: Is there a way to have that dynamic so as the date gets closer to today it continues to move to other lists. If not, is there a way to create a button that hits all the buttons on the cards?

Iain Dooley

@Tim B. You might be able to do this with due dates rather than custom fields. If your lists for example were months you could just move the card back one list and set the due date in 1 month's time:

If you need to use due dates for something else and the dates need to be in custom fields, I did something similar for a construction company using Trellinator: they set the date on a card and it moves it to a list "X weeks" and then as the date approaches it moves back through the weeks.

Basically to achieve it, I schedule each of the moves that will be required the first time the date is set, then if the date is changed or the card is moved by another user, I clear it and redo the list. If they move a card into a list "X weeks" then it will set the date to the corresponding monday on which the week begins.

It was reasonably complicated but assuming your board structure is just lists with a set number of days or weeks the logic should translate, so I could redeploy the code for your business.

You can see more about Trellinator here:

https://community.atlassian.com/t5/Marketplace-Apps-Integrations/Introducing-Trellinator-Automate-Trello-with-Google-Apps-Script/ba-p/925271