Bridge: When a cell in a parent row is updated, update the same cell/column in child rows

JodyRakow

Hi there!

I think what I need to do is search the sheet for all rows whose parent IDs are equal to the row ID of the row that triggered the workflow. Once I am able to grab those rows, I know how to have Bridge update them. :-)

I am stuck trying to figure out how to include the "parent.Id" data in a sheet search in order to find the child rows. Could someone point me in the right direction, and/or suggest an alternate path?

Thank you so much!

Paul Newcome

In the sSearch Sheet module, go to the "Advanced Options" and check the box for "Include Sheet Data". I believe this should include both the row id and the parent id.

JodyRakow

https://community.smartsheet.com/discussion/comment/477223#Comment_477223

I do have that checked - but still I am not seeing, in the "row filters" area of the search parameters, where I can ask it to search for the row ID. It is requiring me to search by cell - i.e. I need to input the name of the column - and I'm not sure whether there's a way to input a value there that would ask Bridge to search row IDs?

Paul Newcome

Are you able to provide some screenshots for context? Row ids can usually be found in the run log and including sheet data will include the parent row ids. Reading your post again, you may need to pull all rows from the sheet and then use a JavaScript module to extract the list of rows that have the specified parent row id.

JodyRakow

https://community.smartsheet.com/discussion/comment/477395#Comment_477395

Sure thing! Here's where I'm needing to input the search parameters in the "Search Sheet" module:

The "Row Filters" area asks me for a column, and then asks for what I want it to find in that column. As the Row IDs are not found in a column, I'm not sure whether there is a way to ask it to look in the row information instead for the Row ID? (i.e. is there a column "name" that I could input that would prompt it to look in the row info instead of in a cell?)

Paul Newcome

Right. So you are going to need to either have a column that houses the row ids or pull all rows and then use a JavaScript to do the filtering.