I have a Great parent table (weekly record) Parent(daily Record) table record associated with 5 different child table records(a,b,c,d,e,f) if i deleted the parent record, I want the related records to be deleted too, in this table were I hAve all my totals Weekly based.
I’m try to use a BOT with ONLY DELETE, and run an action on rows where the the reference table is the Parent the referenced rows is this formula:
The result is a list with the same value in different dates, but when i’m deleting the PARENT record is deleting the last record but not the record associate with the date.
In the child table you should have a column that references the parent table record. Make sure this column is set up as “Is part of”. Whenever a parent record is deleted this will also delete the child records.
Or show us exactly how you have your bot set up, but I’m thinking you either have the bot set up on the child table referring back to the parent table, or the bot is set up for the parent table and you are trying to execute the action on the parent row vs the child rows.
You can’t reference the child records of a record that has just been deleted, because that data no longer exists!
What you have to do is set up a new custom “delete” action that just sets some data value to a column, which triggers a Bot to run, that deletes all child records first, then deletes the parent record last.
