Bridge: Copy partial Row example - error

twarner

Hi all!

I'm working on learning Bridge to do some simple things for my PMO team. My first use case happens to line up very neatly with one of the Smartsheet Help articles (Copy partial rows to another sheet using a Bridge workflow | Smartsheet Learning Center), so I thought it would be a breeze. (famous last words).

I've got my workflow setup and running into trouble pretty quickly in a way that doesn't make any sense. Here's my workflow:

This appears to match the Help article.

I've got my Trigger set up with a "When Column Values Change" trigger - on a Checkbox column.

The Trigger seems to work, as the Trigger object comes back and identifies the correct sheet & row that I checked in my test.

Here is the error:

Here is my Get Row configuration:

Now, if I choose just one of the rows in my source sheet, grab the RowID, then paste that actual RowID into the "Row ID" field in the Get Row config - everything runs just find. It grabs the data from that particular row and moves along without error.

Obviously, I only want the row data from the row that 'triggered' the workflow in the first place, so I want a 'runtime' code that will grab the row data from the Trigger event.

I've also experimented with variations on the Row ID code:

{{states.startstate.smartsheet.get_row.row}} - same error results

{{runtime.rowID}} - same error results

Since I'm very new to Bridge, there may be something super simple I'm doing wrong. Hoping one of you more experienced 'Bridge-ers' can help me out.

Thanks,

Tony

Paul Newcome

Try this for the Row ID in the Get Row module:

{{runtime.event.rowId}}

Notice the end is "Id" with a lowercase "d". It is case sensitive but understandably frustrating when the "sheetID" is a capital "D". I always suggest going into the run-log and copying the reference from there to help avoid this.

Paul Newcome

Try this for the Row ID in the Get Row module:

{{runtime.event.rowId}}

Notice the end is "Id" with a lowercase "d". It is case sensitive but understandably frustrating when the "sheetID" is a capital "D". I always suggest going into the run-log and copying the reference from there to help avoid this.

twarner

@Paul Newcome - OMG! Are you serious?!! Yes, that fixed the issue… I've been stuck on this for a week. Still waiting on Smartsheet Support to get back to me on why this wasn't working.

Thank you so much. I figured it would be something simple, but that is crazy!

Tony

Paul Newcome

Happy to help. 👍️