Bridge: Add row for every sheet

Alla
Alla ✭✭
edited 09/25/23 in Add Ons and Integrations

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

  • Genevieve P.
    Genevieve P. Employee Admin
    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

Answers

  • Genevieve P.
    Genevieve P. Employee Admin
    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