Discussions

 View Only
  • 1.  Pipelines - Compare two fields in action

    Posted 08-04-2020 17:34
    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
    ------------------------------


  • 2.  RE: Pipelines - Compare two fields in action

    Posted 08-04-2020 18:47
    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
    ------------------------------



  • 3.  RE: Pipelines - Compare two fields in action

    Posted 11-28-2022 16:39
    Edited by Lloyd Hinzman 11-28-2022 16:39

    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
    ------------------------------



  • 4.  RE: Pipelines - Compare two fields in action

    Posted 11-28-2022 17:07
    Thanks for sharing Lloyd , I would have taken hours to figure the FID syntax itself

    ------------------------------
    Prashant Maheshwari
    ------------------------------