Modified by vs. Created by

[Aaron Bratcher]

I know that I can create a text field and auto-enter a calculation. (In my case it's get(UserName)) How do I auto-enter on modify only? I want to a field that shows who last modified the record.

[Inky Phil]

Aaron

go to

http://www.fmforums.com/threads/showflat...true#Post126013

where you will be able to download a demo that might help

HTH

Phil

[Lee Smith]

Check out the Audit File being discussed in the Sample File Area of this Forum, by BobWeaver (there are more than one), as the recent title suggests, he has posted other FileMaker versions besides v7. Also,

Also, others have suggested or submitted sample for tracking field modifications. Do a search as follows:

Search = [color:"blue"] All Fields

Keywords = [color:"blue"] +Audit +file or [color:"blue"] +Field +Modific (be sure to include the plus sign as shown)

Weeks = [color:"blue"] 0

HTH

Lee

[Walter B]

You can create a text field (last mod by?) and then under Auto Enter the very first option is a series of selections including, Creator Name, and Modifier Name. In my FMP 7 development I am using audit trails to track record modification. On the other hand, in v 6 development, I always created fields for Creator Name, Date, and Time, and Modifier Name, Date, and Time. This solution doesn't tell all the modifications that have been made to the record, but, it does tell you the last modification made.

Hope this helps,