jQuery Grid Plugin - jqGrid

I'm having a similar issue, and would like to solve it using formatter.  Let's say I have 4 columns, addr, city, state, zip.  I want to display an address block in the custom formatter that looks like addr<br />city, state zip.  I create a column called address_block and set the formatter to format_address_block

My custom format function declaration is

format_address_block = function(el, cellval, opts){...

in theory, opts returns rowData, but this is not the raw data that I'd like to see from the json data that's sent to populate the table, but rather the tr element and all the formatting.  So from here, I don't know how to fill the cell based on data from other cells in the same row.

Is it possible to also pass the actual data from the row to my custom formatter?Then it would be relatively easy to solve.  Maybe a 3.5 addition?

I realize there are other solutions -- formatting the data in the json requst (not really a good plan), or using setCell in afterRowInsert, but both of these add complications that I'd rather have formatter deal with.

A related question: once I have this address block, I'll obviously want to hide the individual fields during the grid display, and show the address block, but the reverse will be true when I edit.  That doesn't seem to be working, if I have in the colModel "hidden":true and also "editable":true, the field still doesn't show up in the edit.

Thanks!  I've been staring at this now for a while, I'd love some pointers toward a solution.

Tac

Yes, that would be terrific.  Even better would be named pairs, e.g. 

[

{"id":5, cell:{first:"Fred", last:"Flintstone", city:"Bedrock"} },

]

I know the data can be passed in that way, but I usually pass it in as an array, because the data is so much smaller that way.  Or if you could show how to get the id from a name, I know there's a method that gets the column index from a name, but I couldn't figure out how to call it from within the formatter.

At the moment, we've rewritten things to use afterRowInsert, but I think that's more complicated.  A colleague and I spent most of the day working on this yesterday, he found a issue related to this:

--

I discovered why the rowdata argument is always empty for afterInsertRow.  There's a variable rd in grid.base.js that's initialized to [] and then later it tries to put data into it like this:

rd[ts.p.colModel[j+gi+si].name] = cur[j];

That is, it's initialized as an empty array and then treated as an object (with name rather than numeric indexes).  Apparently in that situation JavaScript [appears to ignores the assignment, and rd acts an empty array].

It should be initialized to {}, an empty object, in which case everything works fine.  I should be able to simplify that afterInsertRow code now.

FOLLOW-UP:

Hmm, actually it looks like the data does go in, but it doesn't show up when iterating through the array.  You have to know what the keys are and specifically ask for the elements.  So the data isn't lost, just hard to find.

The bottom line remains to be careful not to use non-numeric keys in a JS array.  They don't get magically converted to numbers, but the resulting array doesn't act quite like an object/hash either.

---

Tac

Thanks, where is the link to download that?  

You have this awesome jQuery plugin, but sometimes I get lost trying to find important things (demos, documentation, alpha download, this forum, etc.)  Would you consider getting jqgrid.org and posting links to everything from there?  Ev

Thanks for integrating that, can't wait to try it.  How would you describe the stability for the 3.5 alpha 2 -- is it new functionality mostly that needs to be tested, or were there changes that affect the current API?

Thanks again, Tony.  We're moving our internal database maintence system to jQuery, and your grid is at the core our UI now, so we're grateful for making this tool available.

Tac