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

Question

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

markshnier__you · Answer

I believe the delayed March release replicates old value and new value from Automatons into pipelines.&nbsp; 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&nbsp;previous value of a field from a trigger&nbsp;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 ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

evanmartinez · Answer

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

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

That is a great question Mark, let me ask around and see if we have anything set up to explain the syntax yet.------------------------------Evan MartinezCommunity Marketing ManagerQuickbase------------------------------

evanmartinez · Answer

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 MartinezCommunity Marketing ManagerQuickbase------------------------------

Forum Discussion

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