jQuery Grid Plugin - jqGrid - Topic: Edit Form - relational select menus

michaelg on Edit Form - relational select menus

Sun, 18 Jul 2010 01:25:29 +0300

Yep I think your right, if the number of OPTIONs is huge, then it would be best to load them via AJAX when needed.

It would be even better if you prevent loading the OPTIONs a second time if they've already been loaded.

Perhaps, it would be easiest to ...

a) Have a seperate SELECT for each of the different types, and hide/unhide the whole select depending on what is selected in the first SELECT

b) When your un-hiding one of these SELECTs, you could check if it has already been loaded,and if not then load it up via AJAX

gyrofly on Edit Form - relational select menus

Fri, 16 Jul 2010 19:02:55 +0300

The challenge with that approach is the sheer number of options. We have literally thousands of potential values for that second SELECT. If we could pull those in ajax in some fashion with an onChange on the first SELECT that would be ideal.

Any ideas how we would do that?

michaelg on Edit Form - relational select menus

Fri, 16 Jul 2010 03:01:38 +0300

If i were trying to solve this problem i would ...

1) populate the second SELECT with all possible values (eg. all hair colours, all shirt sizes, etc.)

2) attach a function call to the onchange event of the first SELECT

3) in this function, i would loop through all OPTION's in the second SELECT, and make them either hidden or visible, depending on the value of the first select

Maybe theres a better way, just an idea 🙂 I hope it helps!

Cheers,

Michael

gyrofly on Edit Form - relational select menus

Fri, 16 Jul 2010 00:51:16 +0300

Inside our Edit Form, we have one field (edittype=select) that must dynamically update options available based on the realtime selection value of another field (edittype=select).

For example if "Hair Color" was selected in the first select menu, the values in the second menu would auto-populate with options of "Brown", "Blond" and "Brunette". If "Fruit" was selected in the first menu, the second menu would re-populate with options "Orange", "Apple", "Pear".

How would we go about this?