Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Set due date w/ combining two custom fields

Jim Nichols
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 9, 2024
  • I am looking to have a custom field "Order Date" (this will be set to "now"
  • I want to have another custom field "Weeks Out" (this will be a drop down of options "1-8"
  • Then I would like to set the due date to be "Order Date" + "Weeks Out"

Having issues building this. I have tried " {{%Last Ordered}}+{{%Cycle}w} " to no avail.

What am I missinhg?

Thoughts?

3 answers

1 vote
Dreamsuite Mike
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 13, 2024

Hi @Jim Nichols 

This can be done but you need an additional custom date field:

When custom field Order Date is set in a card with custom field Weeks Out set to "{*}", set the custom field "Due Date" to {customfieldvalue+{wildcard1}w} and set the due date to the date in the custom field "Due Date"

As a bonus, you can also have this one so that your automation will work trigger in both instances that Order Date and Weeks Out are set:

 

When custom field Weeks Out is set to "{*}" in a card with custom field "Order Date" set, set the custom field "Due Date" to {{%Order Date+{wildcard1}w}} and set the due date to the date in the custom field "Due Date"

 

0 votes
Mary from Planyway
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
February 11, 2024

Hi @Jim Nichols 

It's Mary from Planyway calendar, timeline, time tracking for Trello

 

Let's break down the steps to achieve this and see where the issue might lie.

1. Setup Custom Fields

First, ensure you have two custom fields set up:

  • Order Date: This should be a date type custom field. You mentioned setting this to "now," which suggests you want the current date/time when the card is created or the field is set.
  • Weeks Out: This should be a dropdown type custom field with options for 1-8 weeks.

2. Creating the Automation Rule

To calculate the due date based on these fields, you'll need to create a rule that triggers upon changes in these fields. However, it seems like the syntax you've tried might be slightly off, especially since Trello's date arithmetic syntax can be particular.

The Correct Approach

  1. Trigger: The rule should trigger when either the "Order Date" is set or the "Weeks Out" field is changed.
  2. Action: The action should calculate the due date based on the "Order Date" plus the number of weeks specified in "Weeks Out."

The correct format for date manipulation using custom fields wasn't clearly stated in your example. Here’s a more detailed approach on how to set it up:

  • Rule Setup in Butler: You need to create a command in Butler that listens to changes in the "Weeks Out" custom field (or the "Order Date" field, depending on your workflow) and then calculates the due date accordingly.

Example Rule

  1. Trigger: "When custom field 'Weeks Out' is set on a card,"
  2. Action: "set due date using variable {{%Order Date}} plus {{%Weeks Out}} weeks."

However, this exact syntax might not work directly due to how Butler handles date addition and custom fields. The correct syntax often depends on ensuring:

  • The custom fields are correctly referenced by their names.
  • Date addition syntax is correctly used according to Butler's documentation.
0 votes
Alex W
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
February 11, 2024

Hi @Jim Nichols - welcome to the Community!

Unfortunately I do not believe it is possible to pass mathematical queries such as this in Trello's automation feature. 

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events