Hello, I have a column in my table with 30 rows. I want row 4 to sum up rows 1 to 3 (in this column), but I also want rows 1 to 3 to be editable, so that I can see the total change in row 4 when I change a value in rows 1 to 3. So far I can get the whole column editable using editable: true, and I have also been able to set another column to do some math, adding values together in the same row, but this is not what I need right now.
I have created a stored procedure to change the data in row 4 when values change in rows 1 to 3, but this requires the page to be refreshed before the change shows up. Is there a better way of doing this?
If not, how do I get the data table to automatically refresh on change event? This is what I have so far, but it is not working:
, on:{
,onLiveEdit: function () {
this.refresh();
}
}