Discussions

Expand all | Collapse all

Pipelines - how to look at original value and new value of field?

  • 1.  Pipelines - how to look at original value and new value of field?

    Posted 03-15-2021 12:07
    Is there a way in pipelines to set this condition?

    If Record is modified, trigger on Field A and
     Original value of Field A = xxx and New value of Field A = yyy

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


  • 2.  RE: Pipelines - how to look at original value and new value of field?

    Posted 03-15-2021 12:18
    I believe the delayed March release replicates old value and new value from Automatons into pipelines.  They have not yet announced the revised March Release date after it was pulled from Sunday yesterday.

    https://help.quickbase.com/release-notes/march-2021-release-notes.html

    Pipelines

    Enhancements for the Quickbase channel

    With this release, two highly requested features that simplify the process of building powerful and complex workflows are now available:

    • You can take the previous value of a field from a trigger and analyze both the original and the new value when a record is updated. Then you can compare the difference between the two values or track the change.



    Mark

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



  • 3.  RE: Pipelines - how to look at original value and new value of field?

    Posted 03-18-2021 10:56
    Mark is correct that functionality to pull old values will be coming to Pipelines and the March release did get rescheduled. It was pushed back to March 21st after our pre-release testing detected an issue that needed to be resolved. If you want to keep up to date on our release and other service announcements you can follow us on our Status page.

    ------------------------------
    Evan Martinez
    Community Marketing Manager
    Quickbase
    ------------------------------



  • 4.  RE: Pipelines - how to look at original value and new value of field?

    Posted 03-18-2021 12:35
    Edited by Mark Shnier (YQC) 09-02-2021 09:43
    I believe that the Sunday release will allow you to specify the previous value but you have to edit the jinja code yourself.  Apparently the drag and drop is coming later.

    its something like changing
    {a.my_field_name} to
    {a.prev_my field_name}

    or maybe it was
    {a.$prev_my field_name}

    I don't see that documented in the release notes. Maybe Evan we will see this post and ask what the syntax is.

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



  • 5.  RE: Pipelines - how to look at original value and new value of field?

    Posted 03-18-2021 13:04
    That is a great question Mark, let me ask around and see if we have anything set up to explain the syntax yet.

    ------------------------------
    Evan Martinez
    Community Marketing Manager
    Quickbase
    ------------------------------



  • 6.  RE: Pipelines - how to look at original value and new value of field?

    Posted 03-22-2021 13:35
    I wanted to circle back after I had a chance to check in on what they syntax would be. You would want to use:

    {{a.$prev.est_start_date}}

    if your field was start date, so Mark's second example was correct.

    ------------------------------
    Evan Martinez
    Community Marketing Manager
    Quickbase
    ------------------------------



  • 7.  RE: Pipelines - how to look at original value and new value of field?

    Posted 03-22-2021 13:44
    .. thx Evan, the way I saw it demoed, you drag the field the usual way and then hand edit it to insert the $prev

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



  • 8.  RE: Pipelines - how to look at original value and new value of field?

    Posted 03-22-2021 14:01
    That is correct Mark, that is they way you would do it right now though I expect it might get a tweak in the near future.

    ------------------------------
    Evan Martinez
    Community Marketing Manager
    Quickbase
    ------------------------------



  • 9.  RE: Pipelines - how to look at original value and new value of field?

    Posted 07-30-2021 10:47
    Did the syntax on this ever get settled?

    ------------------------------
    Melissa Doran
    ------------------------------



  • 10.  RE: Pipelines - how to look at original value and new value of field?

    Posted 07-30-2021 11:07
    The information in this thread is still current.

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



  • 11.  RE: Pipelines - how to look at original value and new value of field?

    Posted 09-02-2021 08:58
    Is there a demo of this pipeline anywhere that I can watch or see? I need to build one for my app.  Please and thanks!
    Melissa

    ------------------------------
    Melissa Freel
    ------------------------------