4 Replies Latest reply on Jul 8, 2012 5:33 PM by BruceRobertson

    Automatically update a field every time I look at the record

    dpirera

      HI,

       

      I am relatively new to scripting and ask for a some help.

       

      I have two fields in Filemaker:

       

      Field 1: Date Signed

      Field 2: Years, Months, Days and hours elapsed since signing

       

      I would like Field 2 to automatically update every time i look at the record (or at the very least every time I open the database).

       

      The database is very simple and tiny (measuring 50 or so people working in about 30 locations and will not expand much larger than that so there is no real concern if the script is a little weighty or having to be executed every time a record is browsed).

       

      Any assitance would be greatly appreciated.

       

      Regards,

      Dean