Skip to main content
Inspiring
November 26, 2020
Question

Script format

  • November 26, 2020
  • 3 replies
  • 626 views

I'm trying to create a simple script in which the selectged results in a drop-down menu field causes a specific response in another corresponding field.  The "Property" field is a drop-down menu, and the "AccountingCode" field is where I want the specific result to display.  The below script is what I entered in the AccountingCode field, but doesn't produce any result:

 

var Property = this.getField("Property").value;
if (Property=="property loss/damage") event.value = APC9AA6;
else if (Property=="real property loss/damage") event.value = APC9BB6;
else event.value = "";

 

Also, the Property drop-down field contains a blank entry (ie. 10 spaces using the space bar) to create a blank listing as the first entry on the default drop down listing. The purpose is to have the Property field default to blank to cause the employee to make a selection, rather than accidently tabbing through and using one of the pre-listed listings, which if blank, should reflect a blank in the AccountingCode field as well.

 

Any advice to assist this novice would be greatly appreciated.

This topic has been closed for replies.

3 replies

Nesa Nurani
Community Expert
Community Expert
November 26, 2020

Another  way to do it would be when making options in dropdown field to give "property loss/damage" export value APC9AA6
and "real property loss/damage" export value APC9BB6 and then just use this code in "AccountingCode" field:
event.value = this.getField("Property").value;

Les FiestAuthor
Inspiring
November 28, 2020

Thank you, I'll give this a shot as well.

try67
Community Expert
Community Expert
November 26, 2020

You have to place strings inside of quotes. Otherwise they are treated as variable names.

Bernd Alheit
Community Expert
Community Expert
November 26, 2020

Use this:

var Property = this.getField("Property").value;
if (Property=="property loss/damage") event.value = "APC9AA6";
else if (Property=="real property loss/damage") event.value = "APC9BB6";
else event.value = "";
Les FiestAuthor
Inspiring
November 28, 2020

Thank you, that worked perfect.