Using Bridge Parent Workflow to trigger children based on which columns were updated.

Hi community,

I'm fairly new to using Bridge, but I have a couple of flows working nicely. Very proud of myself!

I'm trying to understand how I can use the "Row updated" trigger followed by a "Get Row". Then, use a junction(?) to o evaluate if any of 6 columns has had their checkboxes checked which would trigger all eligible child workflows to copy partial data to certain target sheets.

I'm hoping to avoid having to build triggers which monitor those columns specifically and have a bunch of triggers in Bridge, I'd rather use the conditional branching of the parent workflow and monitor it on a row by row basis, the issue is that it's not a binary selection. There are 6 checkboxes and between 1-6 of them could be updated at any trigger instance. Can I have a single junction monitor all the columns or do I need to waterfall out the evaluation and have it check each value one by one with stacked junctions?

Thoughts, ideas and solutions that have worked for you are all very welcome!

Find more posts tagged with

Bridge

Accepted answers

Paul Newcome

If you are trying to limit triggers, I would suggest a helper column in the source sheet with a series of IF statements to output whichever department has been checked off and then trigger off of this. You can then use the string from this column in a series of "Contains" conditional junctions to build out your various paths.

All comments

Paul Newcome

Do you have different actions that need to be built off of the different checkboxes, or is it something where any one of the checkboxes could trigger the same action?

ChrisBarrett

Hey Paul,

Thanks for the response, the actions would be similar but have different endpoints.

Essentially, I have a single Project ID value that I want to copy to one of or several of different departments Intake sheets.

Ideally I'd like the logic to scan the row and say "oh, Dept. A, Dept. B, and Dept. F are involved" and then copy to ID cell value to their intake sheets. So the plan was to use the checkboxes as a kind of filter for who gets the Project ID added to their Intake.

I'm already using Data Mesh to pull the required fields out of this central database to their sheets based on their individual requirements and using the ID as the lookup, but I'm trying to automate the population of the ID on the target sheet.

Paul Newcome

ChrisBarrett

That's a good idea. In my mind I was trying to avoid a series of junctions and have a single junction run the logic, but I think that was wishful thinking! Thank you Paul

Paul Newcome

Sorry. I misunderstood what you were looking for. That's the best way right off that I can think of running it though. I'll think on it a little more and see if I can come up wiht any other ideas for you.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.