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

Using Scriptrunner for Jira to calculate a date custom field based on another date custom field

Gordon Rutherford

We have a custom field date (Deadline) that is populated by a user and another custom field date (Sample Delivery Date) that we would we like Scriptrunner to auto populate with a 2 weeks (14 days) 'before' Deadline date value.

For example: I add 15/07/21 as my 'Deadline' date and SR auto populates/calculates value of 'Sample Delivery Date' as1/07/21.

I would like this relationship to be dynamic - the Deadline date could be added on Issue creation or changed later and the Sample Delivery Date should update automatically.

I am a newbie with SR runner but imagine this would be done as a behavior.

Any help very much appreciated!

Thanks

Gordon

Accepted answers

Ram Kumar Aravindakshan _Adaptavist_

Hi @Gordon Rutherford

For your requirement, the best approach will be to use the Scripted Field.

In your scenario, the Sample Delivery Date will be the Scripted Field.

Below a working sample code for your reference:-

import com.atlassian.jira.component.ComponentAccessor
import java.text.SimpleDateFormat

def customFieldManager = ComponentAccessor.customFieldManager
def deadline = customFieldManager.getCustomFieldObjectsByName("Deadline")[0]

def sdf = new SimpleDateFormat("yyyy-MM-dd")
def deadlineValue = sdf.parse(issue.getCustomFieldValue(deadline).toString())

deadlineValue + 14

Below is a print screen of an example Scripted Field configuration for your reference.

If you view the print screen above, the field name given is Sample Delivery Date. And, the script takes the value from the Deadline field and adds 14 days to it.

Please note that the scripted field will only be visible once the issue has been created, i.e. you will not see the update on the Create screen or the Edit screen.

Below are a few test print screens.

1) When the ticket is being created, a date is entered into the Deadline field. In the print screen below, the date selected is 15th July 2021.

2) Once the ticket is created, the Sample Delivery Date field is visible with the date value of 29th/Jul/21, i.e. 14 days after the Deadline.

3) If the Deadline is updated, the Sample Delivery Date field is updated automatically, as shown in the images below:-

I hope this helps to solve your question.

Thank you and Kind Regards,

Ram

All comments

Ram Kumar Aravindakshan _Adaptavist_

Hi @Gordon Rutherford

For your requirement, the best approach will be to use the Scripted Field.

In your scenario, the Sample Delivery Date will be the Scripted Field.

Below a working sample code for your reference:-

import com.atlassian.jira.component.ComponentAccessor
import java.text.SimpleDateFormat

def customFieldManager = ComponentAccessor.customFieldManager
def deadline = customFieldManager.getCustomFieldObjectsByName("Deadline")[0]

def sdf = new SimpleDateFormat("yyyy-MM-dd")
def deadlineValue = sdf.parse(issue.getCustomFieldValue(deadline).toString())

deadlineValue + 14

Below is a print screen of an example Scripted Field configuration for your reference.

If you view the print screen above, the field name given is Sample Delivery Date. And, the script takes the value from the Deadline field and adds 14 days to it.

Please note that the scripted field will only be visible once the issue has been created, i.e. you will not see the update on the Create screen or the Edit screen.

Below are a few test print screens.

1) When the ticket is being created, a date is entered into the Deadline field. In the print screen below, the date selected is 15th July 2021.

2) Once the ticket is created, the Sample Delivery Date field is visible with the date value of 29th/Jul/21, i.e. 14 days after the Deadline.

3) If the Deadline is updated, the Sample Delivery Date field is updated automatically, as shown in the images below:-

I hope this helps to solve your question.

Thank you and Kind Regards,

Ram

Gordon Rutherford

@Ram Kumar Aravindakshan _Adaptavist_

Brilliant! Works perfectly as expected thank you!

Sorry to complicate it further but......

I have shown it to the team who requested the feature and in typical fashion they added a further request - could you have a condition added to this essentially based on a selection from a Radio Button custom field as described below.

We have 4 additional radio buttons on this issue create screen.

Button A

Button B

Button C

Button D

If the user choose Button A or Button B the sample delivery date - 14 days from deadline

If the user chooses Buton C or Button D the sample delivery date - 7 day from Deadline

Thanks again for your input - really appreciate it Ram

Best regards

Gordon

Ram Kumar Aravindakshan _Adaptavist_

Hi @Gordon Rutherford

To answer your question, it is very much doable.

You will need to modify the code slightly. Below is a sample code for your reference:-

import com.atlassian.jira.component.ComponentAccessor
import java.text.SimpleDateFormat

def customFieldManager = ComponentAccessor.customFieldManager
def deadline = customFieldManager.getCustomFieldObjectsByName("Deadline")[0]

def sampleRadioButton = customFieldManager.getCustomFieldObjectsByName("Sample Radio Button")[0]
def sampleRadioButtonValue = issue.getCustomFieldValue(sampleRadioButton).value.toString()

def sdf = new SimpleDateFormat("yyyy-MM-dd")
def deadlineValue = sdf.parse(issue.getCustomFieldValue(deadline).toString())

if(sampleRadioButtonValue == "Option1") {
    deadlineValue + 14
} else if(sampleRadioButtonValue == "Option2") {
    deadlineValue + 21
} else if(sampleRadioButtonValue == "Option3") {
    deadlineValue + 28
}

Please note, this sample code is not 100% exact to your environment. Hence, you will need to modify it accordingly.

Below are some test print screens for your reference:-

First, when I create the ticket, I select Option1.

When the ticket is created, it sets an additional 14 days to the Sample Delivery Date field as shown below.

Next, once the radio button option is updated to Option2, the Sample Delivery Date field is also updated, i.e. this time from 14 days to 21 days as shown in the image below:-

I hope this helps to answer your question.

Thank you and Kind Regards,

Ram

Gordon Rutherford

Hi Ram

Fantastic - thankyou again! I have had it working with my code shown below in the snip. However why does it show problem on line 8? Can it be ignored?

Best regards

Gordon

Line 8 error.PNG

Alex_2nfdtf

@Ram Kumar Aravindakshan _Adaptavist_
Hello! Please help https://community.atlassian.com/t5/Jira-Service-Management/how-Add-to-my-cf-calendar-14-days/qaq-p/2111753

Welcome!

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

Quick Links

Find more posts tagged with

scriptrunner

jira-software

jira-software-server

atl-gruland

data-center