Automatically update a field every time I look at the record

Discussion created by dpirera on Jul 8, 2012
Latest reply on Jul 8, 2012 by BruceRobertson



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.