2 Replies Latest reply on Feb 5, 2014 1:23 PM by schmity

    Auto entry on modification for one field, not the entire record.

    schmity

      Title

      Auto entry on modification for one field, not the entire record.

      Post

           Is it possible to set a script or someway to automate the entry of the persons username into a field  based on the modification of another field. I am using file maker authentication.

           I'm doing vacation requests, and there is an approved field (Yes or No) and an approved by field.  I would like it to automatically enter the username of the person who selects Yes or No in the approved field into the approved by field.

           I've done auto enter on creation & modification like this, but want it to reflect the change only for that field, not the whole record