1 of 1 people found this helpful
There may be script trigger on the layout, onRecordLoad or something that change the record data.
Where would I look for such things? Layout setup? I am used to a much older version.
In Layout mode, click on the pencil next to the layout name at top left:
This will open the Layout Setup dialog where you can select the Script Triggers panel:
Notice, too, the little scroll symbol at the bottom right corner of the layout—this indicates the presence of a layout script trigger.
The script activated on this layout contains just two Set Field steps. This indicates a shortcoming of the Modification Timestamp—it responds to ANY modification, even if nothing is actually changed (e.g. if you cut the contents of a field, then pasted the same contents back), so in actual fact gives you little useful information. It merely says something was done, but gives no indication as to what.
This has been an issue every since I started using FM. I wound up using a hidden field that I combine all the data that I need to track if changed and comparing it to the data that there. and then setting my mod info only if doesn't match. Because when checking for expired records it would always flag every record as modified.
Quite so. If you really want to track what gets changed when, you need a proper audit trail system. Ray Cologon has provided a very good one which you can download as a demo at:
In this case no audit trail need just need a list of the records changed so the mailing list at the main office could be updated usually less than 6 records.
Also there was no computer at the main office at the time.
Same issue is still with FTS Advanced 15. It seems that it's not purposefully made by FileMaker because people who are not familiar with script triggers may find this unexpected behavior. If someone goes through the first example file and do the first exercise step by step, the result is different in the example file than in tutorial. Maybe this should be labeled as a bug in FTS.