5 Replies Latest reply on Oct 16, 2013 4:27 PM by Stephen Huston

    How to automatically record the date/time for evaluation in FileMaker?

    liyangao

      I have a database with an evaluation form. I would like to insert the evaluation time automatically instead of entering the date manually. I do have a trigger field with Yes or No option for completing the evalution. How do I define a field to record the date/time when the trigger field was checked Yes?

       

      I defined a calculation filed AutoDate=case(trigger="Yes"; get(CurrentDate); trigger="No";""; "") without recalculation.

       

      Is this the right way to do it? Or is there a better way to do it?

       

      Thank you for your response,

      Liyan