Modification Date based on change in a field?

[Barker]

Anyway to have a timestamp field change automatically by modification of a given field? (without using a script...)

[J__]

calculated field might be one way to do it.

ex:

create a field called customer_name [text]

Create a calculated field changed_time [calculated field] - make sure you set the return type to "DateTimeStamp" at the bottom of the calculation field editor dialog.

for the calculation something like this:

if ( IsEmpty ( customer_name ) = false ; Get ( currentTimeStamp ) ; "" )

so, if your user types something in customer_name field, the date time stamp of when they made this change will be displayed in the changed_time field, if the field is blank, then "" is returned, displaying nothing.

each time you change the customer_name field, the date time will update.

sounds kind of what you were looking for.

hope that helps,

sincerely,

J__

[BobWeaver]

You can use an auto-enter calculation field. With version 7 you can use this formula:

Evaluate(Quote(Get(CurrentTimestamp)); customer_name)

You can expand this easily to monitor a group of fields too. Example:

Evaluate(Quote(Get(CurrentTimestamp)); [customer_name; customer_address; customer_phone])

[Miko]

does anyone know how you would do this in version 6? i really need to show the modification date and time of about a handful of fields on a layout.

thanks,

LImore

[BobWeaver]

For version 6 and earlier, you can use a calculation field with this formula:

Case(Field1+Field2+Field3,Status(CurrentDate),Status(CurrentDate))

where Field1, Field2 etc., are the fields you want to monitor.

[J__]

Hi Bob,

That's pretty cool. Thanks for the tip!

J__