Forum Discussion

MichaelTamoush's avatar
MichaelTamoush
Qrew Captain
5 years ago

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

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 ------------------------------ ...
Pipelines
EvanMartinez's avatar
EvanMartinez
Moderator
5 years ago
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
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
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
------------------------------
  • EvanMartinez's avatar
    EvanMartinez
    Moderator
    5 years ago
    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
    ------------------------------
    • EvanMartinez's avatar
      EvanMartinez
      Moderator
      5 years ago
      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
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        5 years ago
        .. 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
        ------------------------------