Forum Discussion

COLINKELLY's avatar
COLINKELLY
Qrew Member
11 months ago

Change Notification with Old and New Values

Greetings, all -

I'm in search of a way to track and notify users when a the data in a field changes. As an example, I'd like to send an automated notification when the name of a project is changed. In the notification, it would include the original project name along with the new one.

Any ideas on how to most easily do this?

Thanks!
Colin



------------------------------
COLIN KELLY
------------------------------

6 Replies

  • np

    the syntax for referring to the old value in a field is this

    Project Name changed from [old.Project Name] to [Project Name] 

    just prefix the field name with old. Inside the [Square Brackets]



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • COLINKELLY's avatar
      COLINKELLY
      Qrew Member

      Brilliant, worked like a charm. Thanks for making it so easy!



      ------------------------------
      COLIN KELLY
      ------------------------------
    • JohnRoss3's avatar
      JohnRoss3
      Qrew Member

      Mark

      Does the "old" syntax really work on regular fields?  I thought that it only worked in Pipelines, i.e.  {{a.$prev.fieldname}}



      ------------------------------
      John Ross
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend

        From pretty much the beginning of time you could refer to the old value in a notification, as that is functionality that is like 20 years old.

        Then we got automations and I'm pretty sure and automations there was a way to refer to the old value.  

        Then we got Pipelines and I think they had to replicate the functionality in Automations.



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