Delete associated row in second sheet base on unique field , no refs or key

It was easy to add a record to a second sheet with an action and a workflow.
I am passing in a unique identifier.

I have been able to implement updates on the record in the second sheet see Update a second sheet with changed values from first sheet on update

How do we implement a delete for the record in the second sheet ?

Hello,

I think you can achieve what you’re trying to do using an action that deletes the related rows, which could look something like this:

combined with a workflow that triggers the action whenever a row is deleted, which could look like this:

Does that help?

Thanks Madelai. The problem was that I wanted to delete the original record in the first sheet as well and my action was triggered by the system delete action.
What was happening is that there was no referenced row so a perfectly good action was firing against nothing I was able to solve this by:

1 setting the Delete Action Icon to Do not Display
2 Creating an action that is a grouped action that first deletes from the second sheet and then deletes from the parent sheet.
3 Add the trash can icon for the new action

2 Likes