Scheduled Bridge Workflows
Lately I've had problems with Bridge workflows erroring randomly. This is a problem for several of my solutions, so I'm developing safety net workflows to catch actions that were missed when the errors occurred.
But I'm stuck because up to now, I've been able to use rundata from the trigger to guide the rest of the workflow.
Here's a quick description of my current workflow:
If a row is added to Sheet 1, grab some values from it and populate them to a new row in Sheet 2. This is easy because I can use the row data from the trigger data. But as I mentioned, if the workflow errors during a run, Bridge basically forgets all about it and no one knows that row was missed and not added to Sheet 2.
My safety net is to add a step to the workflow where I'll have Bridge check a box to confirm the workflow completed for that row on Sheet 1.
Then I'll add a second time-based workflow to search Sheet 1 every 15 minutes for unchecked boxes. I'm pretty sure the Search Sheet module is my first step, but how do I then tell Bridge to take each of those rows it finds and create new rows in Sheet 2?