Bulk Delete

AppSheet AppSheet Q&A
,
21

Resticted for what reason? How many rows do you have totally in your table where those records are?

1 Like
22

Webhooks are disabled in the company for security reasons so I canā€™t use it. In the appsheet database table currently there are 1000+ records from which I am trying to delete around 200

1 Like
23

I made a quick test. Two tablesā€¦ parent (100 records) and child (1000 records). When I select 20 parents, it will delete 200 childs and it takes about 6 seconds to delete all those rows and syncing the app when its executed. It sounds you are doing something wrong if it takes 100 secs.

1 Like
24

Currently when there is an update in a field in Parent I am removing 200 children not the parent and this is in Appsheet Database. I tried to create another table where I linked all the children with different field and then tried to delete that row instead of deleting all the children. With that approach as well appsheet deletes records one by one and I can see it in the appsheet database and thatā€™s why itā€™s taking so much time

25

And you are using Bot.. not just a normal action, right?

1 Like
26

I made the same.. updating the parent will delete 1000 childs and it takes 9 seconds.. which is the normal behavior. Do you have a lot of virtual columns with complex formulas in your child table?

1 Like
27

In Child table I have editable and show if condition on almost 30 columns only 4 VC in Parent table

28

But do you have any virtual columns in your child table?

29

Only 2 VC which is show based on a simple calculation

30

Please send me a personal message. I need to see your app (if itā€™s possible) how itā€™s built as it sounds weird.

2 Likes
31

I am not able to dm you. Can you dm me?

32

No, send me an email. I will clear my email after it has sent.

1 Like
33

I will not be able to send it.