Deleting child record when parent is deleted

[RobJon]

I have found a few posts relating to this, but so far, not found a solution.

I have a golf app. There are two databases, Rounds and Holes. Rounds can have multiple holes, but a hole can only belong to one round. When a Round is deleted, I want all associated Holes to be deleted with it.

I found this post talking about linking through multiple screens. But the final screen only allows me to delete the Current Hole.

Surely this is a common issue? Does anyone have a solution?

[dilon_perera]

Hi @RobJon,

Welcome to the community

As far as I’m aware there is no easy way to this. But Victor invented a nice solution for this with the countdown timer. You can see here : Adalo experiments - mass delete - YouTube

Is there any way i can delete all records in a collection?

Hi @dunderkid @Colin That solution didn’t work for me, I have created the other one. The Mass Delete is implemented using List of items + Countdown timer + Delete action. In brief: you need to create a specific “delete” screen, where you have the list of items in the collection to be deleted, together with timer. When timer finishes, the list item is deleted. It is also possible to implement deleting records from 1:many collections (1 parent item + child items). Here is the video: https://yout…

Thank you

[RobJon]

Thanks! I’ve finally got it. Added a nice spinning animation while it does its thinking. Works well
Many thanks

[dilon_perera]

@RobJon

Thanks! I’ve finally got it. Added a nice spinning animation while it does its thinking. Works well

Awsome!

@RobJon

Many thanks

Your Welcome!