AnsweredAssumed Answered

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

Question asked by liyangao on Oct 9, 2013
Latest reply on Oct 16, 2013 by Stephen Huston

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

Outcomes