What is an efficient way to determine the most recent modification timestamp across a primary record and all its related records? For example, if the primary record was modified on 11/1/24, and one related record was modified on 11/15/24 while others were modified earlier, I want to automatically id…

Here are some options, in no specific order: you could sort the relationship on modification date descending and grab the first record across that relationship you could use an aggregate formula like this: max ( relatedTableOccurrence::modificationDate ) You could use a transaction when editing ch…

Thank you for the ideas. I was working on the second suggestion already so I will finish that and see how it works. But I like your third suggestion that might work really well.

Be very (very) careful when using "Modified" dates. • Many things can modify a record when you are not expecting it ... e.g., server side script, developer account, imports, if someone adds or removes a space in a field ... all could trigger a standard "modified date" field. • I often use a spec…

Interesting idea and one I might look into in the future. For now I am happy with any change.

+1 @Leish Preserving accurate metadata is hard and often overlooked.

in 21.1 there is a new option on on the Commit Transaction script step to ignore auto-enter calculations. While possibly useful for suppressing mod timestamps in this way, it does apply to all auto enter calculations which is a shame - often times you just want to suppress one or two at a time... F…

[image] weetbicks: The GetField() function without any parameter is triggered when any field in the table is changed Get out of here! How many FileMaker functions have hidden features?

Too true. I did wonder whether the Modification auto-enter option is just a nice front-end display for what is actually underneath it all an auto-enter calc of GetField() ... Another one I saw recently was concerning use of SerialIncrement instead of Right function to pad a number with zeroes... R…

A cheat that I have is for Go to Related Records. You can use it as a layout switcher and search tool. When the layout that you go to is based on the same Layout Table Occurrence ( in other words - same table - not a "related" table ) GTRR will transfer the found set from the current layout.

Finding the most recent modification date of all related records

Questions

bdbd November 19, 2024, 2:27pm 8

You could also split your table in two (or more) tables with one to one relationships to manage the groups of fields that affect timestamps.

Topic		Replies	Views
Ways to find "most recent record" Lounge (Discussions) calculation-engine	5	481	October 8, 2022
How to create a last date modified field for other attribute fields? Questions scripting	1	113	April 29, 2024
How to setup a self-join relationship to show users modified records for the past 30 days? Questions filemaker	9	594	February 20, 2023
Overriding default Modified By (clarisCloud) Questions claris-cloud	4	278	October 20, 2023
Increasing Performance for Complex Join Questions	19	369	March 26, 2024

Finding the most recent modification date of all related records

Related topics