nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Does ScriptRunner allow for this type of calculated field? (see example below)

Neil Goodwin_kc45gq

I am looking for a addon (or OOTB Jira functionality, but do not believe this is supported) that can handle this type of calculated field.

Will Scriptrunner be able to support this type of formular on a calculated field?

The single select fields referenced below have numbers associated with them for the calculations.

(Number field1 + Single Select field1 + Single Select field2 x Number field2 x Single Select field3 x Single Select field4) = Calculated field Value)

Accepted answers

Tuncay Senturk _Snapbytes_

Hi @Neil Goodwin

Script Runner is indeed capable of implementing complex calculated fields like the one you've described. It can execute custom scripts that can read from various fields within an issue, perform calculations, and then use the result as a custom field value. But you have to convert select option values to numbers.

Below you can find the code snippet as a start.

def numberField1 = customFieldManager.getCustomFieldObjectByName("Number field1").getValue(issue)
def singleSelectField1Value = customFieldManager.getCustomFieldObjectByName("Single Select field1").getValue(issue)?.getOptionId()
def singleSelectField2Value = customFieldManager.getCustomFieldObjectByName("Single Select field2").getValue(issue)?.getOptionId()
def numberField2 = customFieldManager.getCustomFieldObjectByName("Number field2").getValue(issue)
def singleSelectField3Value = customFieldManager.getCustomFieldObjectByName("Single Select field3").getValue(issue)?.getOptionId()
def singleSelectField4Value = customFieldManager.getCustomFieldObjectByName("Single Select field4").getValue(issue)?.getOptionId()

// convert option value to number
def singleSelectField1Number = getNumberForOption(singleSelectField1Value)
def singleSelectField2Number = getNumberForOption(singleSelectField2Value)
def singleSelectField3Number = getNumberForOption(singleSelectField3Value)
def singleSelectField4Number = getNumberForOption(singleSelectField4Value)

return (numberField1 + singleSelectField1Number + singleSelectField2Number) * numberField2 * singleSelectField3Number * singleSelectField4Number

// Placeholder function for getting the number associated with a single select field option
def getNumberForOption(Long optionId) {
   .... 
   return ... 
}

Assume that getNumberForOption method is the method for converting the option values to numbers.

I hope that helps!

Nic Brough -Adaptavist-

Welcome to the Atlassian Community!

If you have a more recent version of Scriptrunner, then you can do this much more easily by using HAPI.

You have not told us exactly how your select lists are representing numbers in their options, so I've made an assumption, but:

<span>def</span><span> issueKey </span><span>=</span> <span>"ISSUE-KEY"</span> <span>// Replace with the actual issue key - this is written as a console script, where you have to feed it the issue you want to work with</span>

<span>def</span><span> issue </span><span>=</span><span> Issues</span><span>.</span><span>getByKey</span><span>(</span><span>issueKey</span><span>)</span>

<span>// Retrieve the field values</span>
<span>def</span><span> numberFieldValue1 </span><span>=</span><span> issue</span><span>.</span><span>getCustomFieldValue</span><span>(</span><span>'Numberfield1'</span><span>)</span> <span>as</span><span> Double </span><span>// Assuming the field contains a numeric value</span>
<span>def</span><span> singleSelectFieldValue1 </span><span>=</span><span> issue</span><span>.</span><span>getCustomFieldValue</span><span>(</span><span>'SingleSelectfield1'</span><span>)</span><span>.</span><span>value </span><span>as</span><span> Double </span><span>// Assuming the option has a numeric string value</span>
<span>def</span><span> singleSelectFieldValue2 </span><span>=</span><span> issue</span><span>.</span><span>getCustomFieldValue</span><span>(</span><span>'SingleSelectfield2'</span><span>)</span><span>.</span><span>value </span><span>as</span><span> Double </span>
<span>def</span><span> numberFieldValue2 </span><span>=</span><span> issue</span><span>.</span><span>getCustomFieldValue</span><span>(</span><span>'Numberfield2'</span><span>)</span> <span>as</span><span> Double </span>
<span>def</span><span> singleSelectFieldValue3 </span><span>=</span><span> issue</span><span>.</span><span>getCustomFieldValue</span><span>(</span><span>'SingleSelectfield3'</span><span>)</span><span>.</span><span>value </span><span>as</span><span> Double </span>
<span>def</span><span> singleSelectFieldValue4 </span><span>=</span><span> issue</span><span>.</span><span>getCustomFieldValue</span><span>(</span><span>'SingleSelectfield4'</span><span>)</span><span>.</span><span>value </span><span>as</span><span> Double </span>

<span>def</span><span> result </span><span>=</span> <span>(</span><span>numberFieldValue1 </span><span>+</span><span> singleSelectFieldValue1 </span><span>+</span> <span>(</span><span>singleSelectFieldValue2 </span><span>*</span><span> numberFieldValue2 </span><span>*</span><span> singleSelectFieldValue3 </span><span>*</span><span> singleSelectFieldValue4</span><span>)</span><span>)</span>

<span>log</span><span>.</span><span>debug</span><span>(</span><span>"The result of the calculation is: </span><span>$</span><span>result</span><span>"</span><span>)</span>

