Forum Discussion

MrunaliKadam's avatar
MrunaliKadam
Qrew Trainee
2 years ago

How to include the only fields which were modified on the form with the before/after field values in the email body

I've a notification which triggers when some specific fields on the form changes. Current functionality does not show the field changes in the email body so it's difficult to identify what was really ...
NotificationsEmail
MarkShnier__You's avatar
MarkShnier__You
Qrew Champion
2 years ago

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
------------------------------
  • MrunaliKadam's avatar
    MrunaliKadam
    Qrew Trainee
    2 years ago
    Thank 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__You's avatar
      MarkShnier__You
      Qrew Champion
      2 years ago
      Interesting 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
      ------------------------------
      • MrunaliKadam's avatar
        MrunaliKadam
        Qrew Trainee
        2 years ago
        yeah, right! This will only help to limit the count of fields we need to show in the email body. This form is pretty big so instead of showing 1000+ fields, the new form will show the specific fields.

        ------------------------------
        Mrunali Kadam
        ------------------------------