Field Modification Date

[McGoo]

Is there any way that I can monitor when a specific field is altered. I have a a text field in my system that is a withdrawl flag and removes them from being included in a script that collates all the entries made on the system. Unfortunately I am finding that a specific user is withdrawing them after this script has been run and is saying that the record had been withdrawn and should never have been included. Unfortunately other sections of the record are being constantly updated so I can not use a standard modification date field.

Can I define a field that will only enter a date when this specific field has been modified.

Thanks

Sean

[Lee Smith]

Hi Sean,

As you might suspect, this topic has been discussed in the past. I sure if you do a find for Field Modification or Audit Trail, you will find plenty of information. Also, you can download these files for examples of how to do it.

Audit History of Fields Rick Knight

http://www.fmforums.com

Comprehensive Audit Tracking System Ray J. Cologon

http://www.nightwing.com.au/FileMaker/

Field Modification John Mark Osborne

http://www.fmfiles.com/tnt4.html

Field Modification Tracker Bob Cusick

http://www.fmfiles.com/tnt2.html

Modification Times Alberto Diaz-Hermidas

http://www.fmfiles.com/tnt2.html

Tracking Modifications Steve Wilmes

http://www.fmfiles.com/tnt2.html

HTH

Lee

[zincb]

1. Create a calculated numeric field, SERIAL = status(CurrentRecordID)

2. Create a calculated numeric field, MATCH = case(IsEmpty(YourField),SERIAL, SERIAL)

3. Create a self-join relationship, SELF~JOIN~MATCH, based on MATCH

4. Duplicate the field you want monitored, YourField, and rename the new field to YourField_Old

5. Change the properties of YourField_Old to be a lookup, via the SELF~JOIN~MATCH, of YourField

6. Create a text field, LOG

7. Create a calculated text field, CHANGES = "On " & DateToText (Status(CurrentDate)) & ", at " & TimeToText(Status(CurrentTime)) & ", " & Status(CurrentUserName) & " changed the field " & "YourField"

& "