I have a worksheet with vehicles, one with associated tire sets and one with associated individual tires (front right, front left, rear right, rear left).
I would like to manage if a set of tires is deleted, then all associated tires should be deleted automatically. and if I delete a vehicle, then all associated tire sets and associated tires should be deleted. with the native delete button from glide, i can’t find any triggers that could do that. Or am I missing something?
Have you ever tried the custom actions?
Cascading delete is not supported in Glide. To do this, at the moment you must have your data in Google Sheets, then use an Integromat to support it.
Let’s say you have a vehicle ID that is also present in your Tire Sets and Tires sheets. When you delete the vehicle, pass the vehicle ID to a webhook in Integromat. Then find all rows that have the same ID in your Tire Sets and Tires sheets and delete them.
What about not deleting but only hiding the associated rows. If you have a show status column in your table vehicle you do a lookup in the table tire sets and change the show status of each row using an if-else column.
I have done something similar to this. Based on lookup and relations, and using visibility condition, you can hide individual tire set, if set of tires is empty. Similarly, if vehicle is deleted, other relevant details will be hidden.