Filemaker Record Modidified Field

Posted on 2014-07-14
Last Modified: 2014-07-14
I know you can create a TimeStamp field for record modification. Is there a way to create a field that sets to '1' if the record (any field) has been modified.
I was thinking maybe of a way of utilizing the TimeStamp field when a record is modified.
I do not want to do this using script triggers. I would like to do it using either a auto-enter field or calculation field.
Question by:PachecoPrimo
    LVL 24

    Expert Comment

    by:Will Loving
    You can also create a Timestamp field for record creation, then create a calculation field that compares the Creation Timestamp with the Modification TimeStamp and yields a value of "1".

    Author Comment

    Hi Will,
    The thing is that records will be modified multiple times (for example on a daily basis, weekly basis), so the modify timestamp is going to change multiple times and this is exactly what I need to capture.
    LVL 24

    Accepted Solution

    OK, that a bit different than what you originally asked for. It sounds like you want an audit trail of who modified what when, is that correct. There are a couple of ways to do this:

    1) The traditional way is to use a Custom Function (which requires FileMaker Advanced to be installed) and a couple of fields to capture the modifications. There is a detailed description and example file at:

    2) A new way, made available recently by the addition of the Get( ModifiedFields ) function in FileMaker 13 is described here:   This also requires a Custom Function.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
    Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now