Auto direct risk from master register to project risk

I have a master risk register with a column controlled by Bridge to update when a new project is spun up in Control Centre.. that way it's easier for people to add risks for a project.

Is there a way to automatically divert the risk from the master register to the respective project register?

I have the project code as metadata..

I was thinking something along the lines of the picture below, but a little stuck on the actual solution!

Really appreciate any help.

cc @Brian_Richardson @Genevieve P.

Find more posts tagged with

Bridge

Accepted answers

Ide AirTrunk

I figured it out..

For those wondering, I had a parent workflow like so;

Then I had a child workflow like so;

Super super happy!

All comments

Ide AirTrunk

I have got this far so far, but can't crack matching the project ID and then knowing which sheet to direct it to

Ide AirTrunk

@Samuel Mueller I saw you're great with Bridge, wondering if you could help please?

Ide AirTrunk

@Kelly Moore I also note you're great with Bridge, any idea how I could get this working? please.

Ide AirTrunk

Also think something like this might work:

Parent workflow:

and then a childworkflow which searches the sheet for a match of Project ID, and if matches, adds the row?

Ide AirTrunk

@Paul Newcome any idea? also saw you were very good at Bridge.

Ide AirTrunk

I figured it out..

For those wondering, I had a parent workflow like so;

Then I had a child workflow like so;

Super super happy!

Georgie

Hey @Ide AirTrunk,

Thanks so much for posting your solution. I'm glad you were able to work this out!

Georgie

Kelly Moore

Hey @Ide AirTrunk

Nice job on the flow.

One step I sometimes needed was an Array Length step after a Search step, where I could check if the returned array had a length greater than zero - a similar process to using COUNTIFS > 0 in a formula to see if there was a match. The array length step could give me a decision point, especially if I was trying to decide if I needed to update a row vs insert a new row. I'm sure there were more elegant ways to achieve but this way usually worked for me.

Kelly

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.