Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

BLANK ROW after delete row

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?

0 2 217
2 REPLIES 2

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. 


@WillowMobileSys wrote:

at a specified time when users are not using the app or during a predetermined maintenance window. 


👏👏💯

Top Labels in this Space