BRIDGE - Use Trigger Index to Pick From Array and Output

Paul Newcome

I am currently trying to use Bridge to create a list of all sheets that I have access to in a Smartsheet. I am only pulling in IDs for now but plan to eventually pull more data such as Sheet Name and a few other things related to each sheet.

I have figured out how to pull the list of sheets and create an array of just the IDs. It is a parent workflow to take care of the looping.

What I am stuck on is how to leverage the Trigger Index in the child workflow to tell it which piece for the array to pull for the row.

Additionally… I was planning on using an "Add Row", but I realize that running this multiple times will create duplicates. Any ideas? I am not quite familiar enough with Junctions to be able to work that piece out either…

Paul Newcome

I figured out the pick part. I just needed to Offset Array and pass that into my Add Row.

Still wouldn't mind some help on the Junction Part. Basically what I need is… If the Sheet ID doesn't exist, add a new row. If it does already exist, do nothing.

Paul Newcome

Got it figured out. I searched the target sheet for the Sheet ID populated by the Offset Array step. Then I created an "Equals" Conditional Junction that compared the Offset output to the Search Sheet output. If found, do nothing, otherwise Add Row.

Paul Newcome

I figured out the pick part. I just needed to Offset Array and pass that into my Add Row.

Still wouldn't mind some help on the Junction Part. Basically what I need is… If the Sheet ID doesn't exist, add a new row. If it does already exist, do nothing.

Paul Newcome

Got it figured out. I searched the target sheet for the Sheet ID populated by the Offset Array step. Then I created an "Equals" Conditional Junction that compared the Offset output to the Search Sheet output. If found, do nothing, otherwise Add Row.

Brian_Richardson

@Paul Newcome sweet solution, sorry I never saw this until now to help you out. Looking forward to connecting at Engage!

Paul Newcome

@Brian_Richardson I sent you an email about connecting. I have another challenge that I may end up posting here as well involving creating dynamic run time data.