My schema contains several parent-child relationships that do not qualify for the “is part of” parameter. When a record is deleted from the parent table, child ref values that link to it become broken. I want to find these values in the child table and replace them with an empty string. How can I do this?
I know of one complication in this task: any bot triggered by the deletion will not have access to the key value of the deleted record, because it will already have been deleted.
Try this
Create an Action : set values to some column of this row.
[×××××] = empty string
Action condition:
If ( in ([this row]. [xxxx ] , [parent table values] ), false, true)
Attach this action to a bot ,
When to trigger : keep it as all "changes or deletes "
Thank you! This worked!
I don’t know why to trigger on “updates and deletes” rather than “deletes” only. In my use case, the primary key of the parent is invisible to the user so they’ll never update its value. So I left it to trigger on deletes only.
Here are screenshots of my implementation, to clarify your instructions for others. In my app, “model” is a child of “manufacturer”.
I created a hidden action that operates on the model table:
Here is the conditional formula for it:
Then I made a bot that executes the action whenever a manufacturer record is deleted. Here is its event configuration:
And here is its action configuration:
