Is there a way to timestamp a record based upon when a particular field has been modified?

I know that I can automatically update a time field based upon creation or modification of a record, but I want this timestamp to constrain itself to when a specific field has been changed.

We create memos all day long within a record but only periodically

move the record to a different production status. I only want to timestamp the record when the particular field "Status" has been modified.

Any ideas?

Jarvis

Define a new timestamp field and let it auto-enter a calculated value (replacing existing value) =

Let ( trigger = Status ; Get (CurrentTimeStamp) )

Thanks Comment!

That works great.

You just got promoted to my "good guy (& guyette)" list!