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
Use bulk actions - AppSheet Help
Look for “Execute an action on a set of rows” here:
Actions: The Essentials - AppSheet Help
Thanks Joseph. I checked the link before but it is not what I need since it is about selecting records one by one or through related tables, but in this case it is a table that is not related to another. There must be some way in which when executing an action all the records of a table are deleted, which can be thousands.
See the second link..
Thanks Joseph, but it’s not what I’m looking for.
Can you access the backend of the app (Google Sheets or Excel) and delete the records there?
In this case the users do not have access to the data source, so I need to bulk delete the records from an AppSheet app, through an action or a bot. I will appreciate any help in that line.
I have done it before, just manipulate the url then it will select all. Let me check if I still keep the app. Will update you later if I still have it.
This is the formula I used in Action: Go to another view
For the filter it’s up to your case.
LINKTOVIEW(‘Backup’)&‘&SELECTED=’&ENCODEURL(‘["’&SUBSTITUTE(FILTER(‘Parcel’, AND([Status] = ‘Collected’, TEXT([Status DateTime],“DDMM”) = “2502”)),’ , ‘,’“,”‘)&’"]')
If you have quite a lot of rows, I would use Bot/Weghook for that purpose.
Thanks Aleksi! You’re right. Do you have any example you can show how to build the bot/webhook?
Thanks for your answer, but I don’t understand how the action to go to another view is going to delete the thousands of records from a table. I will appreciate if you can explain to me.
Would you please share your email via private message. I will find an suitable app from my account.
For thousands of record I think it is not suitable to do that.
I use bot to delete it.
Gracias. Haré la prueba.
I created bot which runs on set of rows but it’s taking more than 100 seconds to do the deletion. Using appsheet database. Tried to create reference table and delete only the parent so that it deletes all the children at once but it’s taking the same time. Any idea you can suggest? Tried appsheet api as well to delete the records but same result
Don’t know how have you built the app and Bot, but deleting rows with the AppSheet API & webhook should not take more than 10 seconds as it needs to update the client as well. How many rows are you trying to delete?
I am trying to delete 237 rows.
This is the setup. I am deleting rows from Billing Material Table . I cannot use Webhook as it’s restricted in here. I tried to create a different table where I can make a ref and just delete that one entry which then deletes all the children at once but in that approach as well it’s getting delete one by one row.
This is the script I tried. using appsheet api
