Copying custom field value to another custom field depending on the third custom field value

Nandeesh M S

Hi,

Below is my requirement,

I have below fields

1.SG1 date (date field)

2.SG2 date (date field)

3.SG3 date (date field)

4. Next Gate (drop down with values 1. SG1 related

                                                          2.SG2 related

                                                          3.SG3 related

5.Next Gate Due( date field)

 

Now "Next Gate Due" custom field should automatically copy values from either SG1 date, SG2 date or SG3 date custom fields depending on Next Gate value selected.

Example scenario:

Assume custom fields value are set as below,

SG1 date : 12/8/2015

SG2 date : 12/15/2015

SG3 date : 12/17/2015

Next Gate : SG2 related

Next Gate Due:

 

Now Next Gate Due custom field should display the date depending on the Next gate custom field value. In above scenario it should automatically display 12/15/2015 as SG2 related value is selected in Next Gate custom field.

How can we achieve this. Is there a script,? if yes please share the script to achieve this.

 

Thanks in advance,

Nandeesh

 

Fabio Racobaldo _Catworkx_

Hi Nandeesh,

 

please, add the following code to your behaviour, associated to "Next Gate" field.

FormField nextgateff = getFieldById(getFieldChanged())
FormField sg1 = getFieldByName("SG1 date")
FormField sg2 = getFieldByName("SG2 date")
FormField sg3 = getFieldByName("SG3 date")
FormField nextGateDue = getFieldByName("Next Gate Due")
def nextGateValue = nextgateff.getValue()
if(nextGateValue!=null && !"".equals(nextGateValue)){
    if(nextGateValue.startsWith("SG1")){
        nextGateDue.setFormValue(sg1.getFormValue())
    }
    if(nextGateValue.startsWith("SG2")){
        nextGateDue.setFormValue(sg2.getFormValue())
    }
    if(nextGateValue.startsWith("SG3")){
        nextGateDue.setFormValue(sg3.getFormValue())
    }
}

Hope it helps,

Fabio