Forum Discussion

Qrew Member

4 years ago

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

I have a pipeline that updates a related field based on new data that is entered. I was wondering if there was a way for me to to keep the original data for tracking purposes. I saw that placing $prev...

Pipelines

SeanConnaughto1

Qrew Cadet

4 years ago

You could do something like this:

{%- set audit_list = [("field one name" ,a.fieldone, a.$prev.fieldone),("field two name" ,a.fieldtwo, a.$prev.fieldtwo),("field three name" ,a.fieldthree, a.$prev.fieldthree)] -%}

{% for i in audit_list -%}
{% if i[1] != i[2] %}
Field Changed: {{i[0]}}
--- New Value: {{i[1]}}
--- Old Value: {{i[2]}}

{% endif %}
{%- endfor %}

------------------------------
Sean Connaughton
------------------------------