Forum Discussion

katlyncowley's avatar
katlyncowley
Qrew Assistant Captain
7 years ago

I want a text field to be populated with the username of who checked a checkbox.

I can't quite figure out how to create the correct formula. I don't need it to be populated by the last modified user (because several people could alter the form during the day), and I don't need it to be the owner because some forms are imported from emails. I need it to be whoever checks this checkbox first. 
  • DavidBrogdon's avatar
    DavidBrogdon
    Qrew Assistant Captain
    You will need to create two fields for this. 1) checkbox  2) text field with edit log enabled  

    Create a form rule that says "whenever checkbox is checked, change the text log to the value "checked"  (i.e. when "myCheckbox" is checked, change "userLog" to the value in "checked"). Keep the option to fire on change only

    This will create a log of entries that will give the user name and a value of "checked" each time the checkbox is checked or rechecked.

    Then, if you just want the first entry, use the list function to slice by ";" 

    Another option would be to create a form rule that changes the text field and makes both fields uneditable once the box is checked, then the text field will only contain the name of the first person to check it. 

    I'm sure there are other methods, this is just off the top of my head.