Skip to main content
Question

Using an old value when a pipeline is triggered

  • September 27, 2022
  • 0 replies
  • 242 views
GeorgeBramhall2
Forum|alt.badge.img+11
I saw this solution somewhere but don't remember. How do I use an old value of a field in the record that is triggering a pipeline? I want to put the old value in a new field sort of the way a snap shot works but I am don't want to use a look up field as the source of the old data.

------------------------------
George Bramhall
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+24
    Here are my cheat notes on that
    {{a.$prev.est_start_date}}

    take the regular version and insert the $prev

     Let's say field 10 is a text field called Status, then the correct syntax in the trigger query would be:

    {'{{a.$prev.status}}' .EX. 'Value'}


    https://community.quickbase.com/communities/community-home/digestviewer/viewthread?GroupId=103&MessageKey=657fdac9-9fd0-4a73-9a40-05c46e8fab09&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer

    {{a.$prev.est_start_date}}



    But then this thread says that you cannot use prev in a query expression.

    https://community.quickbase.com/communities/community-home/digestviewer/viewthread?MessageKey=b2947263-9f0c-4fe9-a2b5-095725d3aceb&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer#bmb2947263-9f0c-4fe9-a2b5-095725d3aceb


    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    Mark Shnier. Your Quickbase Coach
      Terms & ConditionsAccessibility statement