<span>// If you need to store the result back into another custom field, you can do so like this:</span>
<span>issue</span><span>.</span><span>update </span><span>{</span>
    <span>setCustomFieldValue</span><span>(</span><span>'ResultField'</span><span>,</span><span> result</span><span>.</span><span>toString</span><span>(</span><span>)</span><span>)</span> <span>/</span>

All comments

Tuncay Senturk _Snapbytes_

Hi @Neil Goodwin

Below you can find the code snippet as a start.

def numberField1 = customFieldManager.getCustomFieldObjectByName("Number field1").getValue(issue)
def singleSelectField1Value = customFieldManager.getCustomFieldObjectByName("Single Select field1").getValue(issue)?.getOptionId()
def singleSelectField2Value = customFieldManager.getCustomFieldObjectByName("Single Select field2").getValue(issue)?.getOptionId()
def numberField2 = customFieldManager.getCustomFieldObjectByName("Number field2").getValue(issue)
def singleSelectField3Value = customFieldManager.getCustomFieldObjectByName("Single Select field3").getValue(issue)?.getOptionId()
def singleSelectField4Value = customFieldManager.getCustomFieldObjectByName("Single Select field4").getValue(issue)?.getOptionId()

// convert option value to number
def singleSelectField1Number = getNumberForOption(singleSelectField1Value)
def singleSelectField2Number = getNumberForOption(singleSelectField2Value)
def singleSelectField3Number = getNumberForOption(singleSelectField3Value)
def singleSelectField4Number = getNumberForOption(singleSelectField4Value)

return (numberField1 + singleSelectField1Number + singleSelectField2Number) * numberField2 * singleSelectField3Number * singleSelectField4Number

// Placeholder function for getting the number associated with a single select field option
def getNumberForOption(Long optionId) {
   .... 
   return ... 
}

Assume that getNumberForOption method is the method for converting the option values to numbers.

I hope that helps!

Nic Brough -Adaptavist-

Welcome to the Atlassian Community!

If you have a more recent version of Scriptrunner, then you can do this much more easily by using HAPI.

You have not told us exactly how your select lists are representing numbers in their options, so I've made an assumption, but:

<span>def</span><span> issueKey </span><span>=</span> <span>"ISSUE-KEY"</span> <span>// Replace with the actual issue key - this is written as a console script, where you have to feed it the issue you want to work with</span>

<span>def</span><span> issue </span><span>=</span><span> Issues</span><span>.</span><span>getByKey</span><span>(</span><span>issueKey</span><span>)</span>

<span>// Retrieve the field values</span>
<span>def</span><span> numberFieldValue1 </span><span>=</span><span> issue</span><span>.</span><span>getCustomFieldValue</span><span>(</span><span>'Numberfield1'</span><span>)</span> <span>as</span><span> Double </span><span>// Assuming the field contains a numeric value</span>
<span>def</span><span> singleSelectFieldValue1 </span><span>=</span><span> issue</span><span>.</span><span>getCustomFieldValue</span><span>(</span><span>'SingleSelectfield1'</span><span>)</span><span>.</span><span>value </span><span>as</span><span> Double </span><span>// Assuming the option has a numeric string value</span>
<span>def</span><span> singleSelectFieldValue2 </span><span>=</span><span> issue</span><span>.</span><span>getCustomFieldValue</span><span>(</span><span>'SingleSelectfield2'</span><span>)</span><span>.</span><span>value </span><span>as</span><span> Double </span>
<span>def</span><span> numberFieldValue2 </span><span>=</span><span> issue</span><span>.</span><span>getCustomFieldValue</span><span>(</span><span>'Numberfield2'</span><span>)</span> <span>as</span><span> Double </span>
<span>def</span><span> singleSelectFieldValue3 </span><span>=</span><span> issue</span><span>.</span><span>getCustomFieldValue</span><span>(</span><span>'SingleSelectfield3'</span><span>)</span><span>.</span><span>value </span><span>as</span><span> Double </span>
<span>def</span><span> singleSelectFieldValue4 </span><span>=</span><span> issue</span><span>.</span><span>getCustomFieldValue</span><span>(</span><span>'SingleSelectfield4'</span><span>)</span><span>.</span><span>value </span><span>as</span><span> Double </span>

<span>def</span><span> result </span><span>=</span> <span>(</span><span>numberFieldValue1 </span><span>+</span><span> singleSelectFieldValue1 </span><span>+</span> <span>(</span><span>singleSelectFieldValue2 </span><span>*</span><span> numberFieldValue2 </span><span>*</span><span> singleSelectFieldValue3 </span><span>*</span><span> singleSelectFieldValue4</span><span>)</span><span>)</span>

<span>log</span><span>.</span><span>debug</span><span>(</span><span>"The result of the calculation is: </span><span>$</span><span>result</span><span>"</span><span>)</span>

<span>// If you need to store the result back into another custom field, you can do so like this:</span>
<span>issue</span><span>.</span><span>update </span><span>{</span>
    <span>setCustomFieldValue</span><span>(</span><span>'ResultField'</span><span>,</span><span> result</span><span>.</span><span>toString</span><span>(</span><span>)</span><span>)</span> <span>/</span>

Humberto Gomes

Hi, can get this using automation, do not need a script runner for this.

see

Jira smart values - math expressions | Cloud automation Cloud | Atlassian Support

it works also for DC version.

Let me know if you need additional support.

Nic Brough -Adaptavist-

Except that you can't convert the select lists to numbers, you would have to write potentially hundreds of "if" statements.

Neil Goodwin_kc45gq

Thank you all for the replies and the +1 of providing some scripts.

The dropdowns have text that are associated with values (screenshot below) It sounds like ScriptRunner is the way to go, as the OOTB functionality may/will require too many "if" statements.