This is a general feature request to support cascading deletes in GlideApp.
Background: My app has a sheet “Exercises” and “Exercise Homework”. Items in homework relate via unique key to exercises, i.e. someone posts an exercise and others can post replies how they completed the exercise.
Challenge: The person who posted the exercise can delete it later. All good so far. But the replies to the exercise were only accessible on the individual exercise page and can no longer be reached and hence deleted from the app. The result is stale data in the homework sheet.
Request: It should be possible to configure the relationship of the items in one sheet to items in another as a “cascading” relationship, so that when the exercise gets deleted, all posted homework items relating to it are also removed.
I haven’t tested how the “Comments” component works, but since it has a built in capability to relate to a unique key item, I’d hope the comments relating to the item are deleted when the item is deleted?
Maybe someone has an idea how to do this via a Google Sheet formula or feature for the moment?
Thanks for your help!