ParamQuery grid support forum
General Category => Help for ParamQuery Pro => Topic started by: markn on August 24, 2024, 01:29:31 am
-
I am going to try and explain this as best I can and provide an image that I hope will help explain it as well. In each cell of my grid I have some custom html that actually has two different values in it. If you look at the image you will see 10 /10% in row 5. The second value is always static; it is set when the grid is loaded and cannot be changed by the user. However, the first value can be changed. Using the example above a user could type in 37 and you would see 37/10%. What I need help with is to sum all of those first values and display that total in another cell. In the image example, if I have two values on the same row 10/10% and 17/20%, in one column I would sum the first values (27) and in another column I would have the second value sum (30).
-
Let's simplify it.
If the 1st value ( numerator ) is variable and 2nd value ( denominator ) is fixed, then you can keep numerator in the data and display denominator in column.render callback.
column.render = function(ui){
return ui.cellData + "/10%";
}
This way only numerator would be shown in the editor when cell is edited.
And to compute values in a column depending upon corresponding values in other columns of same row, please use any of the following examples to set up column dependency.
https://paramquery.com/pro/demos/grid_formula
https://paramquery.com/pro/demos/rowtemplate