Pipeline Query Trigger On Change From Specific Value

Question

I'm trying to set up a pipeline that will trigger when a Status field changes from "Inactive" to any other value. All I've been able to find is this thread from several years ago, that I can't respond to at this point: Pipelines - how to look at original value and new value of field?

I have attempted two versions, {a.$prev_Status}='Inactive' and {a.$prev.Status}='Inactive'. Neither triggered when I updated a record.

I have included a screenshot of my trigger setup, any idea what I'm doing wrong or another way to get the result I'm after?

------------------------------Amy Christensen------------------------------

MarkShnierYou · Answer

I don't think that approach will work. I think that you will need to create a field to hold the previous status and initialize it with the value of the current status. The easiest way to do that is to make a formula field equal to the status and then change it to be a data entry field.

Then you will need to have a pipeline to maintain the previous status value by firing whenever the status changes and writing out the previous status with syntax similar to what you posted.

Then you will have a pipeline trigger on status change and will be able to have two solid fields to compare, the [Status] and the [Previous Status] fields in your table.

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community