Sending an email with record changes?
We are currently using accounts and calculations to lock changes out of certain records. It works perfectly, no complaints.
I have some records though that I would like to keep modifiable by another user, but I would like to specify an email address that Filemaker notifies when changes are made to the record.
The catch is that I would like to know which fields have been changed.
I have looked into this a bit and know I can modify an OnRecordCommit script to send an email that could say something like "This record has changed" if the contents of the "Notify" field are not empty, but I don't see the capability to include which fields have changed.