Skip to main content
kkotvas26
Participating Frequently
June 30, 2016
Question

Dropdown Box Selection initiates "Material Code" to appear

  • June 30, 2016
  • 1 reply
  • 558 views

Hey Everyone,

I am in the beginning stages of revamping tan editable work order form for my company.  For the time being I have created a few "mock" drop down boxes.  The idea here would be to select a one of the material types from the drop down box and have our corresponding material/item number appear in the "CODE" column section in the lower left portion of the form.

How would you go about doing something like this?  I have searched and searched the web and not come up with what I need.  Any help would be greatly appreciated!

I don't know if using the drop down boxes makes creating this form any more difficult or not.  I am open to utilizing the various check boxes on the form as well.

Basically my companies material/item numbers "codes" would need to be running behind the scenes.  We only have about 20 of them.  This is totally doable right?

This topic has been closed for replies.

1 reply

try67
Community Expert
June 30, 2016

When you add an option to a drop-down field you'll notice that there are two values, the Item value and the Export Value.

The former is the display value, what the user sees. The latter is the actual value of the field when that selection is made.

So if you put the material type as the display value and the material code as the export value it will be easy to copy it over to the "Material Code" field. All you'll have to do in that case is use this code as that field's custom calculation script:

event.value = this.getField("Material Type").valueAsString;

kkotvas26
kkotvas26Author
Participating Frequently
July 1, 2016

How would I make the Export Value appear in the "Materiel Code" field?  I entered the script into the Run custom validation script field but I'm not certain what to do next.   Does the part inside the quotation marks need to have the same name as the item that I select from the dropdown box?

For example I need "VIN250" to show up in the "CODERow1" box if the word "Banner" is selected from the drop down box.