In my app, users can create categories, then subcategories, then subsubcategories and so on (5 levels).
But they can also delete any category or subcategory, at all level.
I am using unique id’s in order to ensure the link between these items remains even if the user change the item name. But, in case of item deletion, the child of this item remain alone, most in the dark of my sheet, and are consuming rows.
I would need your advice on the best way to manage this issue. I thank about creating an “orphans items” sheet were all lost items would be stored, using a formula or a Google script based on unique id’s manipulation.
What would be your advice, or your experience with such behavior and issue?
I agree that any child of a category can not be automatically deleted, the app can not (must not) delete user data without the consentment of the users.
Many thanks for any advice or quickwin!