I have an app in which a relatively small number of rows of data are stored in one table for “active” cases until they are “finished” (no longer require action). Then they are added to another table with an “add a new row to another table” action and erased from the “active” table. This results in many blank lines in the Google sheet for the active table.
The app is working well but I’m wondering if the build up of blank rows over time is something I should worry about. Should I use some sort of security filter to improve efficiency? Or, does the fact that the rows are blank mean that AppSheet is already ignoring them and I don’t need to worry about them?
By the way, I’m assuming that there’s no way to avoid having lots of blank lines in a case like mine. If I’m wrong about that, please let me know.