Creating a Field that will have the latest modficiation timestamp from all related fields

[geraldh]

Hello,

 

I have an events management database.

 

I have a list of Events records in list view, in a layout I call "Event Search" and I wish to sort these according to the most recent that have been modified (or even better, according to most recently visited).

 

The problem is there is a large quantity and deep network of related child records associated with an Event record. I wish to get the most recent modification timestamp from ALL the related records (from tables such as Estimates, Estimate Lines, Planning Document Lines, and more!).

 

I've thought about this various ways:

 

1) A related table with a field that is updated/calculated anytime a related record is updated

2) A script that populates a timestamp field in the Event record anytime a related record is visited.

 

I have a "Google" like search in this Event Search layout, that will allow users to quickly narrow their search.

 

It is working well and I am willing to give up on this endeavour if it is too complicated or taxing for the database; but it would be nice to have the Events sorted with the most recently visited/modified on the top of the list. And this would mean somehow getting a field to capture the most recent modified timestamp from the potentially hundreds of child records.

 

Any suggestions would be much appreciated.

 

 

 

[Ocean West]

A script that inserts the results of this?

And some artfully placed script triggers.

 

 

stampModify is a field in each table that is set to add modification TimeStamp

perhaps a server side script that will daily update this field with the same calc?

Max ( List ( Events::stampModify ; Estimates::stampModify ; EstimateLines::stampModify ; PlanningDocumentLines::stampModify ) )

[geraldh]

Thank you!

I will try this and try and make this work.

 

All best