Forum Discussion

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 ...

NotificationsEmail

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

Qrew Legend

3 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
Qrew Trainee
3 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
------------------------------