Is there any way to create a relationship between field values to determine another field's value?

This may be a bit complex to explain and I have a strong feeling 3rd party tools would need to be utilized to accomplish this, but I am trying to identify a way that we can use custom fields within transitions to generate what I will call a 'risk score' for a change in our system.

As the need for classification of changes increases, we want to essentially create a set of yes/no fields that based on how they are answered would generate a high/med/low risk score for the associated request so that we can affect how the workflow is transitioned through from a change management perspective.

Has anyone attempted this or been able to find a way to essentially automate the calculation of risk related to a change request in their system? We are trying to limit the amount or at least the type of human input necessary when it comes to classifying the risk posed by changes to applications and systems.

2 answers

Hi @Francesco C,

You can create relationships between field values to determine another field's value using the Power Scripts add-on.

We made a video tutorial walking you through in detail here, and we've also posted a short, sample script you can copy and paste or forward to your engineer.

Hope this helps!

Johnson

1 vote

I've done this many times.  Initially with code providing calculated fields, but later with ScriptRunner (which saved me having to bundle stuff into add-ons).  These all looked at the data the users were entering and built risk scores (and other fields) directly from it.

There are some risk calculation add-ons which might be worth a look too, but if you've got unusual or complex rules for calculating risk, they might not work for you.

I'd be interested in discussing further how you accomplished this as it sounds exactly like what I am looking to do.

I tend to use a mix of post-functions (for when I want to update fields) and scripted fields (for display only calculated data)

Get started at https://scriptrunner.adaptavist.com/4.3.1/jira/recipes/workflow/postfunctions.html and https://scriptrunner.adaptavist.com/4.3.1/jira/recipes/scriptfields.html

Suggest an answer

Log in or Sign up to answer
Community showcase
Asked Dec 06, 2018 in Jira Service Desk

Looking for teams who switched from email to Jira Service Desk

The Jira Service Desk marketing team is working on a guide to help new Atlassian customers switch from email to JSD and we'd love to hear from you! Please share: - What made you realize that i...

251 views 1 6
View question

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you