Creating Google Form Session Sign Up Limits with FormRanger

[@pdotdave]

thanks Jennie. this was super helpful to me. the truth is my son was in a really bad car accident and I just used the guidance of your video to make a sign-up sheet for his hospital visitation. so I guess you never know the positive impact of a helpful video. thanks :-)

[@susanasunarsasi1177]

LOVE IT .... Thanks so much. And by looking the date of this video, suddenly I felt "YOU ARE THE BEST".

[@lomcewan3346]

Thank you so much for your insight! It was exactly what I was looking for! I have volunteers that get to choose which free shows they would like, but we only have a limited number of seats per show. And yes, your formulas are beautiful! Thank you, thank you!

[@audreynowak]

You have no idea how much I love you right now. THANK YOU SO MUCH!!!!

[@Workdancerepeat]

This was very helpful! I've been experimenting all year trying to set up a place for parents to sign up for things in my online classroom and nothing worked. I'm so excited to apply this! #CS!!!!

[@zacharyrubinstein2980]

Thank you so much for this! Even 6 years later this was PERFECT :)

[@KuyaGmack1128]

Could you help me with this? I badly need this one, please message me on facebook my name is Mark Ryan G. Deriada

[@digitalclassroomnc]

Jennie! I love you for unpacking this and WHY haven't I seen this until now. I'm about to use this guidance on a sign-up Google Form for some summer EdTech. Thank you again!

[@johnmaconi4359]

Also, thank you very much for showing how to do this! It is extremely useful.

[@aoconnor1726]

So happy I found this! You really explained everything so well, I understood the "why" of everything I was doing even though I'm not experienced with spreadsheets. Thank you.

[@alondragarcia8436]

Seriously, thank you so much for this video!!

[@reoxnard]

This was so incredibly helpful! Thank you very much!! Your instructions were easy to follow and I feel like I've learned and accomplished something today.

[@fumckidzkonnection6225]

This video was my life saver today! Thank you so much! It worked like a dream :)

[@afifahkhoirunnisa8235]

hi ! i'm from Indonesia. thank you so much for you nice video. i'm so glad . it is useful for my job.

[@heatherbennett2174]

Incredibly helpful! Thank you for sharing your expertise :)

[@jfunkler]

This is amazing and means I don't have to pay $3000 a year for a company to do this for me. This is my first time using formulas other than =SUM so I appreciate the step by step. I also added in John's column so they can't see the full sessions. My form has more than one question. Do I create a separate tab in the response document for each one? Thanks.

[@mixin7ds]

Thank you so much. This is exactly what I was looking for. Great video!

[@rosswolfson9422]

Ooh, that's clever! Well done! (and thanks for the countif lesson too!)

[@ShannanMcPeak]

Hey Jennie great video. Clever reverse manipulation of the process. Can the option be disabled once the limit has been reached? If I understand correctly, this method still allows persistent respondents to submit. Looking forward to your reply.

[@amaliaboccolini]

Una genia! Muchas gracias por tu aporte.

[@liselorimer1864]

Hi, thank you so much for this very useful tool. However, I'm having a problem using this with multiple checkboxes. The counting works if only one box is checked but when multiple "sessions" or boxes are checked they are not counted. Is there another formula that I could use to take this into account? Or do I need to create a column for each "session" or check box?

[@petervangils2651]

This is very clear! Thanks very much!

[@sebas551vable]

Excelente, exactamente lo que necesitaba. Thanks!!!!

[@michellepeterson5241]

These are great instructions, but I wonder if there is a 2016 version; Google Forms and Form Ranger seem to have changed a bit.

[@brandonwhims3713]

i just completed one, what were your problems

[@MiloYellowknee]

Super helpful thank you so much!

[@jimegan4878]

Can this be used for multiple questions on the same form? I'm having a difficult time figuring this out.

[@lorindaallen9590]

SO helpful! Thank you so much!

[@Yousef-ks8vk]

very useful and clear , Thanks a lot

[@kimmiller998]

Thank you, that was really helpful!

[@PatrickVernonElonTeacher]

This was very helpful! Thank you

[@VeraCuberoRedfinedLearning]

Great video! my question is will this work when you have LOTS of sessions? I want to use it for students to sign up for enrichment sessions each day of the week. There will be 20 or so sessions per day. I found that formLimiter was not quite powerful enough and looking for more powerful alternative. Thank you

[@TavaresJorge31]

Hi, great video. This works if a lot of people try to register at the same time ?

[@JayneCJX]

You are a live saver!

[@NlinrushArtt]

omg thanks so much this vdo is really useful!!!! I love you

[@caroleseubert6810]

