BRIDGE - Use Trigger Index to Pick From Array and Output
![Paul Newcome](https://us.v-cdn.net/6031209/uploads/userpics/082/nQPUTVFKKWDJ2.jpg)
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…
Best Answers
-
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.
-
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.
Answers
-
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.
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives