I’m evaluating dhtmlxGrid and I have a few questions.
Is there a way to add IDs (names) to columns so you can “target” them when loading the grid with JSON data? For example, if I have a grid with 10 columns and their ID’s are “col0, col1, col2…col9” it would be nice to be able to load ONLY not null values from the server instead of having to include all of those empty quotes. Also, this would keep you from having to make sure your field orders are the same on the client-side setup and the server-side query.
Also, there is some information related to the row that I would like to reference from the client-side for validation. For example, each column/row combination might have a maximum allowed value. What’s the best way to access to load and access that information? The only way I can see is to either use hidden columns or put extra fields at the end of my JSON data objects to where those values “hang off” the end of the grid. But even then, how to I access that data? Can I reference data attached to a row?