Hi devs. So I just learned the Tree:parent trick. Wouldn’t it be nice to be able to delete the parent item along with its child elements (optionally of course)? Here’s a sample sheet https://drive.google.com/open?id=10Qu9GJW_gNG9mo_LLoyPTMdEgsysfhVpkESY3cBta6E Thanks :slight_smile:

Interesting! Can you tell us more about your use case?

So in that sheet I’m creating an inventory app. How the app works: first sheet is to create, edit and view the ‘Folder’ and in the other sheet are the items corresponding to each folder (also can create, edit and view). I managed to link them using the Tree:Parent method but when I need to delete t…

Glide can’t do that, and probably won’t for quite a while, but we’ll think about it.

You could write a relatively simple script that would “clean” up the related child sheet. It would scan the child sheet and do a lookup into the parent sheet. If no match the row would be deleted. Probably about 20 lines of code. Add a timed trigger and it could be run periodically.

Interesting :thinking: I’ll try to figure that out. You could put a timer in gsheet? Is it through formula or an embedded script?

When you get into the script editor one of the icons is a picture of a clock. That is where you would set up the timed trigger. I lied, the code is actually 44 lines of code but I did throw in some comments to hopefully make it easier to follow. I did use arrays as that is the fastest way to scan…

Will get back to this. This is a lot to take for a non programmer like me haha. Thanks!

@talkshowhost85 Yeah it can get pretty confusing real fast, but no worries whenever you want to dive into the deep end of the pool there are plenty of YouTube videos that will help you out.

Option to delete all child-items

Feature Requests

Cisco_Muratalla February 9, 2021, 2:28pm 10

linked to similar request [Deleting categories and their child] and archiving this request

Topic		Replies	Views
Delete child rows when deleting a parent row (via multiple relation) Feature Requests	14	1921	May 15, 2023
Delete Row for "Create new action..." workflows Ask for Help actions	41	3075	January 25, 2021
Any ideas how to support cascading deletes? Feature Requests	6	705	March 25, 2020
Exceptions in deleting rows in a spreadsheet Ask for Help	67	1365	January 17, 2022
Deleting an item in Glide won't delete it in sheets. Help please Report a Bug	3	438	February 4, 2024

Option to delete all child-items

Related topics