How can i make a time stamp field automatically update based on when i change the value of another field.

 

For example lets say i had a field called Ticket Number.

 

Can i have a mother timestamp field automatically capture the time and date i changes that Ticket Number field? I want this time stamp to be its own separate field though and not inside the Ticket number field itself.

 

Thanks guys!

 

Erik

Hi Erik,

 

All you need is to reference the TicketNumber in the new Tmestamp field so the calculation evaluates if the TicketNumber changes.

 

Create your new Timestamp field and set an auto-enter calculation with:

 

Case ( TicketNumber ; Get ( CurrentTimeStamp ) ; Get ( CurrentTimeStamp ) )

 

... and uncheck 'do not evaluate if all referenced fields are empty in the calculation dialog.

 

Back at the auto-enter calculation, uncheck 'do not replace existing value....'

 

* only do the part in blue if you want it to fill in when the record is created even if TicketNumber is left empty.  If you want the timestamp to remain empty until a value is actually entered, leave it checked.

Edited April 11, 201411 yr by LaRetta

Thanks! It works! 

Erik