Fix Serial Number *Delete Gap* in google sheet

[AbdullaNsour]

I am attempting to generate a serial number for my project. During testing, I found that it works well in the AppSheet application; however, in the database, there is a Gap in the data.

Is there a way to remove this Gap upon deletion?

[AleksiAlkio · Accepted solution]

When you delete a record, the app just clears the row. You would need to do that for example with scripting (GAS). 

[AleksiAlkio]

https://www.googlecloudcommunity.com/gc/Tips-Tricks/How-to-delete-blank-rows-in-Google-Sheets/m-p/38...

[AbdullaNsour]

Thank you 

[AleksiAlkio]

You're welcome!