Jump to content
Sign in to follow this  
dmeyer

Timestamp of another field's modification date?

Recommended Posts

Hello,

Is there a way to have a field automatically timestamp itself when another field in the same table is modified?

Something like:

Field1 <- user modifies the value in this field

Field1ModDate <- automatically stamps itself to track when Field1 was last updated.

Thanks

Share this post


Link to post
Share on other sites

Hi dmeyer,

There are a few ways; here are two:

1) Make your Field1ModDate a standard timestamp field. In Options, set it to auto-enter by calculation:

[color:blue]Case ( field1 ; Get ( CurrentTimeStamp ) ; Get ( CurrentTimeStamp ) )

Back at the auto-enter tab, uncheck below calculation where it says 'Do Not Replace Existing Value...'

2) just make it a calculation instead using above calc.

LaRetta

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
    jarvphot 
×

Important Information

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