Skip to main content
Question

Pipelines - Compare two fields in action

  • August 4, 2020
  • 0 replies
  • 145 views
Forum|alt.badge.img+14
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
------------------------------

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------
Mark Shnier. Your Quickbase Coach
Forum|alt.badge.img+1
  • PaulHinzman
  • Registered
  • November 28, 2022

Use the Advanced query option to compare the field IDs.  Note the entry of the second field follows the '_fid_' format.

Field A = field id 425
Field B = field id 426

{'425'.GT.'_fid_426'}



------------------------------
Lloyd Hinzman
------------------------------
Terms & ConditionsAccessibility statement