Email notification when information has been updated incl the name of the field(s) that have been updated

Ask for Help
1

Hi all,

I have an app where we keep track of our gigs with the band. The form contains fields like name of the gig, date, location, callsheet etc.

As information gets updated by multiple people, I want that an email is sent when something is updated (managed to set this up) but I want that notification mail to also contain the name of the field(s) that were updated (didnt manage to set this up).

Any pointers how to achieve this?

Thx!
Jasper

2

You’d probably need duplicates of each column. Let the user update the original columns, then add something to your flow that compares the originals to the duplicate columns to check for differences, send the email, then updates those duplicate columns with the current data.

1 Like
3

An alternative that I have done is:

  • When going into the form to trigger an update (in my case this is an edit screen), write a JSON of all fields to a column in user profiles.
  • After the edit is submitted, write the JSON above, plus the new JSON that contains the edits, to a logs table.
  • Use JavaScript to figure out which fields are change and print out the keys of those fields.
3 Likes