Jump to content

Showing a timestamp when changing a field?


This topic is 6504 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

  • Newbies

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 6504 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.