John,



Look into the DoSQL plugin from MyFMbutler. They've got a couple of templates for audit logging for field-by-field changes. It might fit for what you are looking for.



Regards,

Salman



------Original Message------

From: John Wenmeekers

Sender: FileMaker Pro Discussions

To: FileMaker Pro Discussions

ReplyTo: FileMaker Pro Discussions

Subject: Keeping track of changes

Sent: May 24, 2011 6:11 PM



Hi all,



I need a way to keep track of changes made in an application.



The final goal is to have a list with dates and (probably) recordsIDs of

changes made in each table in an application.



To be clear, an audit log is not enough.

The final goal is to see how many records were changed on day basis.



Out of that we can then calculate several date ranges and qty of records

changed.

How many records changed compared to the total records, etc.



Or even show it in portals, filtered on date or on whatever other item field.

Also generate reports with totals.



Any hint where and how to start ?



TIA