Webix datatable identifying the similar rows and changing the column values

Hi All,

I have webix datatable contains 1000 rows - some of the rows have similar values in all columns except one column. Lets say

row1,col1 = Mango
row1,col2 = Orange
row1,col3 = Pineapple
row1,col4 = $200

row2,col1 = Mango
row2,col2 = Orange
row2,col3 = Pineapple
row2,col4 = $250

row10,col1 = Mango
row10,col2 = Orange
row10,col3 = Pineapple
row10,col4 = $300

If I change Orange to Apricot from the row1 having col4 value as $200. The value Apricot must reflect in other rows where col4 having $250 and $300. How can we achieve this in webix datatable.

Hello @Jay ,
To achieve such behaviour, please, use the onAfterEditStop event. The event fires after the edit operation is finished. You can set new values during iterating your datatable data. Needed info for that is received within event parameters.
Please, check the example: Code Snippet

.

@pyrus_vagus … thanks a lot for sharing the code … it works as expected and it saved lot of my time (y)