Delete an item from a table using glide delete leaves blank row

[Darren_Murphy]

Here’s some sample apps script that can be used to clean up empty rows left by Glide.

Minor bug/inconsistency on API

There is, but at the moment it’s only available to Enterprise customers. I use a bit of apps script for this. Here’s an example you could adapt: function remove_empty_rows() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getSheetByName('YOUR SHEET NAME GOES HERE'); var headers = sheet.getRange(1,1,1,sheet.getLastColumn()).getValues().shift(); var concat_index = headers.indexOf('CHANGE THIS'); var uuid_index = headers.indexOf('CHANGE THIS ALSO'); var data = sheet…

Also, unless you absolutely need the computed data in the spreadsheet, I’d encourage you to investigate the option of getting rid of the spreadsheet formulas, and replace them with Glide computed columns.