I'd like to have a checkbox that, when checked by a user, fills out a 'user' field with the person that checked it.
I tried doing it with a rule that changes the value of a user field with the current user when the checkbox = checked. But obviously when the form is updated, the value changes...
I'm not a code wizard, so please help if you can!
Will this solve the problem: if somebody else edits the form then saves it while this checkbox is checked, it will change the value of the user field?
I should clarify what I'm actually trying to do. I'm essentially just trying to create an electronic signature, so somebody can 'approve' the form, and have the form record who approved it.
I suggest using a Text Multiple choice field with choices like Approved and Approval Withdrawn and Rejected.
Set that field to log the changes, so that the field will log the Who, the date and the value of the change.
Then use a formula to parse out from the most recent update the field.
Here are the three formuals to extract out the value, the date and the name of who did the update.
Most recent value (formula text field type)
Trim(Right([my update field],"]"))
Date of most recent update (this needs to be a formula date field)
ToDate(Left(Right([my update field],"["),9))
Who did the most recent update (formula text field type)
Trim(NotLeft(Left(Right([my update field],"["),"]"),9))