Bridge sort - performing the same sort on multiple sheets

Shirley.T

Hi,

I have a Bridge workflow that can sort a sheet based on a column on the sheet.

Now I have 14 Divisions each having the same type of sheet. Is there a way to use a loop to perform the same ort on the 14 different sheets? (I read about parent child workflows but am not sure how to create a loop to pass the variables, etc.)

Thanks!

Darren Mullen

@Shirley.T yes you can do that, but it's a bit involved.

also, its probably better to use the JavaScript module to sort vs a child workflow. Much better performance, if you know JavaScript or are willing to learn it.

Darren Mullen

@Shirley.T yes you can do that, but it's a bit involved.

also, its probably better to use the JavaScript module to sort vs a child workflow. Much better performance, if you know JavaScript or are willing to learn it.

Shirley.T

Thanks Darren. I have written a little bit of JavaScript before but not with Smartsheet and Bridge. Will look into it. Any tips you or others like to give is definitely welcome.

Darren Mullen

@Shirley.T That's good!

In the javascript module you are limited to straight javascript, meaning no libraries or Jquery, etc.

You can pass multiple values or arrays from preceding steps in Bridge into the Javascript module. When you do this, the keyvalue name you assign to it in the Javascript module becomes the variable name in the Javascript, so you don't declare it in your script.

For example, let's say you use a "Get Sheet" module in bridge and you want to pass the results array from this module into the script.

In your script you will write a variable like "mySheetArray" in the script, but you won't declare it in the script. When you call the script from the Javascript module in bridge you'll see where you can assign a value and a key value. The key value will be "mySheetArray" and then you can assign the results array from the preceding step to this.