Forum Discussion
- MarkShnier__YouQrew Legend
You have two options. One option is to use a native email notification with default settings. Then QuickBase will natively tell you which fields changed and only the fields that changed.
The other option which is not quite what you want is that in an email notification you can you syntax like this
The status changed from [old.status] to [status].
That will tell you the old value and the new value but you have no way of only outputting text for what changed. So for all the fields that did not change the old status on the new status will be the same.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- MrunaliKadamQrew TraineeThank you for the response Mark!
We were thinking of one other option but not sure if that would create any new issues and would like to know your thoughts on this.
If we create a new form with the specific fields the user wants to track and use that form link in the notification. we can create a formula fields for those selected specific fields and formula will copy original field value in this new formula field and then use these formula fields in the new form. So when user updates main form, values will get copied to the new form.
------------------------------
Mrunali Kadam
------------------------------- MarkShnier__YouQrew LegendInteresting thought but I did a test and the choice of forms does not affect the default behavior of showing which fields changed.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------