When I delete a record it deletes the data but does not delete the row in the google Sheet and the row is blank.
How to delete blank rows in Google Sheets Tips & Tricks ?
I have an app that uses parent and child records with IsPartOf turned on. When I delete a parent record, it only clears the records in Google Sheets, leaving the sheet with many large gaps over time, which gets unsightly and annoying for my OCD So I write a Google Apps Script that triggers once a week to delete all the blank rows in each table, to clean them up. If you’re interested, here’s the code: function deleteBlankRows() { var SS = SpreadsheetApp.getActiveSpreadsheet(); …
2 Likes