I have a form with two dropdown fields, DF1 and DF2. The dropdown choices in DF2

michaelb40 over 9 years ago

I have a form with two dropdown fields, DF1 and DF2. The dropdown choices in DF2 are dependent on the choice made in the dropdown DF1 field. The fields are editable and retain the intial selections if the form is returned for editing. On a return for editing, I need for the DF2 field to "reset" or dynamically "adapt" IF a change is made to DF1, thereby allowing a change to DF2, otherwise a “Choices not available in array” error message pops up. On the form you can manually avoid the error message by first changing DF2 to the placeholder value “Please choose from the following”, then changing DF1, but a user would not know that. Any ideas?...

Discussion posts and replies are publicly visible

0 michaelb40 over 9 years ago

Also, I am using v7.6, SAIL Interface, and the values selected in the two dropdown fields are saved to a CDT.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Josh
Certified Lead Developer
over 9 years ago

You can define something like a!save(local!df2value, null()) in df1's saveInto parameter to reset the value of df2 to null when df1 is changed.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 leslies331 over 9 years ago

I assume you are using some code in your on DF1 saveInto to populate the choice values of DF2. Use the same method to populate a local variable in the "load" which is executed upon entry into the form.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 leslies331 over 9 years ago

If the values are saved to a CDT, use a query expression to populate the choice values on the load.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 michaelb40 over 9 years ago

Josh, your suggestion worked like a charm, thanks!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel