Hello !.
I have seen in my app, that every time that I use an action to delete some row in some table (in google sheets) , the table looks with a blank row (previously with the row deleted).
Why?.
What could I do?
It is unclear WHY Appsheet leaves a blank row upon Delete but it may have something to do with the [_ROWNUMBER] column which depends on row ordering. Removing rows form the sheet itself changes row order number and may impact any expression an App Creator implemented using [_ROWNUMBER].
FYI, this is why I recommend NEVER relying on [_ROWNUMBER].
What can you do? Many App Creators create a script that will remove the blank rows in the sheet at a specified time when users are not using the app or during a predetermined maintenance window.
3 Likes
1 Like