Skip to main content
smanne1888
smanne1888
Participating Frequently
October 24, 2018
Question

Custom Calculation to populate field with abbreviation

  • October 24, 2018
  • 1 reply
  • 678 views

Hi Everyone,

I have a form that creates a project name based off of selected values in a series of dropdowns.

For example,

Dropdown 1 has the values Maryland, Virginia, Pennsylvania and Deleware

Dropdown 2 has the values Architecture, Engineering, Construction Management

Dropdown 3 has the values New Build, Modification, Demolition

when selected, the selections form a project name, ex. Maryland - Construction Management - New Build in read only fields.

Because of the way I wrote the validation, the values in Dropdown 2 and 3 are dependent on the selected value in Dropdown 1.

What I am trying to do is create the project name with an abbreviation of the selection from the dropdown. So when you select "Construction Management", it populates "CM" and when you select "Demolition" it populates "DEMO", etc. I am not able to adjust the export value in the Options tab since the selections are completely based off of a switch validation script I have built into the State dropdown.

I am using the below custom calculation to pull the data from the dropdowns into the project name

event.value = this.getField("Dropdown2").valueAsString;

How can I add a formula that pulls the data from the dropdown (ex. Construction Management) but outputs it as "CM"?

Thank you in advance, I am a newbie to this.

This topic has been closed for replies.

1 reply

BarlaeDC
BarlaeDC
Community Expert
October 24, 2018

Hi,

It would be easier to change the drop down lists to output the preferred string so we don't have to change it, but if that is not possible then

You should be able to wrap your code in a simple if statement, you would need one for each possible entry.

var tempString = this.getField("DropDown2").valueAsString;

// if you have a lot of values it might be easier to use a switch statement, respond to this post if that would be useful.

if ( tempString == "Construction Management")

{

    tempString = "CM";

} else if ( tempString == "Another Value");

{

     tempString = "AV";

}

then you can use tempString wherever you where going to use the original value of the string.

Hope this helps

Malcolm

smanne1888
smanne1888Author
Participating Frequently
October 25, 2018

Malcolm,

I do have a lot of variables. I used a few of them in the example, but there are many more. Can you assist with a switch statement?

Thank you so much.

BarlaeDC
BarlaeDC
Community Expert
November 27, 2018

Hi,

the switch statement would look something like  (using the above examples)

switch ( tempString)

{

     case "Construction Management":

          tempString="CM";

          break;

     case "Another Value":

          tempString="AV";

          break;

     default:

          // always include this to cope if the value is not as expected.

          break;

}

Regards

Malcolm

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices