scripting OR conditional formatting for dropdown fields
Ok I want to set up a number of fields, that are drop-downs and I want to have a script or condition attached to them in order to limit errors.
For Example: 1st Text Field is like something titled Fruit
and the drop down options for Fruit are, "Apple, Orange, Pear"
Then the 2nd Text field with a drop down is Type
Now what I want is depending on the result of the 1st drop down (Fruit) will change the options for the second Type, for example:
If Apple was selected in 1st drop down, then the following would be options for the Type drop down, "Red Delicious, Granny Smith, Macintosh"
but if Orange was selected then the second drop down would ONLY show the options specific to that selection: "Mandarin, Californian, etc"
Please let me know how do customize this, Thank you!