New Bug Encountered:Delete of Parent record with IsAPartOf records

[David_Joyce]

Not a major bug/issue for me, but…

If you delete the parent record that has child records connected with IsPartOf property, the child records should be deleted as well. In Google sheets data what actually happens is the spreadsheet rows representing the child records are cleared, not deleted, leaving gaps in the google sheet. This can be seen in the foll. video where Addresses (referenced by AddressID) IsPartOf the Group table

[Steve]

Other than being unsightly, is there a problem with the blank rows?

[David_Joyce]

No, not for me.

[Greg_L]

Hey @David_Joyce. That issue bothered me too, so I fixed it on my end. Hopefully this will help you too.

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(); …