I got started working on this a couple of nights ago and it looked like the formulas in the sheets were working fine in terms of accepting the formulas. (NOTE: the formranger, however, wasn't updating the form and issuing my session full message.) Came back today and now the sheets are throwing up formula parse errors! Same for the "Revised" column; now it's got parse error messages, too. Pretty darn frustrated!

[@tarawineinger7346]

This is exactly what I need! I have watched the video several times and expression "this form is closed" does not appear in my form. What am I doing wrong?

[@latoyalabine4084]

SUPER HELPFUL!!

[@khanhpham3576]

Hi everyone, can we use formranger to limit options in multiple choice grid ? if no,what we can use or how we can limit options in multiple choice grid? thanks very much for sharing this.

[@stevebonnar]

Brilliant work, easy to follow. Top stuff Jennie Magiera

[@bzyk1975]

This tutorial is awesome, thank you! But... I have a problem. Is there any possibility for user to uncheck chosen option during the form editing?

[@MsiaHotKit]

Thx you so much ! I can do it in my assignment.

[@mcftoamcftoa5010]

When the form is posted and it has reached the limit, the form shows "this date is full please choose another". But this form was the last one to be posted and was able to submit the date. I think this would be confusing to the person submitting the form. How do you correct the form submitted?

[@gauravkumarverma9141]

Nice. I want to add multiple questions with limits to be set.Same form, Multiple sections.Using check boxes(I want one person to choose 3 slots out of 5 in one question and 4 slots out of 9 in the second question). And can we combine the responses of multiple forms in a single spreadsheet with the limits set? Please help me with this.

[@johnmaconi4359]

What happens if the limit is 20 and more than 20 click on the choice at roughly the same time? We are planning on using this for out students to sign up for movies on the last day of school with a 20 student limit for each movie. We are going to send out the link at a specific time later this week and the kids will sign up. If 23 all pick the same movie, does it allow more than the 20 that we set as a limit? If not, how do those who did not click submit fast enough know that they need to sign up for a different choice? Thank you very much if anyone can answer this for me.

[@RiyanKaromah]

Nice share. Thank you very much !!!!

[@justusself-medlin6582]

Hi quick question. I have a google form that after first question using the formranger tutorial you showed takes you to another page inside the google form instead of next page. However, when the form updates, the go to specific page is deleted and all options after selecting the multiple choice go back to default which is next page. Why does that happen and how do I fix it?

[@hlueds00]

I just searched and don't see any add-on called FormRanger?? Was it renamed to something else?

[@3520Blade]

Once a person has typed their name in a timeslot, when someone else opens the form up later in order to add their name, can they accidently change the previous entry? Is there a way to prevent a previous entry from being wiped out?

[@Swimtopian]

That's a great solution to what I am attempting to do. Thanks alot By the way, how can I add a text showing the remaining slots available on each session. Example "Session 1 (2 available)"

[@fredthehippo2037]

i don’t think you can do that

[@davidsookharry8555]

can form ranger be used to find out if a person registered twice then display a message saying so?

[@daveyoung6895]

Thanks for this. Great!

[@ScottHeeke]

Do you know if it is possible to have more than 1 question when using formRanger? I have a teacher who wants to use this for students to sign up for their 6 hours of the day. Can you have a question for hour 1, hour 2, hour 3, hour 4 with math, science, ela, & SS as the options. When the class reaches 30, I want to close that class for that hour. All the examples I've seen only have 1 question.

[@Salmonluni]

Did you ever happen to figure out a way to use form ranger with more than one question on a form?

[@KevinBoutelle]

I use this and have multiple session times. So there are 4 session times (4 questions) each session time just needs its own tab on the response spreadsheet so that you can set up that question properly.

[@3ace846]

what about for grid choices?

[@majanielsen2014]

Hello! I was wondering if anyone could advise?! My set formulas are glitching and some of my options are not counting responses.I make sure to check and double check that formulas are set for each option but for some reason not all will work. Any ideas how to avoid this issue? Thank you!

[@filbertteckchea591]

is there any way to do it via Google Forms itself and not through a spreadsheet?

[@Useheart]

When i choose "This session is full, please choose another" then submit, Why the data (respons) is still saved?

[@ibagusraharjo]

and how do i inactivate those "full session option" because the bullet is still optionable?

[@lightvsdark21]

Just use form ranger and choice eliminator in conjunction with each other.

[@lisanewcomer4672]

So I used this method last year for a workshop registration and it worked great. We re-used it for this year's registration, which just opened today, and there are some issues with it, now. We have checked Refresh Questions on form submit option for all of the sessions for which our students can register, but this year, we're getting an problem when more than one student attempts to register for a class that closes when the first student submits - the registration line for the remaining student(s) attempting to register for the now-full class are blank for that option. Last year the student was returned to the form to re-select another option. Has anyone else encountered this issue?

[@mcftoamcftoa5010]

Did you find a fix for this problem. ?

[@Nique-1012]

Does anyone know a way to do this on Microsoft Forms

[@mid-atlanticdistrictofthea5378]

Hy Jennie, is there a way that when a person signs for a session with a limit of one person per session her/his name will show up instead of "choose another, session is full"

[@JenniferMagiera]

That would be quite challenging as you won't be able to predict which row their response would come into so would have to do a complicated VLOOKUP or other formula. Perhaps instead you could use Calendar Appointment Slots? support.google.com/calendar/answer/190998?hl=en

[@sesima6037]

Hi, I did everything as the video shown, but after selecting the sheet, the data is not loading on the screen. Anybody knows why?

[@srithanandha2951]

THANK YOU VERY MUCH

[@JenniferHarperCTFAC]

formRanger is not popping up in my Add-ons on Google Sheets. How else can I find it/

[@ckchrisw]

+Jennifer Harper CT FAC Go to the creator's site "New Visions Cloud Lab", go to formRanger, and follow the link provided under the subsection titled "Installation". Within the page in the installation link, there should be a blue button labelled "+ FREE" on the top right. Click that and BAM!

[@elisaakachucrut]

Thanks!

[@Younglord7]

Thank you