How can I delete all rows in the appsheet for a particular table (not able to select all)

I am facing problem for selecting all the rows of a particular table. I need to select all to delete it and upload new data. but there is no select all option. Can anyone help? 

0 5 3,275
5 REPLIES 5

You could try a few options

1) If you have just 10-15 rows to delete you could use bulk actions option.

https://help.appsheet.com/en/articles/3582281-bulk-select

2) If you have say few tens of rows, you could use reference actions. You could set reference action on some other table to delete all the rows of the table that you wish to delete.

https://help.appsheet.com/en/articles/953637-actions-the-essentials#external-open-a-file

https://www.appsheet.com/templates/This-app-shows-how-to-use-reference-actions?appGuidString=e76d2e7...

 

However, both options 1 and 2 above will invoke one separate delete action per row. So if there are 30 rows to delete , 30 delete actions will invoke.

If there are a large number of rows to delete you could evaluate API Webhooks option.

https://help.appsheet.com/en/articles/1980017-deleting-records-from-a-table

You can actually do this very simply, although not as intuitive as it seems. I was afraid of doing actions, apis and other things for something this simple, but I resorted to Excel styles.

Place your cursor on the first row and column of data, press Shift-Ctrl-Down, then Right-Click and hit Delete Rows.

Although this post is old, I hit it when searching to do this very same thing.

I did this using a desktop on Chrome, I don't use appsheet/appdbs development on mobile.

@StreamlinedPM ,

Could you update where you tested this approach. I am aware your suggested approach should work in a desktop browser. Could you confirm it also works in the mobile device? 

Sure, but I don't test/use with mobile.

chc
Bronze 1
Bronze 1

Here is a extremely  simple method.

Just click on the first row of any column, hold and drag till the end of the table to select all rows. After that, right click and select delete.

Done.

 

 

Top Labels in this Space