Automate Attribute Summation and Field Update in Jira Cloud
Platform Notice: Cloud Only - This article only applies to Atlassian products on the cloud platform.
Summary
Use Automation to update Jira fields with summed asset values from custom fields.
Solution
Assume you have a Jira text field called "Cost." Populate it with the total sum of the "Cost" attribute from the Asset object field.
To achieve the use case. Kindly configure the automation rule as below:
1. From the Automation page in Project Settings, create a rule that triggers at Field Value Changed.
2. Next, add Create variable action and use the below syntax to sum the attribute value:
{{#=}}{{#<AssetObject-field-name>}} + {{<attribute-name>}}{{/}}{{/}}
Example from my test instance:
{{#=}}{{#Insight Object2}} + {{Cost}}{{/}}{{/}}3. Then, add the Edit issue action to update the Jira Field using the below smart value: {{total}}
Refer to the rule attachment below:
The above syntax iterates over every item from the Asset object field list and keeps adding its value. We had three objects in the Asset object field, and we got the sum of the "Cost" attribute in the "Cost" Jira field.
In case you need to update a field with a "Number type Jira custom field," then we need to convert the string variable "total" to a number as "{{total.asNumber}}".
Was this helpful?