Clone wiki

JIRA Workflow Toolbox / amazing / Set a Field as a Function of other Fields

Set a Field as a Function of other Fields

Let's suppose we want to set a custom field called "Urgency" depending on issue "Priority" and the value of another custom field called "Impact".

Used Features

How to do it

  1. Use post-function "Set a field as a function of other fields" to set on virtual fields "Ephemeral number 1" and "Ephemeral number 2" with a numeric value associated to issue "Priority" and the value of custom field "Impact".
  2. Use post-function "Mathematical and date-time expression calculator" to calculate the sum of "Ephemeral number 1" and "Ephemeral number 2" and store the result on "Ephemeral number 1".
  3. Use post-function "Set a field as a function of other fields" to set custom field "Urgency" from the value of "Ephemeral number 1".

Explanation

We associate a numerical value to issue "Priority" and to custom field "Impact". These two values may be applied to a mathematical function to calculate another numerical value that will represent the "Urgency" of the issue. In our case we simply have summed both values, but we could have used a much more complex formula. Once we get the result of the sum, we revert the process, associating each possible result of the sum to an options in custom field "Urgency".

Step by step

- 1) Using post-function "Set a field as a function of other fields" we associate a numerical value to each possible value of issue "Priority", and this value is stored in auxiliary field "Ephemeral number 1".

./amazing/calculate-urgency/calculate-urgency-1-5.png


- 2) Using post-function "Set a field as a function of other fields" we associate a numerical value to each possible value of custom field "Impact", and this value is stored in auxiliary field "Ephemeral number 2".

./amazing/calculate-urgency/calculate-urgency-2-5.png


- 3) Using post-function "Mathematical and date-time expression calculator" we store in "Ephemeral number 1" the result of summing "Ephemeral number 1" and "Ephemeral number 2".

./amazing/calculate-urgency/calculate-urgency-3-5.png

Note that:

  • {00058} is code for numeric value of "Ephemeral number 1".
  • {00059} is code for numeric value of "Ephemeral number 2".

- 4) Using post-function "Set a field as a function of other fields" custom field "Urgency" is set depending on the result of the former sum, which is stored in "Ephemeral number 1".

./amazing/calculate-urgency/calculate-urgency-4-5.png



Once configured "Create Issue" transition looks like this:

./amazing/calculate-urgency/calculate-urgency-5-5.png

Other Use Cases

Updated