I have started to use the audit log function from Nightwing Enterprises as a really easy way to record the changes that occur in a record. It works superbly with one exception. It does not record changes made from a replace field contents command.

This seems to be because fmp does not provide the function through Get( ActiveFieldName )with the current information before proceeding with carrying out the remaining steps:

It cannot compare the state of the field currently from what was in the field originally, because it doesn't know yet what field is being activated.

My question is therefore how does the replace command differ from simply moving out of a field in terms of capturing Get( ActiveFieldName )?

Or can anyone fix the function to record the replace field contents operation?

I attach my test file.

Thank you for taking the time...

This excellent function is available free from www.nightwing.com.au/FileMaker

test.zip

Since I don't have Filemaker Advanced, I can't see what is in the Custom function. So, I can't help you there. But, some time back, I came up with a different method which doesn't require custom functions or scripts. It's in the Samples Area Here:

http://fmforums.com/forum/showtopic.php?tid/153729/

It correctly logs changes made with both the "Replace Field Contents..." command and the "Find/Replace" command.