I am having difficulty with some setItems statements.
Virtually, everything depends on the selections for the semester hours (“FallHrs”,” SpringHrs”,” SummerHrs”).
The “Semesters1,2,3” dropdowns populate semester names based on the (“FallHrs”,” SpringHrs”,” SummerHrs”) dropdown boxes, set as Custom Calculation Scripts.
The “GLS1,2,3Amount” dropdowns populate the dollar amounts based on the “Semesters1,2,3” dropdown boxes, set as Custom Calculation Scripts.
My problem is that, as a Custom Calculation Script, everything populates just fine EXCEPT that when you click on any of the “Semesters1,2,3” selections (and the “GLS1,2,3Amount” selections), the visibly-defaulted option overrides the clicked selection and effectively resets where nothing propagates thereafter.
I notice that if I run the (“FallHrs”,” SpringHrs”,” SummerHrs”) scripts as a Custom VALIDATION script, then the “Semesters” options work good where the selected option does not get reset back to default.
However, doing the VALIDATION routine cause havoc with the semester HOURS dropdowns and nothing seems to work real-time, regardless that the Field calculation order is properly setup.
I am attaching a sample file and hope that someone can educate me on where I am blundering. Thanks in advance!