Search the Community

My app has a “Settings” Data Page which first lets the user select one or more states from a multiselect list box, and then one or more cities from a multiselect cascading list box showing only cities in the selected state/s. The selected state/s and cities are exported as parameters on exit and used by other Data Pages. When Settings are opened, previously selected states are pre-loaded. The process works perfectly, except that cities cannot be set to preload - presumably because its list box is cascading (and that of course makes sense). My problem is that the app makes continual use of the Settings Data Page in an iterative way to add or delete a single city while maintaining many previously-set cities – so not having the text box pre-loaded is a problem. Any JavaScript or other solution that I can be pointed to would be greatly appreciated. Thank you.

Hi All… Joined today and my first question to the Forum (I'm a novice so please forgive me if I ask dumb things about coding)! My web form contains some search fields and a pivot table, all on one page. For searching I use a submission form with virtual fields to pass parameters to the Pivot table report. Two of my virtual search fields are “Region†(listbox), and “Country†(cascading listbox with “Region†as the Parent), but I need to have ‘multi-select’ for BOTH listboxes. Thanks to this Forum I’ve managed to get multi-select ‘sort of’ working, using JavaScript in the footer: <SCRIPT LANGUAGE="JavaScript"> /* "Note that ‘cbParamVirtual1’ = the ‘Region’ listbox (ie Parent) */ /* " ‘cbParamVirtual2 = the ‘Country’ cascading listbox. */ var fieldName1 = "cbParamVirtual1"; var fieldName2 = "cbParamVirtual2"; var x1=document.getElementsByName(fieldName1); var x2=document.getElementsByName(fieldName2); x1[0].multiple=true; x2[0].multiple=true; </script> The problem: If I select just one region in Parent listbox, I happily get all the countries associated with that region in the cascading listbox. And I can go on to multi-select those countries. Perfect! BUT, if I multi-select, say “N.America†AND “Europeâ€, then my ‘Country’ cascading listbox just states “No options availableâ€. What I want is for it to list all the countries in both , “N.America†+ “Europeâ€. Somehow my multi-selections from the Parent just aren't being recognised. (Needless to say, this all works seamlessly in a tabular report format). I’d very much appreciate any help.