I'm fairly sure this is a calculation, but I'm not sure if it's possible. I am building a finance company's processing database. I need to show a timestamp in one field, when there's a change made in another (any change). For example: a user changes the disposition of a loan from Pending to Approved (set up as a value list, pull down menu). Once the user takes that action, a field labeled "Date of Disposition Change" automatically timestamps when that change was made. Then, I will have a field where they can put in their username to mark who did it (which I think I can do automatically, but that's for v.2).

Anyone have a solution for this? Thanks!

FileMaker Version: 7

Platform: Mac OS X Panther

For your field called "Date of Disposition Change" set the...

Type: to Timestamp: and in the Options check the Modification: Timestamp (Date and Time).

This will automatically create a timestamp for any change made to the record.

Use a "NameModify" field to capture the modifier's name.

Type: to Text: and in the Options check the Modification: Name.

Reminder: If any change has been made to the record both will autmatically update once the record is exited.

FileMaker Version: 5.5

Platform: Windows XP

MarkWilson said:

For your field called "Date of Disposition Change" set the...

Type: to Timestamp: and in the Options check the Modification: Timestamp (Date and Time).

This will automatically create a timestamp for any change made to the record.

Use a "NameModify" field to capture the modifier's name.

Type: to Text: and in the Options check the Modification: Name.

Reminder: If any change has been made to the record both will autmatically update once the record is exited.

Thanks for the info, but that's the problem. I only want to record changes made to specific fields within a record, not the entire record. If someone modifies some other information, it will change the disposition date, and that would be bad, because those mods could be made after the actual disposition date change. Any advice?

FileMaker Version: 7

Platform: Mac OS X Panther

Case( fieldA or fieldB or fieldC, Get(CurrentTimeStamp), Get(CurrentTimeStamp) )

will update only when fieldA, B, or C is changed.

Do not set it to be unstored.