It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Butler Automation for Setting Staged Due Dates

I am currently using Trello to manage custom CAD/CAM manufacturing orders. I've been able to dramatically reduce the amount of manual entry for cases using butler and some other 3rd party automation software. One thing I'm still struggling with is setting staged due dates, so I thought I'd ask you guys. The best way I've come up with to see our staged due dates is having custom fields for each one and then setting the Card due date to the next custom date as it gets moved along the lists. We start with the "ship to customer" date, subtract 2 working days for the "finishing" date, subtract another 2 for "Manufacturing" date, and yet another 2 for "CAD Design" date. I would like to set 1 of those dates and have butler extrapolate the others. I found how to set the card due date based on a custom date field +- working days, but not the option to set custom field date based off another date +- days. In the butler documentation it shows some potential solution by directly coding the butler rule with arithmetic expressions but I can't find anywhere that those expressions can be manually entered. Thank you for any help! Sorry if this has been answered, I promise I looked haha!

1 answer

1 accepted

0 votes
Answer accepted
Iain Dooley Community Leader Apr 22, 2019

@Nate Brock Yes I think you're correct. I can't see any options in the Butler Power Up for setting a date custom field value relative to a due date set on a card. This used to be a feature of the Butler Bot.

While you're waiting for the power up feature set to catch up with the former capabilities of the bot, you can use Trellinator to do this type of thing directly via the API. Here is the code to set custom field values based on an offset from an added due date:

https://gist.github.com/iaindooley/3b5bd2fdd8f327fa8fe750e82bd6d587

Trellinator just runs as a "bot" user, similar to how Butler used to work, so you can use Trellinator commands in conjunction with Butler commands with no hassle.

You can see how to setup/install Trellinator here:

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

This is awesome! Thank you so much! I hadn't seen the Trellinator bot yet. I'll be messing around with this all weekend.

Like Iain Dooley likes this
Iain Dooley Community Leader Apr 24, 2019

@Nate Brock Cool yeah I only really started promoting it at the end of last year. I wrote it to port a bunch of Butler Bot commands over to so the syntax should be quite "Butler like". Debugging it can take some getting used to though, let me know how you go 

@Iain Dooley how's the situation with the butler power up now, would this be doable with the powerup?

Iain Dooley Community Leader Oct 25, 2019

@Thibault Molleman Not sure man I'm not really keeping tabs on it, try it out and let us know!

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Trello

Develop a new Habit during Lockdown

If you had to thrive a new habit during a lockdown, what would it be? Trello

1,569 views 13 5
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you