when I close a window with a power table on it, the data reverts back to the existing data. Is there a way for it to retain the data that is newly entered?
Where does the data come from initially? You can use the onCellEdited extension function of the power table to commit the data after editing.
the data comes from the table. I would I use it to commit the data.
You would have to store the data somewhere. You could set up a bi-directional binding to a dataset memory tag, though there are some caveats (multiple clients would be interacting with the same data, and may overwrite each others changes).
What are you ultimately doing with this data? Answering that question helps make more sane recommendations about what the best option here is.
the data gets inserted to a database once all changes are done and a submit button is pushed