Restrict Google Form Participants with These Two Options

Google Forms makes collecting information easy, but sometimes you don’t want everyone to be able to fill out your form. Have you ever wanted to set restrictions on who could complete your Google Form? There are multiple ways of accomplishing this and the above video will walk you through two different options.
For more information, visit www.thegooru.c...

[@lewisbrown6161]

Great tutorial. Thank you. 5 years later and Google still hasn't added a built-in feature to limit access to Form Submissions...

[@dilanweera7775]

I spent two days to find this solution! Thank you so much!!!

[@NoraPizzino-ou4rh]

This worked for me up until a year ago, and now the concatenate formula seems not to be recognized in my google form. I see the banner that says these options will only work with the old version of google forms. Is there still a way to use the old version of google forms? Or is there a new way to make this work in new google forms?

[@MJ-4life]

Thank you so much for this tutorial. There’s no way I could have figured this out on my own.

[@hassanmaje5849]

What happens if a Student ID is repeated in a subsequent submission? How do you ensure that there is only one submission per Student ID?

[@erikscherer8880]

Thank you so much for this! I am helping to organize a Mock Election and we are going to give students the choice between voting online vs. a drop-off ballot. A teacher was concerned about people possibly voting twice. I think I can take the people who sign up for a paper ballot with their email and use that info to prevent them from participating in the online ballot as well. I'm sure there are other hacks, but this is great to know for the concern we have. Thank you!

[@icingand5680]

oooooh. how did your mock elections go? because we're in the same boat

[@shameelgoldentrio2928]

Hey man, I think you need a more individual specific key. I myself have four different email ID

[@kidsmile00]

The password does not correspond to certain user or column. So as long as I have one of the passwords, I can submit the form. Is it possible to make the entry correspond to certain user with certain password? Thanks

[@theresadelong508]

I love this! However, my student ID list is over 1000. Do you happen to know the maximum number of IDs that I could validate?

[@isarayyanmd]

Did you try it?

[@trpizinth]

Great tutorial. Is there a way for me to restrict certain users (identified by name or contact number) from completing the google form? like a blacklist list?

[@mayalee763]

This video was so helpful! Thank you very much for posting.

[@tapomoychakraborty2880]

How should I use this in new version?

[@hassanabdulsalam9923]

Thank you very much. But I see that the same ID number can be use twice if the person has two gmail addresses

[@adminpti8329]

Can someone post his CONCATENATE formula?

[@carl92.]

Fabulous. Thank you so much.

[@dainmal]

i am not able to find advance setting

[@jennivu3137]

Super helpful! Thank you!!!

[@ihmgoacampusplacement6038]

I managed to do this, however in Excel 2010, when I want to do this for about 300 students, however beyond 40 students this doesnt happen

[@srinivasanradhakrishnan913]

Anyone can enter another's ID & enter. So, can we restrict the access of the form itself? Yes, we have that restrict to organization option, can we restrict further to particular accounts?

[@bharathaladi]

Very useful tips. Thanks.

[@ChrisBeardsley]

Great stuff! Thanks for posting

[@mariatheresayataza137]

Hi, but what if we have a lot of ID numbers, and it will make an nvalue already? how can we restrict out participants?

[@Sumitconsultant]

Thanks for posting this video. very useful

[@nzenkem6346]

How do I limit the student to only login with his/her ID number only once for that particular form? this way, the student can only login one time

[@trailerempire7330]

HELLO, is there a way google forms validation can restrict a number from been entered more than once??

[@christopherlong8459]

There appears to be a character limit now when you paste from the spreadsheet. Last year this process worked with 1700+ ID numbers (12663 characters), now I hit a limit after 6217 characters. Anyone know of a workaround?

[@SymbolsLtd]

I have been trying to do same and it is not accepting the characters

[@delroydemontagnac9697]

Is it me or is this really blurry???

[@WoxyBot]

Hey, what type of question did you use for the student ID number?

[@MarioRBlock]

I have the same issue and I can´t found a solution. If you have more than 1000 ids you should use another solution. If someone found a good one I really appreciate it. Thanks

[@sakhrbanikhaled608]

Thank you so much. Really it's very helpful

[@carmenjr.stangota1383]

this is awesome THANK YOU!

[@febasm8914]

The same thing is not working when I did🙁, why?

[@lashawnjohnson9278]

How can I keep users from editing the form when submitting information?

