Custom Fields- is there a way to build a field that changes the due date..

Jerrod Van

Custom Fields- is there a way to build a field that changes the due date..

 

For example. 

we have a invoice date field

we have a invoice due date field

- want to put invoice date and then a possible drop down that you can select, 15, 30 ,60 and it auto populates the due date field. 

 

Nic Brough -Adaptavist-

Hi Jerrod,

If you have one of the scripting or automation apps, then yes.  There are different ways to do it, depending on when you want to trigger the change, and which app you're using, but if you have a recent version of Scriptrunner with HAPI, then the below will do it

Note that:

• This script is written for the SR console.  You won't need the issuekey or issue= lines in post functions, and if it's a listener, you can use "def issue = event.issue"
• It assumes the options in the payment terms list really are named as numbers that toInteger can translate from text into a number.
• I did this with SR and HAPI partly because I'm an Adaptavist and it's my job to encourage people to use SR, but mostly because HAPI is easier to read as pseudocode if you wanted to use something else.

import java.time.LocalDate
import java.time.format.DateTimeFormatter

def issueKey = "ISSUE-KEY" // Replace with the actual issue key
def invoiceDateField = "Invoice Date" 
def paymentTermsField = "Payment Terms" 
def invoiceDueDateField = "Invoice Due Date" 

def issue = Issues.getByKey(issueKey)
def invoiceDateValue = issue.getCustomFieldValue(invoiceDateField)
def paymentTermsValue = issue.getCustomFieldValue(paymentTermsField)?.value 

def invoiceDate = LocalDate.parse(invoiceDateValue, DateTimeFormatter.ofPattern("yyyy-MM-dd"))

def daysToAdd = paymentTermsValue.toInteger()

def invoiceDueDate = invoiceDate.plusDays(daysToAdd)

issue.update {
setCustomFieldValue(invoiceDueDateField, invoiceDueDate.format(DateTimeFormatter.ofPattern("yyyy-MM-dd")))
}