Guriddo » Topic: jqGrid dynamic select option

jqGrid dynamic select option

Guriddo
jqGrid dynamic select option

This topic has 11 replies, 3 voices, and was last updated 16 years, 7 months ago by Jo.

Creator

Topic
August 18, 2009 at 6:34 pm #73960

Jo
Participant

Hi,

I'm creating a jqgrid with drop down columns and I'm using cell editing. I need the options of the drop down columns to change dynamically and I've tried implementing this by setting the column to be:

{ name: “AccountLookup”, index: “AccountLookup”, width: 90, editable: true, resizable: true, edittype: “select”, formatter: “select” },

and then in the beforeCellEdit event I have:

beforeEditCell: function(id, name, val, iRow, iCol) {
Creator

Topic

Viewing 11 replies - 1 through 11 (of 11 total)

Author

Replies
August 19, 2009 at 6:33 am #88350

tony
Keymaster

Hello,

Use formatCell event and not beforeEditCell –

the beforeEditCell is called after we create the element (i.e we use the colmodel), but formatCell will do the job, since it is called before creation of the element.

Regards

Tony.

August 19, 2009 at 7:02 pm #88375

Jo
Participant

Tony,

I've tried using the formatCell event and I get the same result. Perhaps this can't be accomplished using setColProp?

If not how else can I redraw the select options for the cell?

Regards,

Jo

August 21, 2009 at 3:26 am #88414

tony
Keymaster

Hello,

It should work. Check your code.

Regards

Tony

August 23, 2009 at 10:36 pm #88451

Jo
Participant

Tony,

I'm using version 3.5 and here's the code I have:

August 31, 2009 at 4:14 am #88537

tony
Keymaster

Hello,

Thanks. Fixed in GitHub and your example works in my demo.

Best Regards

Tony

August 31, 2009 at 8:03 pm #88598

Jo
Participant

Great – thanks Tony!

Can you please give an indication as to when a new build of 3.5

September 2, 2009 at 6:28 pm #88647

admin
Keymaster

Hi Guys, I pulled the latest GitHub today, and created a jqGrid thus:

September 4, 2009 at 4:55 am #88710

tony
Keymaster

Hello,

You forgot cellEdit:true

Regards

Tony

September 8, 2009 at 6:12 pm #88847

Jo
Participant

Tony,

I've got the select options loading correctly now when editing, however

September 10, 2009 at 4:04 am #88891

tony
Keymaster

Hello,

Could you please set so that formatCell return the value – i.e

formatCell : function(rowid, cellname, value, iRow, iCol)

{

// do something here

return value;

}

Regards

Tony

September 11, 2009 at 8:05 pm #88964

Jo
Participant

Tony,

I've done that – that cleans up the editing, however when the grid first loads I still get undefined values for all cells in that column, as the formatCell is not being hit until I edit the cell and hence the dropdown values are empty.

So I need to somehow populate the cells initially (on load or just after) with one value – just the one they have currently selected, in order for the initial value to be displayed.

Where should I be doing that?

Thanks,

Jo
Author

Replies