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.

Smartsheet Bridge: New Junction

✭✭✭
edited 01/10/25 in Add Ons and Integrations

Hi,

I am exploring the "New Junction" in Bridge. When I add a value in Context using the dropdown, e.g. sys-animals, Bridge complains of unsupported module.

Can someone please shed some insight into how the Context and Values To Check For can be used?


Regards,

AK

Tags:

Answers

  • Employee
    edited 04/26/24

    Hey @akhalid

    I really appreciate seeing all the ways you're using Bridge and testing out the different functionalities!

    You have stumbled across a piece of historical structure that hasn't been removed just yet…those fields used to link to a sort of prototype chat system within the product (which you saw in this other post!). At this time, those fields should be ignored as they no longer connect with that unsupported module.

    However you can still use the Conditional Junction - Junction Match to route your workflow down a specific path based on a matching value.

    The way it works is that it uses the State Name to match - so in your instance, "Dog". None of the other fields within the "Dog" state are relevant anymore. Then underneath the "Dog" state you can add your other actions.

    Here, I'll give you a peek "behind the curtain" for how I use this to auto-award badges when members post in specific topics/categories (such as the Brandfolder or Education topic).

    The Conditional Junction: Junction Match looks at the "Category ID" that's in my run log for this run, and matches it against the State Names listed under Junction: Category.

    The fallback state is the one titled "Other Category", which you can see I listed. Then the other state names are the Category IDs themselves (e.g. the Brandfolder topic is 339, which is what I'm looking to match on). If that's correct, then it goes through my next steps.

    I personally added another State underneath the purple ones to put my own custom label associated with each path, since "339" isn't very clear for what category/topic that is. Then I use the API to award the badge.

    The 339 state is completely blank otherwise:

    Does this make sense?

    Cheers!
    Genevieve

    Need more information? 👀 | Help and Learning Center

    こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions

  • ✭✭✭

    Thanks @Genevieve P. .

    It is amazing to learn that you are eating your own dogfood! 🐶

    It reminds me that when I was a Product Owner at EDMI 5 years ago, I used to update the team's progress from JIRA into 7Geese using a Python script that would run every day on a schedule. At the PO's daily sync meeting headed by the PM, he would get the update from everyone and skip me because everything was already updated in the system! 🙂

    Regards,

    AK

  • Haha that's awesome! Thanks for sharing 🙂

    Need more information? 👀 | Help and Learning Center

    こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions

  • ✭✭✭
    edited 01/09/25

    Hi @Genevieve P. , can you tell me how to add more than two paths/states under a one Junction? What I'm hoping Bridge can do is have one Junction that looks at one column and have value 1 be AA and value 2 be AB and value 3 be AC etc. etc. If the value is AA then do X, Y, and Z. If the value is AB then do E, F, and G. Do you know if this is possible?

  • Employee
    edited 01/10/25

    Hi @Randy Naganuma

    Yes, Bridge can do this! 🙂 You will want to use the Conditional Junction: Junction Match module to read your Value and match it to any of the State Names below.

    Here's the Help Article with steps on how to set this up: Site faviconRoute workflows with junctions | Smartsheet Learning Center

    Let us know if this helped or if you have any further questions.

    Cheers,
    Genevieve

    Need more information? 👀 | Help and Learning Center

    こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions

  • ✭✭✭
    edited 01/10/25

    Thanks @Genevieve P., really appreciate you taking the time to respond.

    I went down this route originally but when I add a Match Junction or any Junction under a Conditional Junction: Junction Match, it only gives me two possible paths (State: success, State: failure). How do I add a third, fourth, fifth, etc. state?

    Is this only possible if I add a New Junction under the Conditional Junction: Junction Match?

  • ✭✭✭

    @Randy Naganuma please have a look at the article linked below:

    Bridge by Smartsheet > Conditional Junctions

    Some examples for illustration.

    JunctionMatch:

    Junction:test →This is New Junction

     

    State: red

  • Thanks @akhalid. It looks like I was correct that only the New Junction allows for multiple paths. 😊

    Do you or @Genevieve P. know the syntax I can use to have the workflow match a value within a cell that's set up as a Dropdown List? The ISS Impacts in the screenshot below is a Dropdown List.

    The workflow runs successfully and follows the None path.

    I'm assuming it follows this path because there isn't a direct match of "(CM) Change Support" in the ISS Impacts field to match what I have listed in the Values to Check For.

  • ✭✭✭

    @Randy Naganuma
    The easiest way to find this is by adding a block in the workflow to read the entire sheet. Open the results panel and dig into the "rows", then open the row of interest and then the column of interest. You will see that the value shows up under the key "displayValue".

  • Hi @Randy Naganuma

    I think the confusion here is that a Conditional Junction verifies the match by looking directly at the State Name versus any of the fields in the side panel.

    It looks like you've set up the workflow correctly - you're looking to find the cell value for what's in "ISS Impacts" and match that up to one of the options below.

    In your image, the state names are the text: "Change Support" or "Change Initiative" or "None". These are what it's looking to match against your "ISS Impacts" field.

    If you want it to look for "(CM) Change Support" then that needs to be the State Name. Does that make sense?

    Cheers,
    Genevieve

    Need more information? 👀 | Help and Learning Center

    こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions

Trending Posts