Hey @cz0840! I'll summarize some of the points I've made elsewhere, as I think this is a common point of confusion among users that are relatively new to the platform.
The key to understanding Retool tables is realizing that they actually aren't that similar to spreadsheets. Instead, they are a visual representation of data - typically a backing database but almost always the return value of some query.
As such, the most reliable way to update the contents of a table is to instead update the backing data source!
This typically means making a request to the database, as I demoed here. Let me know if you have any questions about implementing this!