Deleting datas saved on google sheets

[teamzaddysn9m]

Hi, may I ask how am i able to delete records from the button clicked on thunkable when I would want the datas saved on my google sheets to be deleted? Thank you

[muneer]

use this block

[teamzaddysn9m]

I would like to delete all 30 rows saved data am I able to do so?

[tatiang]

Data Sources

[teamzaddysn9m]

I would like to delete all the data at once. However, for the block “delete row” which is applicable for google sheets does not allow me to may i ask how am i able to delete all my data at once? and not just a single row data.

[tatiang]

Try this:

[muneer]

Note that there is a block to delete all rows but it only functions for local table. You will not see this block for Airtable or Google sheet.

[teamzaddysn9m]

Already knew about this.

[muneer]

Please note that the last update in Thunkable added the possibility to delete all rows for Google sheet.

[teamzaddysn9m]

Does it mean, by deleting all rows in the google sheets means the first low which is my labels for each specific column, will get deleted too? If so, is there any way to solve this?

[tatiang]

Good question. I think “delete all rows” means that it will delete everything in the sheet including any header row data. But the best way to know is to test it out.

[muneer]

Delete all rows will delete the data rows only keeping the header row as is.

I tested it with a Google sheet with 2 data rows.