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