Auto entry on modification for one field, not the entire record.
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