Hi,
I am working on a app, where I have a order which is connected to 2 another tables through order ID. I would like to create an action that can delete rows from all tables related to this order ID.
I would like to have that option only in order detail.
Is there a way to execute multiple actions that are connected with a specific column data?
Thanks for your time.
You should have system generated Delete action in child table.
Then on your parent table, you create action something like this.
You could in general try using reference actions on those connected tables through order id and use group actions to execute all those in sequence.
If the child table has an Is a part of relationship to the parent table…
then the child rows will automatically be deleted when the parent row is.
Hi, what if i have a virtual column to a referenced table and i don’t want to delete the data from the referenced table in my action. I have a Bot set up to “When the date is older than today, move the row to another table [past bookings], then delete the row in the [master bookings] table. This is working but its not carrying the data over from the referenced table (which is my [updates] table”
