Come to my devcon presentation, I'll show you how I use it in an Audit Log approach and how I overcome these shortcomings.
- it returns nothing on a new record, only on a changed record
- it does not include globals (usually not a big deal)
Devcon: 10:45 on Thursday
Highly recommend any session Wim presents at Devcon.
That said, it would be nice if FMI could extend the functionality of this function a bit. ;-)
Getting more information from Get ( ModifiedFields ) would be nice, but I empathize with some of FileMaker's decisions to limit the functionality to what it is at the moment. Extending the behavior to records edited in related table occurrences leads to some tricky questions that have been avoided by the way the function is implemented now: If I edit RelatedTable::field1 in one portal row, and RelatedTable::field2 in a different portal row, is it the function's responsibility to communicate enough information for us to know which fields were edited in which records? What would that result look like? If the function does tell us those related fields were edited, but not that different fields were edited in different records, is that misleading in some important way?
Although it is great that Wim is speaking on this subject at Devcon, it would be nice to see the technique or a hint about the technique so that we could discuss it here, now.