Bridge Data Copy on checkbox = True help.

Coen

Good morning all!

I've created a Bridge workflow that is supposed to be triggered off of a check box being checked (or flagged as true). This is running off of an expense form I've created.

When I fill out the Expense form, the data I want copied is copied regardless of the check box being flagged or not. Essentially, everything I enter on the form is then copied over to the sheet I set up to receive flagged data.

My bridge trigger is set up to trigger on event type: When Column Values are Changed and pointed at the correct column.

Although none of the expenses above were flagged, they were all migrated to the destination sheet.

Is it possible that to set the trigger to react explicitly to a "true" flag?

Could this be happening because the check boxes for the column do not appear in the column until after I submit the form, therefore being seen as a value change from no value to a "false" value?

any input/suggestions/guidance is greatly appreciated!

tyty!

Genevieve P.

Hi @Coen

Your guess is exactly right! Since the checkboxes don't appear until there's content in the row, Bridge is likely reading the "false" value as a change and triggering the workflow. The trigger is looking for any change, which could also include colour formatting in the cell.

What I would personally do here is add a Get Row module as the very first step of the workflow to get the row that triggered the workflow, using the Runtime Event to reference it:

Then I'd add a Match junction to see if the value in the checkbox column is "True" or "False", simply stopping the Bridge flow if the box is false.

Then you can have the rest of your workflow follow on after the "true" side of the Match junction. There may be another way to do this, but this is what I would do!

I hope it helps,

Genevieve