Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,298,096
Community Members
 
Community Events
165
Community Groups

Setting due date based on two conditions

I have a board with a list named Tuesday. I want to create the following rule. If a card is created in this List, it should be assigned a due date based on these two conditions:

1) If today is Tuesday, then set due date now.

2) If today is Wednesday, Thursday, etc., then set the due date the next Tuesday.

Butler can easily implement condition 2), but how to augment the rule with condition 1)? 

Thanks!

2 answers

1 accepted

0 votes
Answer accepted

@Pavel 

When you create a new card include a label that has a name using a date variable for day of the week (invisible) and use that to trigger the due dates. It should work. 

@Pavel 

 

Card added on Tuesday is due now...it kind to travel to the future and back.

Will wait till tomorrow to add a card because it will have a Wednesday label and next Tuesday due date and will remain "as is" since the second trigger would fail.

 

Screen Shot 2021-07-27 at 3.26.14 PM.jpg

Like Pavel likes this

Hi @milynnus , this is super smart! You guys are amazing! Thanks a lot for your help!

@Pavel 

FYI, I tested with a new card created on List "Tuesday" the due date is next Tuesday Aug 3.

Like Pavel likes this
0 votes
Iain Dooley Community Leader Jul 26, 2021

@Pavel my first thought was to set the due date to yesterday then move it to the next tuesday, however "the next tuesday" in that command always offsets versus the current time rather than the due date on the card which seems like a bug to me :(

This BenkoBot function would do it though:

https://gist.github.com/iaindooley/2e6d9fdd60f68e3b16a6cbfe22344354

You can preview the code in your own BenkoBot account by clicking this link and entering your API key/token:

Click here to preview code in BenkoBot 

Note that BenkoBot currently doesn't support timezones so I've added a 10 hour offset for my own timezone before and after the calculation. I'm in GMT+10, you'd need to modify the add/minus hour amounts to suit your timezone otherwise you might find that the definition of "Tuesday" changes.

Also note this will work for any list named with a weekday, so if you add a card to Wednesday on Wednesday it will set due now, otherwise it will set due to the following Wednesday and so on.

Hi @Iain Dooley, thanks for your solution! Super nice idea to move the due date to yesterday first, but unfortunately, as you pointed out, this doesn't solve the problem because of how Butler defines the "next Tuesday". I will try out the BenkoBot functionality, haven't used this tool before, and am excited to try it out! 

Suggest an answer

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

Taco Tuesday: New years' resolutions with Trello

Congratulations to @Laura Holton , our latest winner of Taco Tuesday! And thanks to @Kristján Geir Mathiesen for sharing the picture of Taco having fun with his new friend  B...

2,351 views 28 40
Join discussion

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