[@somayyahiremath2975]

please explain the concatenation formula again

[@eunicehong6116]

Thanks so much! Sooo helpful!

[@iqbalmahmud9197]

i cant find this format...how to do it?

[@bryandeitherluza2962]

thank you so much. and now I have an idea. I found out that my student fake his identity in my google form just to see the question to look and prepare the answers and I was looking for more secure way to identify them besides than their name and gmail. thank you so much

[@jeneishmodi3553]

One question: Basically will i be informed that what password the user have entered as shown in the video i.e if student A has entered 123456 will it be shown

[@amigosdocarro4600]

In the first, does each student have specific ID?

[@湘薐王]

Thanks! It helps a lot!

[@jaguandebruno]

It doesnt work for me? I dont know what i am doing wrong?

[@salkin43]

Excellent stuff!

[@shivammahajan1991]

You really solved my big issue. Thanks !

[@ANOOPKUMAR-rn7dm]

can this student ID be unique or non repetitive ?

[@robinsonpp010]

Helped a lot, thanks

[@tariqmahmood3120]

Thank you So much

[@norzunico]

Thx soo much. Thisnis seriously helpful

[@delroydemontagnac9697]

Is there a way to restrict access to specific candidates to selecting specific options/ from a list?

[@ethanganes9266]

Hi there! Have you managed to find an answer so far?

[@phaichonmanosaen4316]

This is superb

[@yonluis3143]

are you limited to how many ID # you can enter?

[@artcre8academy541]

It helps me in my online voting

[@wrightdesigns9405]

Perfection!

[@FANISITE]

I really love you man

[@artcre8academy541]

We need the CODE

[@stillX2]

Me Too, You really solved my big issue. Thanks

[@annamritaa9003]

How it do now

[@elizam.775]

this is what i'm looking for....thank you

[@iqbalmahmud9197]

is it working?

[@eliza3405]

No, as long as they have one of the passwords, they can submit the form

[@delinquense]

Great ... make a password that is shared. OR give everyone their own password ... that they can't change because you created and controlled the password process. And passwords are in the clear. Something that looks so promising, like Google Forms/Google Sheets integration, ends up less than useless. I often think that the IT world is going backwards at times when I see stuff like this.

[@kaydeediego]

Hey, I can't find the option for advanced settings for questions

[@JunaidAhmed-cz7sr]

response validation

[@somayyahiremath2975]

done thanks

[@lalitpatil4731]

Not working for my form😔😔😔 Help me...

[@chrisber]

Dude you are actually a god! :D

[@sisisobrinoalvarez8612]

Is there a way in which we can limit the Google form to be filled out by only the owner of the form? I created a system to take attendance using QR codes through a Google form on a spreadsheet, but I need. The Google form to be filled out only use in my use your name as a teacher, is there a way in which I can do that?

[@HalcyonHavoc8221]

Yes. In the sharing settings (collaborators) make sure you are the only one in the field. When they try opening the QR code, they will be required permission.

[@sisisobrinoalvarez8612]

Wency Guerrero Hi there, I tried doing what you said but it didn’t work. Any other suggestion? Thanks!

[@HalcyonHavoc8221]

@@sisisobrinoalvarez8612 Hi, so sorry. I replicated it using my personal email and it seems it will only work if you have a paid G-suite. I was using my work account that is why it was giving me that option.

[@cupidlsu]

Wow - that's maddeningly insecure. All you have to do is right click on the form and hit inspect, and you'll get all the acceptable fields. :(

[@kpoplovers92]

hi could you explain which part did you mean as maddeningly insecure. I like to try to follow the tips in this video but i am very bad at formula. so if you have other way to set up user id, a good explanation or tutorial would be a great help to me. thanks in advance!

[@cupidlsu]

@@kpoplovers92 The part where this method transmits the list of acceptable passwords in the html code when the user opens the form.

[@ellenchua105]

Hi, may I know why i can't restrict Google Form Participants after trying the first method?

[@ellenchua105]

1. create a new response sheet 2. key in the id 3. set the formula 4. in the response expression, click match and copy the formula from the last id row in the pattern but still can't work😟

[@coachkaryme]

Hello, excellent video. Thanks. But is there a way to restrict some specific emails or mails that are from other schools? To avoid copy my form. For example restrict: [e-mail], all the emails that contain @school.com. Is this possible? I really appreciate if you can help me.