1 Reply Latest reply on Dec 13, 2013 5:05 PM by Stephen Huston

    modification date not updating


      I have a field that is set to Auto-enter modification date. When I update any fields on the layout the modification date is updated, but if I add or edit a related record in a portal on that same layout the modification date is not updated. Is this normal Filemaker behavior? We just recently upgraded from FMP11 to FMP12 and I thought the mod date updated in FMP11 when I edited a portal record.

        • 1. Re: modification date not updating
          Stephen Huston

          Yes, this is normal expected behavior. Auto-enter Modification date is for the table in which that field exists only.


          You could set a script trigger, rather than an auto-entered mod date, having the script set the date of the max value of the current record and any of his child records as the record in commited. This is often much more what the user expects, but it takes some work by the developer.


          You may even need a Commit Record script step with flush cache, a short pause and then test for the largest date in the record/related-records set to use in updating your custom modDate field.