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...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendnp
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
------------------------------
Brilliant, worked like a charm. Thanks for making it so easy!
------------------------------
COLIN KELLY
------------------------------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
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
------------------------------ What, I believe Mark wanted to suggest is how to use it in Notifications, Automations and Pipeline.
When I wanted to add it into "regular fields" as formula system shows me as below:While for Notification it works fine:
Result in:
------------------------------
Adam Krzyzanek
------------------------------- MarkShnier__You
OK, right. If wanted to record the previous value of a field in a normal field then you would need to set up a pipeline to record that $prev value into a different field.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
