I know there is a getRespondentEmail() which retrieves the email id. But if i'm understanding this correctly, it is only when user submits the form then I'll get information through this. Is there a way to get email id when form is loaded for response. Objective is as follows:
1) Get email id when form is loaded for response
2) access a google sheet and filter data based on this email ID
3) provide the filtered list as a drop down for selecting within the form.
This is not possible using Google Forms.
In order to get user information before a user has submitted a form, direct access to the browser session must be retrieved by Google's server before form submission. This isn't done.
Until a form has been submitted by the user, therefore giving explicit permission to submit their responses and email address, no information is communicated to Google's servers and as such the email address can not be retrieved before the user submits their answers.
Users are even prompted that their email will be sent with their responses once they submit if the Collect email addresses checkbox is ticked in the Form Settings, as this is personal information and they need to decide if they wish to send this information or not:
Implementing this would be a privacy issue so I can not forsee Google creating this option in the future either.
I know this may be bad news, but I hope this is helpful to you!
