Context: In old forms I had a rule that that would WRITE the old status to a log field when the user CHANGED the status of a transaction. (e.g. New to Complete, New to Hold, etc.). This was achieved by using a dynamic form rule triggered on the field value change upon SAVE.
Additional Note: Thanks to @Mark Shnier (Your Quickbase Coach) post about "$prev." in Jinja I know we can do it there in a pipeline - but that isn't a desirable method.
Possible Work Around in New Forms: Use the old form or create a pipeline on record save and use $prev. I tried playing around with New Forms rules formula builder - but still seem to lack a way to access the OLD Field Value and an Action trigger.
Wasn't there some way to access an old field value within a formula so that I could use the New Form rules formula builder to create a boolean for [Status] <> [old.Status] as a trigger?
------------------------------
joe vandervest
------------------------------
