If you click on the "Update Table" button twice, the output table that I would like to see it is: Tony 132 200
The names in "Column 3" will be different depends on the input value from the sidebar. The output table should observe that, and then return all the names with sum of "Column 1" and sum of "Column 2" under that name.
I tried to create a new data frame using the aggregate function on the values$df, but it is not working.
I did this by introducing a new reactive expression representing the aggregated data frame, and used dplyr's group_by and summarise functions to perform the aggregation.
Your code also was storing the numeric columns as character vectors (they were starting out as numeric but getting coerced to characters), so I also changed your observer to use the rbind function and converted the inputs to numeric.
This is really helpful article. I have searching this and with simple example it is explained.
I tried this, for editable tables it will not work. if any cell edited by user then it should be explicitly handled.
Thank You.