Update all rows inside one column

[Fraser]

Hi, I would like to update all rows inside one column. Each column would have its own input which will update the rest of the rows. Currently I have an existing edit batch table. I was wondeing if it was possible to:

1. select a column (maybe with checkbox)

2. Row 1 is empty, however will trigger a function

3. This function takes the input value (which the user will type) of row 1 cell and populate this value for every row inside the that column.

COL 1 || COL 2

---------------

row 1 || row 1

---------------

row Z || row Z

After this the user should still be able to activate the cancel button and the original data appears back in the table. The table data should not be saved unless the saved button is pressed.

I've tried a fucntion using a button where we would execute row.set(column, value), however this would refresh the grid table and the original data would reappear.

[Georgi Denchev]

Hello, Fraser,

Thank you for the provided details.

You are on the right track with the set() method. You can utilize it alongside the save event of the Grid which is fired once you change the value of a cell and close it.

I have prepared a Dojo example which you can examine:

https://dojo.telerik.com/@gdenchev/uXUJepAc

Changing the value of one of the Product Names will also update all of the other rows in that column. You'd still be able to cancel that change through the "Cancel" button.

Let me know if you have any questions.

Best Regards,
Georgi Denchev
Progress Telerik