Forum Discussion

MrunaliKadam's avatar
MrunaliKadam
Qrew Trainee
3 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 modified.

We would like to include the only fields which were modified with the before/after field values in the email body. Is there any way to do this?

------------------------------
Mrunali Kadam
------------------------------
  • 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
      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
        Icon for Qrew Legend rankQrew Legend
        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
        ------------------------------