2 Replies Latest reply on May 28, 2015 1:12 PM by simonbucknall

    Setting an OriginalDate field to retain the first date the Date field was set to

    simonbucknall

      Title

      Setting an OriginalDate field to retain the first date the Date field was set to

      Post

       

      Hi,

       

       

      I'm wondering if anyone could help as to the best way to accomplish this 'simple' task as i'm struggling with it at the moment. I am new to FileMaker and databases in general so please forgive my ignorance

      I have a table of service visits in the database in building at the moment with two fields, on called 'Date' and the second called 'OrigonalDate'

      I would like the OrigonalDate field to capture the Date field contents if the Date field is changed so we can always retain the first date we set for a service visit. If the date field is subsequently changed again then the OriginalDate field would remain unchanged.

      I have tried to do this in the table field calculation so it is changed at the table level as opposed a script trigger to fill the table.

      Many thanks in advance for any advice 

      Simon