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

How to dynamically set a field based on another field value

Jessica Fergus

I have a custom field called "Project Cost Performance Index" custom ID 12202

The values in this field are numeric and mean:

If CPI is less than 1, the task is over budget.
If CPI is one, the task is on budget.
If CPI is greater than 1, the task is under budget.

I have another custom field called "Project Cost Status" custom ID 12203

But I want it to populate the text status based on if the Project Cost Performance Indicator is less than 1 (Over Budget), is 1 (On Budget) and greater than 1 (Under Budget).

I can do this easily with an export to Excel and conditional formatting but want it all in JIRA.

Anyone help with the script to do this? I want to just add it to the Project Cost Status description field, right?

Accepted answers

Jessica Fergus

I also have this plug-in that I used for the other custom fields that may do the trick: https://apps.decadis.net/display/JWT/Calculated+Text+Field

All comments

Scott Theus

Hi Jessica,

Here is one example: https://community.atlassian.com/t5/Jira-questions/How-to-write-postfunction-to-add-values-in-a-custom-field-based/qaq-p/748887

Does that help?

-Scott

Jessica Fergus

Possibly. I just am not good enough with script to parse out what I need. I don't want to do this post-function as this might change several times during the lifecycle of a task, and not necessarily just at transition.

Here is the thread that is closest to what I am trying to do, but it is pretty old and I am not sure of how to modify the script for my needs:

https://community.atlassian.com/t5/Jira-questions/Jira-set-a-field-based-on-another-field/qaq-p/445559

Jessica Fergus

I want to populate the Project Cost Status field with the text phrase .... "Over Budget", "On Budget", or "Under Budget" based on if the CPI in the Project Cost Performance Index field is less than, equal or greater than 1.

I think this is the script I need to modify for my situation (this one hides or displays a field based on another fields value instead of populating text in the field like I need):

change.onchange=function() {

if (this.value == 'Defect') {
defect.style.display='';
} else {
defect.style.display='none';
}
}

}

----------------Where:
I have a custom field called "Project Cost Performance Index" custom ID 12202 The values in this field are numeric and mean:

If CPI is less than 1, the task is over budget.
If CPI is one, the task is on budget.
If CPI is greater than 1, the task is under budget.

I have another custom field called "Project Cost Status" custom ID 12203 But I want it to populate the text status based on if the Project Cost Performance Indicator is less than 1 (Over Budget), is 1 (On Budget) and greater than 1 (Under Budget).

Jessica Fergus

I also have this plug-in that I used for the other custom fields that may do the trick: https://apps.decadis.net/display/JWT/Calculated+Text+Field

Welcome!

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

Quick Links

Find more posts tagged with

server

jira

jira-server