Time modified?

[ibiubu]

A text field with a auto entry for time modified shows the time that any field in a record is modified. But is there a way to make it also do this:

In the same record if a change is made to a portal item, the time modified does not change. I assume this is because the auto entry time modified function only looks at any field changes that reside in the record, thus any changes made to a portal field will not cause the time modified to change.

Is there a way to have my cake and eat it too. To have the field with the time modified to update any time a change is made to a record fiels AND any time a change is made to the portal in that same record.

LR

[CobaltSky]

Given that the related records are in a portal, there can be quite a few on them, so the modification time will be different for each related record.

One way around this would be to have a time modified field in the related file as well as in the main file, and then add an unstored calculation field (result set to time) in the main file, with the formula set to:

Max(ModificationTime, Max(RelatedFile::ModificationTime)).

The calculation will return the most recent modification time stored from either the current record or any of the related records.

[ibiubu]

Ray,

I am not interested so much in the fact that each record in the portal can have a different time associated with it. What I am looking for is to keep my stored / indexed time field that would display the last time the record was modified, whether it be a field in the record or a portal row.

I am also trying to do it without a script or relationship. In other words, is there any type of field that I can include in my layout that will automatically change when a change is made to the portal. And because this field changes, the stored Time modified field will update.

I tried doing something like creating a field that used Count(relatedfile::field). If a new portal row was added then the number in this field would change. But this number changing did not trigger the time field to update.

LR