Applies to

Bridge by Smartsheet

JavaScript module reference

PLANS

  • Bridge by Smartsheet

Run Script

Use this module to write JavaScript functions and fire up the function(s) you wrote.

Image of the Run Script module

Run Script fields

You can use data references in the following fields:

  • Script Name:The name assigned to the required script created from the Integrations page
  • Script Parameters:The parameters the script expects when running, represented as a map of key:value object
    • Key:The parameter name that appears in the script
    • Value:The actual value that this parameter needs to take while running the script

The number of script parameters allowed is unlimited, and they are added dynamically. This means that you can always add more parameters.

What you’ll see in the Run Log pane

Once Bridge runs theRun Scriptmodule, the following information will be available in theRun Logpane:

  • Data
    • result:Desired JavaScript output
  • State:Section that indicates whether or not the module worked
    • Code:The success/error code that the module pulls from Smartsheet
    • Message:A system-generated message that the module pulls from Smartsheet
      • For example, if the module can’t find a value, the message that will appear is “Not found.”
    • Status:The status that the module pulls from Smartsheet
      • These are examples of status labels you might encounter:
        • Succeeded:The module successfully found the information.
        • Failed:The module didn’t find the information.

How-to guides

Use the following examples to practice using the JavaScript Utility.

示例1:Hello world

In theScript Bodyfield, typereturn “Hello” + a.

You must typeReturnin every script to produce a response. Then add the parameters you defined in the module builder.

Screenshot of the Custom Scripts tab

Make sure theKeyin the module builder matches the parameter in theScript Bodyfield.Valueis the interchangeable input. For example, it can come from an output from an earlier module response.

JavaScript module fields

Notice that theScript Namefield does not require quotation marks for string inputs, as this is handled by the UI. Whereas in theScript Bodyfield,helloshould be specified with quotation marks.

Screenshot of Script Name and Script Body fields

Otherwise, you’ll see the error message presented in the image below.

Error message in the Run Log pane

Example 2: Basic arithmetic

  • In theScript Bodyfield, typereturn a + b.

A screenshot of the value in the Script Body field

Notice that this method links the two values rather than add them. This is because JavaScript considers theaandbto be object instances, which could have been called in another part of the script body.

Key and Value fields in the JavaScript module

Module result in the Run Log pane

We can define these as number types in the following:

  • return Number(a) + Number(b)

A screenshot of the value in the Script Body field

A screenshot of the result in the Run Log pane

Example 3: Iterate over an array

  • In theScript Bodyfield, type:

function getFields(input, field) {
var output = [];
for (var i=0; i < input.length ; ++i)
{
//print only one column
output.push(input[i][field]);
}
return output;
}

return getFields(objArray, field);

The key parameters are the following elements:

  • field:The key in an object array
  • objArray:The array from which to extract the key

Product/feature limitations

  • 你只能过程6米B payload request and responses.
    This is subject to change with the upcoming upgrades.
  • 没有脚本验证脚本创建. If a script is faulty, it’s the developer’s responsibility to debug/fix any issues and errors returned when running the script.
  • The Smartsheet team doesn’t track or manage script versions and history.
  • Bridge is appropriate for an event or fixed-schedule-based workflows. It isn’t a replacement for the functionality of the one-way or two-way mirror syncing provided by connectors. By design, Bridge makes no guarantees of order nor holds any state about changes made in one system or the other. So connector-like setups are unreliable and are strongly discouraged.
Was this article helpful?
Yes No