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

Calculate value from 2 listed fields to store in other customfield using Automation

thumuluru.shreya

I have 2 Custom fields Severity(Select List (single choice)) and Probability(Select List(single choice) and these 2 multiply each other need to store in Score(Number Field)Custom field using Automation. Here severity and Probability are 2 dropdown fields.

Severity values:

1-Major

2-Minor

3-Critical

Probability Values:

1-Critical

2-Major

3-Negligible

Expected how to works:

Severity * Probability=Score

2-Minor * 3-Negligible=6

Please help me in this

Accepted answers

Valerie Knapp_dpp5c6

Hi @thumuluru.shreya , thanks for your question.

I'm doing something like this for two of my customers using lookup tables. The benefit of this approach is that you can modify easily the number / weighting associated with each value.

So, you create a lookup table for each custom field and insert the mapping / weighting.

Then, in the action, you need to get the custom field ID's and then should be able to insert this calculation

{{#=}}{{Severity.get(issue.customfield_YOURID)}} * {{Probability.get(issue.customfield_YOURID)}}{{/}}

Please have a go on your instance and share your feedback.

Best wishes

All comments

Marc Koppelaar

Whenever you ask for help with an Automation Rule it will help us to help you if you provide:

1. what type of project is this (e.g., company-managed, team-managed, etc.),

2. images that show your complete rule.

3. images showing the details of the actions/conditions/branches.

4. images showing the Audit Log details for the rule execution.

5. images showing the relevant data in an image that is part of the rule execution.

6. Explain where the issue is.

These questions are not for not willing to help, but to have community members learn on how automation works.

Not just to provide a full solution, which would not help to understand what the automation is doing, but to have members understand what a rule is doing, if in need of change or error.

Kumar_rajarapu

Hi @thumuluru.shreya ,

Create Automation Rule:

Trigger: Field value Updated.( Add fields -Severity, Probability)

Condition: (Optional) Set conditions if necessary

Action: Edit Issue Field (Add field -Score)--choose set value(add below JSON Script)

Smart Value Calculation: Use smart values to calculate the score

Add JSON script

[" {
"fields": {
"Score": "{{#=}}(
(if(issue.Severity == "Major", 1, if(issue.Severity == "Minor", 2, 3))) *
(if(issue.Probability == "Critical", 1, if(issue.Probability == "Major", 2, 3)))
){{/}}"
}
}"]

Example:

2 (Minor) * 3 (Negligible) = 6 (Score)

Regards,

kumar

thumuluru.shreya

@Kumar_rajarapu , Could you please explain or send screenshot from JSON where I need to add this step exactly it will be helpful for me

Kumar_rajarapu

Actually I'm not able take the Screenshot

Action component: choose Edit Issue Field (Add field - Score)

In Action, after selecting the field in 'Edit issue',

click on 'More options' below

In the 'Additional fields' box, add the JSON script.

Kumar_rajarapu

Edit issue Delete component

Set values for fields on the issue. Simply add the fields you want to edit.

More optionS

Send notifications?

This rule should send emails

Additional fields

{
"fields": {
"Score": "{{#=}}(
(if(issue.Severity == "Major", 1, if(issue.Severity == "Minor", 2, 3))) *
(if(issue.Probability == "Critical", 1, if(issue.Probability == "Major", 2, 3)))
){{/}}"
}
}

You may specify additional field values to be set using a JSON object as documented. The fields you specify must be present

Bill Sheboy

Hi @thumuluru.shreya

As @Marc -Devoteam- suggests, context is important for automation rule questions: please post the complete rule, action details, and audit log details to help the community provide suggestions.

Until we see those...

If the values you show are in fact the values of the custom fields, you could use:

text functions to extract the first character of the selected value for the fields: https://support.atlassian.com/cloud-automation/docs/jira-smart-values-text-fields/#left-int-length-
use a math expression to multiply the values: https://support.atlassian.com/cloud-automation/docs/jira-smart-values-math-expressions/

To make this work, you must use the correct smart values (or custom field ID values). To find those, use this how-to article: https://support.atlassian.com/cloud-automation/docs/find-the-smart-value-for-a-field/

Kind regards,
Bill

Valerie Knapp_dpp5c6

Hi @thumuluru.shreya , thanks for your question.

I'm doing something like this for two of my customers using lookup tables. The benefit of this approach is that you can modify easily the number / weighting associated with each value.

So, you create a lookup table for each custom field and insert the mapping / weighting.

Then, in the action, you need to get the custom field ID's and then should be able to insert this calculation

{{#=}}{{Severity.get(issue.customfield_YOURID)}} * {{Probability.get(issue.customfield_YOURID)}}{{/}}

Please have a go on your instance and share your feedback.

Best wishes

thumuluru.shreya

hi @Valerie Knapp , Thanks for helping. After adding these rules to my rule. No action is performing. Could you please help in this?

Thanks

Valerie Knapp_dpp5c6

Hi @thumuluru.shreya , what trigger are you using in the rule? Can you show what you've built? And the audit log?

Cheers

thumuluru.shreya

@Valerie Knapp , Please check I performed an action but there is no results showing on that in audit log.

Screenshot (1036).png Screenshot (1037).png

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud