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: