Hello folks,

 

 

Please forgive me if this topic is the wrong place.

 

My problem is this:

 

I have a customers database that stores data like: name, address, taxing number, etc...

 

I have a field that is an auto enter calculation that registers who created the record using a simple "Get ( AccountName )".

 

I would like to register who edited the record for the last time, or if possible create a log of dates and who edited the record.

 

Can you please show me how to achieve this?

 

Thanks,

Are you still using v6 or have you updated to a newer vesion?

 

Is your current edition of FileMaker “Client” if you have updated?

Edited November 23, 201312 yr by Lee Smith
add edition

You might want to do this search on Google for Audit and Field Modification.

Are you still using v6 or have you updated to a newer vesion?

 

Is your current edition of FileMaker “Client” if you have updated?

I am using FM 11...

Create two fields in your table ModifiedBy and ModificationTimestamp. In Layout Setup, attach an OnRecordCommit script trigger and point it to this script

 

Set Field[ModifiedBy; Get(AccountName)]

Set Field[ModificationTimestamp; Get(CurrentTimestamp)]

 

If you want to keep a log, create a log table.  Add the following steps to the script:

 

Set Variable[$RecID; YourIDfield]

Go To Layout ["LogTableLayout"]

New Record/Request

Set Field[LogTable::LoggedID; $RecID]

Set Field[LogTable::ModifiedBy; Get(AccountName)]

Set Field[LogTable::ModificationTimestamp; Get(CurrentTimestamp)]

Go To  Layout[Original Layout]

Hello Doughemi,

 

Thanks, it solved my problem.

 

Many thanks!