I'm trying to figure out how to have one drop down menu's options affected by another drop down menu's options.
I cannot remember what options to choose if anything, and need help figuring out what properties I need to change, or how to edit the script.
The basic code is quite simple. Use this as the custom validation script of the first drop-down field:
if (event.value=="1") this.getField("B").setItems(["Red", "Blue"]);
else if (event.value=="2") this.getField("B").setItems(["Green", "Yellow"]);