I have a table that the user is able to edit some of the columns. Currently after editing each cell I have a script on the cell edited event that writes the change back to the database. I am being asked to change that so that they can edit multiple cells and then press a “save” button before it is written. Can anybody point me in the right direction on how to accomplish this?
Create a dataset for the changes and change your on cell edited script to write to that dataset. Include the id and new value. Then on button press, loop through the dataset and do your updates.