Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

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

Recommended Posts

Posted

I have a field that I need to record when it is modified. When I use Date Modified, it records whenever anything is modified on the record. Can someone provide help so I can record when the specific field, only, is modified?

TIA

Posted

I gave this a try and it should work. Create a field:

FieldModDate (calculation, date ,stored,indexed) =

Case(

not IsEmpty(FIELD), Status(CurrentDate),

Status(CurrentDate))

The idea is that the result of the calculation doesn't depend upon the value of FIELD, but changing the value of FIELD will cause the stored calculation to update. The only downside is that if you modify FIELD by retyping the same value already in the field, the date will still update.

To change the date only when a different value is entered, it is necessary to create a second hidden field, compare the value to the previous value and update the date modified field if the value is different. This requires controlling access to the field and using scripts to update the value (and the date).

-bd

This topic is 8698 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
×
×
  • Create New...

Important Information

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