I want to find a way to automatically find out who responded to my form (I am using Forms for quizzing and surveying students).
Is there any way to disallow the form from being filled out unless the user is logged in?
Given they are logged in, can I somehow get their Google username or Gmail address automatically through a script?
In addition, if they are logged in, can I make sure that they can only edit their own response, and not submit multiple ones? Right now, editing your response is only possible if you remember the link to your personal response.
Luckily, the Form Limiter Add-on allows you to set a limit to how many people can respond to a Form so you don't have to worry about turning anyone away. Simply set the number of attendees you can accept and Form Limiter will disable the form when the desired number of respondents has been met.
Meaning, you can designate specific people you want to complete the form with the use of a student ID, for example. This is done by creating an expression in the responses spreadsheet. Once you've identified people you want to fill out your form, you can create an identification column.
Google forms do not generally have a direct way to prevent someone completing a form. Anyone who has the link will be able to complete it. If you are a paid G-suite user (business /education etc) you can set the form to require an email address from inside that domain.
I believe everything is handled by the google form. In the top part of the form there is an option to make sure that the person who is answering is logged. And it's in the same place that there is the option to collect the username
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With