Deleting parent deletes children

[John_Coda]

Sometimes, when deleting the parent object (row), you want to delete the children objects (rows in another table) that are connected to this. Happens when:

• Meetings have topics and action items. When you delete the meeting, you no longer want action items and topics for that meeting in the other tables.
• Delete the company in your CRM, you no longer want the contacts connected to it.
• Delete the project, the tasks no longer apply.

Here’s a doc and explainer video showing how to implement:

[Paul_Danyliuk]

Alternative way for those who prefer formulas: instead of deleting from another table where Meeting = thisRow, you can delete by references pulled via lookups:

RunActions(
  thisRow.Tasks.Filter(true).DeleteRows(),
  thisRow.Topics.Filter(true).DeleteRows(),
  thisRow.DeleteRows()
)

This is especially useful if the condition for the lookup is more than just something = thisRow.

Filter(true) is the trick to convert a list of rows into a “virtual” table that you can feed to DeleteRows(). Simply thisRow.Tasks.DeleteRows() won’t work. Props to @Dalmo_Mendonca for the trick:

Mark checkbox if certain options are selected from a list

I can’t seem to make that one work The buttons only work if there’s only a single row selected: Edit: Got it. Some functions like Filter() return a table, so you can use it to convert a list of rows into an anonymous table before applying ModifyRows: Still don’t know how your code would work for the original post, though.