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?


      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,