I have been trying to set up my table to use the built in add row function and also make the cells editable. So I have a query set up in the table Add-Ons, under Save Action as in the screenshot below.
I have added the Add Row button to the table toolbar.
Under Save Actions, I have the query for editing cells set up like this:
And I have the query for adding a row set up like this:
When I tested the Add Row function, absolutely nothing happened. No record got inserted. The little blue triangles in the corners of the cell did not even disappear. I tested editing cells and that did not work either.
Another option would be to follow along with the example in our docs to build a form component that is built from the table's schema, has input fields for each column and will post the new data to your database on submit, and then trigger a refresh for the table's 'get data' query to show the newly added row!
You also should need to use the "Only run when" input fields. There won't be any way for the save option to appear unless a row/cell has been edited anyway, that feature is primarily useful for when a separate condition outside of the table must be met to then allow for save queries to run.
I don't anticipate you having any issues with those fields not populated. As with new rows also only being possible once the 'add row' has been clicked.
