jQuery Grid Plugin - jqGrid - Topic: Dynamically Populate Select Dropdown http://www.trirand.com/blog/?page_id=393/help/dynamically-populate-select-dropdown-1 Simple:Press Version 5.7.5.3 tony on Dynamically Populate Select Dropdown http://www.trirand.com/blog/?page_id=393/help/dynamically-populate-select-dropdown-1#p19706 Help http://www.trirand.com/blog/?page_id=393/help/dynamically-populate-select-dropdown-1#p19706 Hello,

Yes this is true.

Use beforeShowForm – get the value from the first select and based on this value do a ajax and fill the second select.

We have a example in our commertial PHP component here.

http://www.trirand.com/blog/ph.....efault.php

Click on PHP Tab to see the beforeShowForm code.

Regards

Tony

]]> Sat, 11 Sep 2010 14:25:27 +0300 donnazhen on Dynamically Populate Select Dropdown http://www.trirand.com/blog/?page_id=393/help/dynamically-populate-select-dropdown-1#p19676 Help http://www.trirand.com/blog/?page_id=393/help/dynamically-populate-select-dropdown-1#p19676 Thank you Tony for replying for quickly first. But I think you're mistaken of my question. I do read the your suggested post several times before I posted this topic. Your example only works perfect in the adding records mode. The onchanged will be triggered also in the editing mode. But for the editing mode, the 2nd dropdown(State) should retrieve data first according to the 1st dropdown(Country) initiailly. My question is how to get the value of 1st dropdown(Country) to make the 2nd dropdown load correct data first.  And another question is because the form navigation is available, when user navigate dirrerent rows, the 2nd dropdown(State) should load data again according to the value of 1st dropdown(Country). How can I make it work? Hope you can understand my question. Thank you.

Image Enlarger

]]> Fri, 10 Sep 2010 23:13:10 +0300 tony on Dynamically Populate Select Dropdown http://www.trirand.com/blog/?page_id=393/help/dynamically-populate-select-dropdown-1#p19666 Help http://www.trirand.com/blog/?page_id=393/help/dynamically-populate-select-dropdown-1#p19666 Hello,

Please look here:

http://www.trirand.com/blog/?p.....38;ret=all

Regards

Tony

]]> Fri, 10 Sep 2010 19:19:07 +0300 donnazhen on Dynamically Populate Select Dropdown http://www.trirand.com/blog/?page_id=393/help/dynamically-populate-select-dropdown-1#p19658 Help http://www.trirand.com/blog/?page_id=393/help/dynamically-populate-select-dropdown-1#p19658 I saw the Dynamically Populate Select Dropdown topic in this forum and my project is working fine when adding a new record in form editing, there's no problem. I'm wondering how can I get the value of first dropdown to pass as parameter(initialid) in the dataUrl of second dropdown box when editing rocords?

 colModel:[

...

{name:'select_one',

editable: true,

edittype:"select",

editoptions: {

dataUrl:'test_one.php',

dataEvents :[

{ type: 'change', fn: function(e) {

var thisval = $(e.target).val();

$.get('test_two.php?myid='+thisval, function(data)

{ var res = $(data).html();

$("#select_two").html(res);

}); // end get

}//end func

} // end type

] // dataevents

} // edit option

},
{name:'select_two',editable: true,edittype:"select", editoptions:{dataUrl:'test_two.php?myid=initialid'}}       

…
],

Thank you in advanced.

]]> Fri, 10 Sep 2010 15:49:37 +0300