Searching a for a cell value in a column and updating its value

[Buggs2015Participant]

Hello,

I need your help,

Firstly, I am very pleased and impressed so far as to the ease and use of your Widgets.

How do I search for a cell value, knowing the Column name [File Number] and then replace the cell’s value with a new value.

Example:

(if fileno == ‘testabc’) { then

find and search in the grid, under the column name [File Number] for the value ‘testabc’ and replace the cell’s value with the new value ‘testxyz’

}

Much thanks and appreciation for all your help and support.

[HristoParticipant]

Hello Buggs2015,

Where exactly you would like to change that value? Before load data in Grid or after click with button maybe?
You could change some particular value with this properties – setcellvalue or updaterow.
Also another approach it is possible but if you search for some value ‘testabc’ and could repeat in different places and will be replaced there.
Like this way (in “column” property):

{ text: 'Quantity', datafield: 'quantity', width: 70, cellsalign: 'right', columntype: 'numberinput',
      cellsrenderer: function (row, columnfield, value, defaulthtml, columnproperties) {
                if (value < 20) {
                    return '' + value + '';
                }
                else {
                    return '' + value + '';
                }
            }   
}

Best Regards,
Hristo Hristov

jQWidgets team
http://www.jqwidgets.com

[Author]

Posts