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,