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; } } }

Automation to update custom field "Score" based on custom multi-select field "Scoring parameters"

Finn Harsfort_tsyneh

I have a custom field called Score that should always reflect the scoring of the issue based on some scoring parameters which is kept in another field "Scoring parameters" (multi-select custom field). To keep it simple, lets assume only 3 possible vaules for scoring:

- Option A (with a weight of 40%)

- Option B (with a weight of 30%)

- Option C (with a weight of 30%)

If only Option A of the scoring parameters is selected, the Score should be 40.

If Option A+B is selected, the score should be 70 (40+30)

If all options are seleced the score is 100.

How do I setup an automation rule to calculate a new Score value every time the Scoring parameters are changed ?

Accepted answers

Bill Sheboy

Hi @Finn Harsfort

I believe you can do this with a single math statement and the filtering of smart value lists feature:

Inside of your math operation, use your field and filter/check for the specific value and multiply by your weight, summing the results. One tip to help is using a default value of 0 for when a value is absent.

Kind regards,
Bill

All comments

unknown

Hi @Finn Harsfort

One of the easiest way to do this is to create 3 additional number fields and default value is 0. then create an automation that looks for any update to the score parameter field. Have an if else statement that looks for the different values in the field. If score parameter contains X. Then in 'X number field' change value to Y.

Then at the end of the automation - outside of the if else statements. add an action to refetch issue data then add an edit issue action to add all of the number fields back together.

If you need some further help let me know

Dan

Finn Harsfort_tsyneh

Hi @[deleted]

I understand what you mean, but we have much more than 3 scoring parameters, so that would be a lot of custom fields to add, but perhaps the only way...

I have been playing around with:

- initilly set score to 0 when the Scoring parameters changes

- adding an if statement for each scoring parameter value:

(if option A the increment Score with 40, if B then increment with 30 etc..

This wont work since Score value is not "kept" on.

I also tried to use create a Variable but cant find a way to update this variable and then assign it to Score as the last step.

I hope it is possible to do in some way, so I dont have to create all those addition fields, but I can see that would work.

unknown

Hi @Finn Harsfort

Are you refetching issue data in between the if statements. Screenshot the rule and I can try and help see what you have to get it working.

Dan

Finn Harsfort_tsyneh

hi @[deleted],

No I dont refetch issue data but also tried that without succes. But then it wont "remember" the new value for Score assigned in previous steps. I wish there was a way (using a math formula perhaps, to just assign the new value for the "Score" field based on which options are selected in the "Scoring paramters" field.

Here is a snippet of the automation rule:

Screenshot 2022-08-15 145523.png

Screenshot 2022-08-15 145736.png

The last action if for the first options and etc. for the rest

Bill Sheboy

Hi @Finn Harsfort

I believe you can do this with a single math statement and the filtering of smart value lists feature:

Kind regards,
Bill

Finn Harsfort_tsyneh

@Bill Sheboy Thanks Bill, but Im afraid I need a bit more guidance. I assume I just keep the first If condition (Scoring paramter has changed) and then 1 single action to update the score field using a math expression. But the math expression is causing me a headache. How do i iterate the scoring paramters and sum up the values conditionally ? Can you share just a bit of this logic to get me started on right track ?

Bill Sheboy

No problem and glad to help!

For your use case with just a few options, there is a simple way to do this with the match() function. For example:

{{#=}} {{#if(exists(issue.yourCustomFieldNameOrID.match("Option A")))}}40{{/}}
 + {{#if(exists(issue.yourCustomFieldNameOrID.match("Option B")))}}30{{/}}
 + {{#if(exists(issue.yourCustomFieldNameOrID.match("Option C")))}}30{{/}}
 {{/}}

Bill Sheboy

My mistake; that one does not work! I'll experiment with it a bit to see what is not working. Until then, please continue, perhaps using created variables to sum up.