Pipelines filtering with a boolean/checkbox?

Question

I'm creating a record (B) when another record (A) is updated.

But not every time (A) is updated, just when field Transform (a checkbox) changes from unchecked to checked.
I need a filter for this.
How can I express "checked" ?  Should the pipeline say
Transform is True, Yes, or 1?    (there's no drop down for "checked")
And do I also need to add to the filter that Transform is Set?
I don't want the pipeline to run every time it sees the Transform checkbox is checked after the record is updated in any way, but rather to run only when the current modification includes the Transform checkbox changing from unchecked to checked.

------------------------------Charlotte Morin------------------------------

ChayceDuncan · Answer

Based on your commentary I imagine you're using the new Pipeline builder in which case set the value to "Yes".

As to the second question - when your pipeline executes you will want to include/set some other field that shows that you've already processed it. That might look like adding another checkbox in record (A) that is something like "Transformed". After you create the record in B - you would then update (A) and check that box off. That field should then also be used as a filter when your pipeline is triggered so essentially the filter is where Transform = Yes and Transformed = No

------------------------------
Chayce Duncan
------------------------------

Sign up

Login to the community