BRIDGE - Use Trigger Index to Pick From Array and Output
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.
-
@Paul Newcome sweet solution, sorry I never saw this until now to help you out. Looking forward to connecting at Engage!
-
@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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives