Delete thousands of records at once

[ranorga]

Dear Community:

I will appreciate your help with the following query. I need to delete from AppSheet all the rows of a table. Now I can only delete rows one by one with the delete action, but I have tables with hundreds of records so it would help to have an action that deletes all records at once. Thank you in advance for your help.

Rafael

[AleksiAlkio]

Please check the reply in your another post, but I definitely do it with a webhook as I believe you have at least Core subscription.

[ranorga]

Thanks Aleksi!

[JSO]

Try doing it directly with a GoogleScript function call. An example function for this could be:

function clearAllRecords(sheet, table) {
    var sheet = SpreadsheetApp.getActive().getSheetByName(sheet);
    var range = sheet.getRange(table);
    for (var i = 0; i < range.getMaxRows(); i++) {
      range. deleteRow(i);
    }
}

In sheet you must put the name of the sheet with its complete path and in Table the name of the same.

clearAllRecords("MyFolder/MyFolder1/MiFolder2/MySheet", "MyTable");

Although it seems that it is the same as deleting from ApPSheet, this is only a call to the Google Server and it is in charge of executing it.
Then you will have to make sure that the data is synchronized in AppSheet.

[ranorga]

Thanks a lot @JSO ! I will try to follow your idea.