How can I show the name or email address for responses to form survey in the results spreadsheet? We want to see each other's responses but results sheets seem to be anonymous and only show time stamps of responses, but no identifier.
- In the top right hand corner of the screen, click the gear/cog icon to enter Settings:
- Next, tick the box next to the option Collect email addresses:
- Click Save.
1works like a charm!– xeroMay 24, 2021 at 21:36
You would need to create a field asking for a name or email address from the respondents.
Google Forms provides an Email validation if you want to an email address field.
- Select "text" for question type
- Click "Advanced Settings"
- Check "Data Validation"
- Select "Text" and "Email Address"
Google Workspace users have an option in Google Forms to automatically record the email-address of the respondent but it's is limited to users of the same domain as the form owner 1.
One option is to enable the option for collection email-address. This will add a question where the user should type an email-address.
Another option is to add a question asking for the name of the respondent or any other information to identify them properly.
1: View & manage form responses - Docs editors help
One way is to add a name/email-id field at the start of your survey. This helps identifying the responses.