Bridge Get Row Id not showing.

Scott J.

Good Afternoon

I am new to Bridge and trying to create my first simple workflow to move rows but, I am having an issue with getting the row id. I have tried following the steps in other threads I found with no luck there is something I must be missing.

I have a sheet where form entries are submitted. I setup the Smartsheet integration trigger trying both when rows are added and when rows are changed. I submitted the form and the trigger ran. I go to the run log and expand the trigger section. In all the instructions I have found it was indicated this is where the row id would be found. But no luck for me. I have tried other paths but still not having any luck. Any assistance is appreciated.

Paul Newcome

The filter field is for a filter id. One that comes from the source sheet to indicate which row(s) should be moved.

prime_nathaniel

@Scott J. you will generally NOT want to use the same workflow when starting with bridge to handle add and update as these use two separate "data references" (the variable location and reference to the id that you want). If you are familiar with handling and testing JSON output and setting / getting variables then you are good to take this approach. For new bridge users I would not recommend it though.

All that said, your row ID is event.id = 61843798…… you can use this ID to move, update, delete rows etc

To use this dynamic reference within your workflow you click on the triple dot submenu from within your logs (on the right of the id: 618 … row), click copy data reference. Now use that reference in the format {{willLookLikeThisWithDoubleBraces}} in place of wherever an ID would go as text

You can of course verify this by checking your sheet and right clicking on the row.

Paul Newcome

The row id is where it just says "id". If you look directly below that, you will see that the "objectType" is "row". That tells you that the "id" number above is the row id that triggered the workflow.

Scott J.

Thank you for the replies. I thought row id would be listed separately from the event id. When copying the data reference the output is {{runtime.event.id}} vs row id. When trying to use this output in the execution it fails as unmatched filter.

Paul Newcome

Can you provide screenshots of where exactly you are using it?

Scott J.

The workflow is very basic. The trigger is when rows are added. I am sure this is just a beginners error or I am missing something in the instructions I found. 2 Screenshots

Paul Newcome

The filter field is for a filter id. One that comes from the source sheet to indicate which row(s) should be moved.