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 and update own field based on another custom field.

Ashok Barik

I am new to script runner, please help me on below requirement.

I have two fields, Field1 (worked hours) and Field2 (total hours). Field2 is noneditable and I want to display the calculation result on it.

If I create an issue without specifying the number in the field1, then field2 will have the value "0"

After I update the hours' value in field1, the value of field2 should be "the current value of field2" + "the changed value of field1". It should work both in addition and subtraction (if I enter a negative value in the field1).

The result should be like this;

Field2 = Field2 (previous value) + Field1

Accepted answers

All comments

Craig Nodwell_7eve9b

Scriptrunner has great documentation and recipe examples.
Scriptrunner docs Scripted Fields

What you might find even more helpful is the library.
Scriptrunner Library

There's actually a great example that should get you started in the library here:
calculate-custom-field-on-issue-update

Hope this helps.

Ashok Barik

Hi @Craig Nodwell

Thank you for providing all the details.

Here is my script, but it gives some random value in field2 (worked total hours). Could you please check it and modify it if I have missed something.

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.search.SearchProvider
import com.atlassian.jira.web.bean.PagerFilter
import com.atlassian.jira.issue.IssueManager;
import com.atlassian.jira.issue.Issue
import com.atlassian.jira.issue.link.IssueLinkManager
import com.atlassian.jira.user.ApplicationUser

def issueManager = ComponentAccessor.getIssueManager()
def linkManager = ComponentAccessor.getIssueLinkManager()
def cfm = ComponentAccessor.getCustomFieldManager()

Issue issueKey = issue
def id=issueKey.getId()

def customFieldManager = ComponentAccessor.getCustomFieldManager();

def cf = customFieldManager.getCustomFieldObject("customfield_18849")
def cff = customFieldManager.getCustomFieldObject("customfield_18844")

def n = Integer.parseInt((issue.getCustomFieldValue(cf) ?: 0).toString().replaceAll(~/[.].*/, ""))
def b = Integer.parseInt((issue.getCustomFieldValue(cff) ?: 0).toString().replaceAll(~/[.].*/, ""))

Integer sum = (n ?: 0) + (b ?: 0);

Craig Nodwell_7eve9b

So, that's the code for calculating 2 custom fields and populating that value into a 3rd field(a scripted field, this is the code for that scripted field).

Where are you using this code?

Ashok Barik

Hi,

I am using this code in the scripted custom field2 (customfield_18849) and populating the calculation value in this field2 only.

field1 is editable but field2 is noneditable.

I need the calculated value of field1 and field2 to be populated in field2.

Welcome!

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

Quick Links

Find more posts tagged with

server

scriptrunner

jira

jira-server