Skip to content
  • Try Smartsheet

    • Add Ons and Integrations

    Add Ons and Integrations

    Ask questions about Control Center, Dynamic View, DataMesh, Pivot App, Calendar App, or WorkApps. Discuss connecting Smartsheet to your other systems with integrations such as Bridge, Data Shuttle, the Jira connector, and the Salesforce connector.

    Bridge-Insert Hyperlink

    ✭✭✭
    in Add Ons and Integrations

    Using Bridge, how can I set up a workflow to pull a URL from one cell, and add it as a formatted hyperlink to another? I've tried searching through modules and the API documentation, but I'm very much a beginner and not quite sure what to look for.

    Example:

    image.png


    Tags:
    · Share on FacebookShare on Twitter

    Best Answer

    • Employee
      edited 09/28/23 Answer ✓

      Hi @dsprenger! I was able to make this work using the Get Row and Update Row elements.

      Get Row provided info like the row ID, the data references for the 'title' and 'url' cell values on the row, etc.

      Update Row allowed me to use that row info to add the hyperlink correctly. Adding an Advanced Cell, I referenced the column being updated ('title'), chose Hyperlink as the input type, then used data references for the row's 'title' cell value as Display Text (meaning your original title is retained), and the 'url' cell value in the URL field.


      image.png


      · Share on FacebookShare on Twitter

    Answers

    • Employee
      edited 09/28/23 Answer ✓

      Hi @dsprenger! I was able to make this work using the Get Row and Update Row elements.

      Get Row provided info like the row ID, the data references for the 'title' and 'url' cell values on the row, etc.

      Update Row allowed me to use that row info to add the hyperlink correctly. Adding an Advanced Cell, I referenced the column being updated ('title'), chose Hyperlink as the input type, then used data references for the row's 'title' cell value as Display Text (meaning your original title is retained), and the 'url' cell value in the URL field.


      image.png


      · Share on FacebookShare on Twitter
    • ✭✭✭
      CWainwright

      Thank you so much! I'm very new to Bridge, so I'm slowly learning the capabilities and how to build workflows. 😅

      · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Quick Links

    Categories

    Trending Posts

    Help shape the future of Smartsheet.
    Share your ideas and feature requests.

     Watch video