Bridge: Add row for every sheet
I am trying to create a library of all the smartsheets we have using Bridge and automatically update this list as more sheets are added. Basically it will list sheet name, id, owner and link
I have difficulty to figure out how to add them one by one. it only adds one row on the
sheet. I feel like there may be have to be som
e kind of looping. Any ideas?
Best Answer
-
Hey @Alla
After the "List Sheets" module, the Run Log should have an Array of all of your sheets. What I would do here is then add a Child Workflow Module, and build out the rest of your workflow in a separate, Child workflow.
For the "Number of Runs" part of the Child Workflow Module, add in the reference to the Array from your run log.
This will then parse out each individual sheet as a separate workflow trigger for the Child, meaning you can add them as separate rows.
See: Use child workflows to manage complex processes
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
Hey @Alla
After the "List Sheets" module, the Run Log should have an Array of all of your sheets. What I would do here is then add a Child Workflow Module, and build out the rest of your workflow in a separate, Child workflow.
For the "Number of Runs" part of the Child Workflow Module, add in the reference to the Array from your run log.
This will then parse out each individual sheet as a separate workflow trigger for the Child, meaning you can add them as separate rows.
See: Use child workflows to manage complex processes
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives