Hi,

I am a FileMaker novice, just picking this up in my free time at college. I have a database that generates paperwork and prints the into reports. 

I would like to be able to, before printing a report, to see if there were changes/modifications to specific fields within, for example, the last hour, and if there were changes to the field within the last hour these changes could have some conditional formatting where they change color (or something else to note that these have changed recently)

I have looked into conditional formatting but cannot find a way to check for fields that have changed recently.

Thank you in advance

Filemaker does not keep track of when individual fields have been modified, only entire records. So if you want this, you will need to create your own mechanism - say by attaching a script trigger to each field you want to track, and make the script enter the modification into some sort of a log. Then you can use conditional formatting to look into the log's contents to see if the specific record::field has had an entry within the last hour.

 

Note however:

1. Modifying a field is a provisional event: it will become permanent only if and when a record is committed. If a field has been modified, and the record subsequently reverted, then the log will contain an incorrect entry.
2. Script triggers are layout-specific; a script attached to a field on one layout will not fire when the same field is modified through another layout (or even through another instance of the same field on the same layout).

Thank you so much for the information.

 

I ended up using a custom function and some conditional formatting I used http://www.briandunning.com/cf/1703 amdhttp://www.briandunning.com/cf/1704 for the 2 custom functions