Pipelines - Compare two fields in action

Question

Is it possible to compare two fields as a condition for a pipeline action? For example:

When record is updated; trigger on field A, condition: Field A>Field B

It looks like I can only make a condition such as Field > 0, or some set value?

My work around is to then search records in the same table as the action, where the record ID matches and then set my condition.

Is this the only way?

------------------------------
Mike Tamoush
------------------------------

markshnier__you · Answer

The low tech cheat is to make a formula field in native Quick Base called like [Field A >Field B]

Then use that in the pipeline and a checkbox boolean filter. No doubt there is Jinja syntax which will do this, but lower tech is to do it in native Quick Base.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

lloydhinzman · Answer

Use the Advanced query option to compare the field IDs.&nbsp; Note the entry of the second field follows the '_fid_' format.
Field A = field id 425Field B = field id 426
{'425'.GT.'_fid_426'}
------------------------------Lloyd Hinzman------------------------------

prashantmaheshw · Answer

Thanks for sharing Lloyd , I would have taken hours to figure the FID syntax itself------------------------------Prashant Maheshwari------------------------------

Forum Discussion

Pipelines - Compare two fields in action

Related Content

Multi-Select Fields with Commas in Pipelines

Three Words of Advice on Pipelines

Jinja Expression Comparing Now to Now+Hours

Pipeline Not Triggering

Snapshot Fields