Very, very helpful! One drawback I've discovered - it turns out that replacing a session with "This session is full..." still allows the user to select that option! However, if the replacement is nothing (if(C2 < D2, B2, ) then that selection drops out of the list! Works much better for my application.
That's a really good point, Mirrormere. Thanks for sharing! What I've been doing with that recently is using the replacement text to place individuals on a waiting list.
I can't thank you enough for this! My company and I were in quite a snafu trying to figure out how best to do a sign up with session limits for over 700 people, and this came to my rescue. Thank you, thank you, thank you!
Thank you for creating this. I logged in today to use an old addon that is no longer available and had a small panic attack. Our Math Department uses Google Forms to create a Proctoring Sign Up for Online students that have to come in and take a Proctored Midterm and Final Exam. I was volunteered for that position. Gotta love updates! :) But seriously! You just saved me!!
This worked perfectly! My only hitch has having more questions than you did on the demo, so the column I needed from the Form Response sheet was column F instead of B, so it didn't calculate/count my responses correctly. But as soon as I walked through the process really comparing columns, I realized my issue, corrected it and it works perfectly. VERY easy to follow steps. **For those that might have issue starting Form Ranger, I installed, then had to refresh my browser for it to actually start. THANK YOU!
Thank you so much for this video. We were able to use this concept for our library's program registrations so we could limit the number of people who could register for each specific program. This worked perfectly!
Thanks a lot! Super useful tips. I was thinking that this is not possible at Google Forms, and searched Google just casually without much hope. Then I found this video and it is a life saver. Great appreciation for JP.
Thank you very much for this tutorial sir. It really helped me a lot especially in creating a Google Form - Enrollment Form which will be used in our school for our Online Enrollment. Thanks a lot!
wow! you did an amazing job indeed. I was stuck and your video made my project possible. Thanks a lot for taking your time to explain this to the world.
Hi! I have 2 questions on my Form, one is How many people are going to attend and the other one is to which session. How can I set a limit to a specific amount of people to a session that they choose in the other question? Do I have to make another sheet on the spreadsheet? What are the formulas that I have to use? Thanks
I followed the instruction video, but it didn't quite meet our needs. Our students have to choose three options out of nine options in total. After submitting their choices all three chosen options are put in one cell in the Google sheets response Spreadsheet (for example: Option 1, Option 4, Option 9). The Countif statement in the FormRanger tab doesn’t work, because it counts unique data in a cell in the Response Spreadsheet and we have a total of three chosen options in one cell, which can differ per student. What I did was, I changed the formula shown in the video and added the following command to the formula: =COUNTIF('FormResponses'!$C$2:$C;CONCATENATE("*";B2;"*")). I wanted to use the command CONTAINS at first, but CONCATENATE proved to be a better option. What the formula does is that it checks in the Response spreadsheet, in the column containing the chosen options, how often the value in cell B2 in the FormRange appears and adds them up. (B2: Name of the first option in the FormRange tab. In total we have nine rows (B2 to B10) because there are nine options to choose from.) From here is works the same as shown in the video. I also adapted the formula in the column ‘Revised Session name’ in the FormRanger tab. Instead of just saying that all places are taken, I added the name of the option to the text using a reference to the cell with the name of the option. (For the first option the cell is B2.): =IF(C2
This worked for the first item, but though the worksheet updated the second item as "My text.....", the option still could be chosen on the form. Can you please help? Edit - Actually, only the first choice, whichever it is, gets the "My Text...", all other choices can be chose multiple times.
This is a little different than the version i used last year and even though it required adding a new worksheet and a few formulas I think it's actually easier than the version I used last time. Thanks for the video it was great!!!
Thank you. The solution works however it requires the Form Ranger to keep running in the background. Else some changes dont reflect until we open the form and run the add on again
Hi there, thank you so much for this! I am trying to set up a form where interns can select the time slots they want to work per week. I have a question set up per each day of the week, all with 5 options for different time slots. They can basically select as many as they want. However, when I look at the sheet under each "session" where I am supposed to see a count, it does not count time slots that were selected if others were selected for that same session. So, if they selected "Monday 10-11" AND "Monday 11-12," these are not being counted. Would you happen to know why or how to make it count these selections?
JP Prezzavento, I have a quick question. Is it possible to add some simple HTML to the form text when it displays that the event is full (using it for wait list registrations) ? I'd like to be able to say "=if(C2>7, "Class is FULL. Register for the Wait List.", B2)" but when I tried that, it showed the bold tag as just regular text, and didn't interpret that as HTML formatting. Any ideas on how I could accomplish that? Thanks so much!
Thank you for your video. This is for multiple choice question. I would like to ask if we can use form ranger to limit responses for checkboxes? Please let me know. Thanks so much.
It kind of worked for me, however it is not updating to "Full" in real time. I did put to update with every form submission. However, it only updated one response. I checked and the formula was carried over to each cell on the sheet. I have no idea how to fix it.
When you have more than one values list in your form, where do you type the other names in the give this values list a name? It's at time 6:00 in your video, you only listed session one. Thanks this is very helpful!
does this only work for multiple choice questions? I'm working on a form for one checkbox question and the formRanger sheet isn't populating accordingly....
hi sir, how if the add ons can't work when selected, this also applies to the add ons called "limit form", I've tried on 2 different accounts, the results are the same
So I did this. I need to use the form weekly tho. So I deleted my rows that were used. I went to form and deleted all responses. So basically a brad new form. Now none of my responses will come over to the google sheet. they just stay in the google form responses.
Thank you so much for the video. I’ve a query, I tried doing exactly the same, but in my case only Session 1 changes to revised session name, but session 2 & 3 still counts after the limit and doesn’t changes to revised session name in the form. Could you give me instructions how to fix that?
It there a way to include a date option so that the answer selection once it has meet the limit value it will not be there until the time limit expires.
Hello. I would like to ask a question for a similar topic. Is there any way for restricting people from giving the same answer to two subsequent multiple choice questions? I would need this restriction for every pair of questions. Thank you very much for your time.
I have been trying to figure out if there is a way to stop a question from being answered once a certain value is selected. I am currently using two questions; 1. Unit #, 2. a Multi Choice Question with 40 rows and 4 columns. The 4 columns are Not Ready, Not Started, WIP, and Done. Whenever a row is Done I don"t want to answer that Row again. Ideally I would like to just have the data show up when anyone types that unit number again but short of that I don't need to update anything that is already Done...Any ideas?
Hi there, it is a good video on the limiting for the number allocated for each item. But how do you reset it back like a library system where someone borrowed the book and wants to return it back. Is there any formula to do so so that after the book was taken away and returning it to the system?? Need some valuable help here..... Thanks.
Hello! Thanks for this. Can you try if there's an update that happened as of this year? The for ranger no longer applies to all of the sessions I put in the column. It only works on the first row. :(
This is a great tutorial! I'm having an issue though that I think is related to the FormRanger....I have images uploaded in my google form that go with some of the answer choices, and they keep disappearing. I also have time slots listed as answer options, and they keep reverting to military time. Help???
Hello, thank you for useful video. Is it possible somehow set the automatic update? FEx. I have lesson Thu 9am and Fri 9am and wanna have limit 15 people, than after it will happen I would like to renew it again from 0, is it possible? Or should I only do it somehow manually? Hope you are still answering :)
Hi this is great. However how would I restrict the actual capacity i 5 dates to choose from max people for each date is 6 but his could be 1 people bringing another 5 or 6 different people booking to come on their own?
Hopefully someone has an answer to my question. I need to limit how many people sign up for sessions but I also need to only have one session open at a time. Once session 1 is full, I need session 2 to open, when session 2 is full then session 3 would open. I have two separate regions that I need to create. One region has two sessions, the other region has three sessions. I am still playing with how to open a session after another is full. Would appreciate any advice.
thank you for sharing this! I followed the instructions to the T, however, when I do the first formula, it always shows the #name? message. I copied and pasted so there shouldn't be an error with the name. What could be causing this?
This is amazing! Very useful. Just wanna ask, after setup finished and i wanna change the limit session do i need to start up again? Or just change in spreadsheet and it still working?
You can adjust the session limits in your spreadsheet as you need to. If changing the session limit will close that session, you will want to go into the add-on and refresh it. Thanks for your watching!
Hi, Thank you for the tutorial. It is indeed very helpful! I have situation and would love to hear your opinion. I tried to limit each option to 1, but when multiple people open the form at the same time, the form will show all choices (because the 1st person has not submit the form yet). The problem i found is all of them can still choose the same option and submit and does not show error. Do you have any idea how I can solve this?
I have followed all of the steps but once I get to the last part to set the populate options, I can not find my spread sheet. Does anyone know how to fix this issue?
I need to ask you something about the form. I did this form,. and i have to limit with 2 check boxes , but when the people submit the answer, the two selected check box passes to a single cell, so it doesn't count
This will only work with a drop-down list or multiple choice question because the text in the cell must be exactly the same as the text used in the countif formula. Sorry for any confusion. Feel free to reach out on Twitter @jpprezz if you want to chat more about this.
Hi, Quick question. I am a PE teacher and doing this for student to pick an elective and I have max numbers were activity. I followed the directions and am good up to the near end where it says name the values list. I know I have to do this 3 times for my 3 activities but how do I get more than 1 option? It says give the value list a name but there is only room for 1 name. Do I add my first activity and then go back somehow and add my 2nd one? Or is there a way for it do this all at once? I did my value list for my first activity and it works... I have a cap at 20 students and it does say to pick another activity this one is closed, but I don't have that for the other two
So I can getting the sheet to read "This activity is full" but when I am on the form it only says that for the first of 3 activities that they can choose from
When I start formranger after following the steps on the google sheets, i don't get an option for select by values---only select range. I can't seem to get select by values?
In my form, it starts with the responder having to choose one of two types of classes (adult and children's class). Choosing the adult selection will take the person to one section of the form and choosing the children's class will take them to another section. I set up the spreadsheet for it to limit the responses for the adult class choices . How can I set it up for the children's class choices? Do I create another tab in the spreadsheet? Thanks!
Very, very helpful video! does anyone know how can we set a rule like this with two conditions? I have 5 intervals of time and for each one the maximum of people is 14, for each day. Can i ad a question with date and for each day to apply the rule with the maximum people that can register for each interval of time?
How can we restrict selection of a check box. Eg. Option A Option B Option c(none) When we click none other 2 ahould be disabled automatically... Pls. Help. Out
This was extremely helpful. We have one problem still. When we go back into our document and add the formranger, the questions we need to limit (a dropdown checkbox list of classes we need to set limits on for students to sign up) will not show up in the questions list on the form ranger menu. Does that make sense? Can someone help?
you have to add them in. he's using an older version of the form (this video was made in 2017). so the form ranger has updated since then. He does the same thing. It doesn't say "new values list" it just asks you to add them. So the formranger looks different. now the options are "New range" when you click the plus sign. after you go through the process, of selecting (following his directions above) then they'll show up.
Very clear explanation! :) However, although my response spreadsheet reflects accordingly when session is full, the google form does not update concurrently. What went wrong?
Each "this session is no longer available" message has to be slightly different, or it will only update one answer option. When I typed "session 1 is no longer available" "Session 2 is no longer available" etc., it updated correctly.
may i ask something? after the choices are eliminated from our form. can we change it to a simple sentence(not a question) in the places that where the choices are belong? and not a choices again? you hope you understand what i'm saying..
You can change it to a statement; however, the radio button will remain on the form. This is explained starting at 3:26 of the video. I hope that helps!
Can anyone help me with app script for limiting response for session per multiple-choice item in the google form? example session 1 option 1 (limit response 10) option 2 (limit response 8) Its urgent please help me
So, I did this, and my formula works. It shows on my spreadsheet that it is working. It doesn't show up on my form though. On my form, it's still giving me the original two options. Any idea why?
Very, very helpful! One drawback I've discovered - it turns out that replacing a session with "This session is full..." still allows the user to select that option! However, if the replacement is nothing (if(C2 < D2, B2, ) then that selection drops out of the list! Works much better for my application.
That's a really good point, Mirrormere. Thanks for sharing! What I've been doing with that recently is using the replacement text to place individuals on a waiting list.
JP Prezzavento that’s a great idea too!
I noticed this as well. Thanks for the tip!
yeah me too..but any suggestion so that the session still there but we make the button not work to push?
@@ramfatullah Another video suggested using drop-downs instead of buttons; that way, the choice should disappear
I can't thank you enough for this! My company and I were in quite a snafu trying to figure out how best to do a sign up with session limits for over 700 people, and this came to my rescue. Thank you, thank you, thank you!
Thank you for creating this. I logged in today to use an old addon that is no longer available and had a small panic attack. Our Math Department uses Google Forms to create a Proctoring Sign Up for Online students that have to come in and take a Proctored Midterm and Final Exam. I was volunteered for that position. Gotta love updates! :)
But seriously! You just saved me!!
This worked perfectly! My only hitch has having more questions than you did on the demo, so the column I needed from the Form Response sheet was column F instead of B, so it didn't calculate/count my responses correctly. But as soon as I walked through the process really comparing columns, I realized my issue, corrected it and it works perfectly. VERY easy to follow steps. **For those that might have issue starting Form Ranger, I installed, then had to refresh my browser for it to actually start. THANK YOU!
Thank you so much for this video. We were able to use this concept for our library's program registrations so we could limit the number of people who could register for each specific program. This worked perfectly!
Such a helpful, clear video. I could not believe it worked when I did it! Thank you very much for taking the time to show people how to make it work.
Thanks for the comment, JoAnna! I'm so glad I could help.
Thanks a lot! Super useful tips. I was thinking that this is not possible at Google Forms, and searched Google just casually without much hope. Then I found this video and it is a life saver. Great appreciation for JP.
This is the best video I have found explaining FormRanger! Thank You!
I used this add-on to display information of seats available of a course. Very useful add-on.
Hello, I followed the steps but the "Session Count" does not update when a user enters data. Has someone had a similar issue. Please help
Can't thank you enough for this! You made it so clear and easy.
Thank you very much for this tutorial sir. It really helped me a lot especially in creating a Google Form - Enrollment Form which will be used in our school for our Online Enrollment. Thanks a lot!
Thank you so so much. I was looking for a thing like this and you save my life ! Just follow every step of you and then it worked!!!!
wow! you did an amazing job indeed. I was stuck and your video made my project possible. Thanks a lot for taking your time to explain this to the world.
Thaaank you so much for this very clear and easy tutorial. This was exactly what I needed!
Hi! I have 2 questions on my Form, one is How many people are going to attend and the other one is to which session. How can I set a limit to a specific amount of people to a session that they choose in the other question? Do I have to make another sheet on the spreadsheet? What are the formulas that I have to use? Thanks
You just completely made my day! Thanks for such a quick, simple and easy to follow tutorial.
And you just made my day with your kind comment. :-)
I followed the instruction video, but it didn't quite meet our needs.
Our students have to choose three options out of nine options in total.
After submitting their choices all three chosen options are put in one cell in the Google sheets response Spreadsheet (for example: Option 1, Option 4, Option 9).
The Countif statement in the FormRanger tab doesn’t work, because it counts unique data in a cell in the Response Spreadsheet and we have a total of three chosen options in one cell, which can differ per student.
What I did was, I changed the formula shown in the video and added the following command to the formula:
=COUNTIF('FormResponses'!$C$2:$C;CONCATENATE("*";B2;"*")).
I wanted to use the command CONTAINS at first, but CONCATENATE proved to be a better option.
What the formula does is that it checks in the Response spreadsheet, in the column containing the chosen options, how often the value in cell B2 in the FormRange appears and adds them up.
(B2: Name of the first option in the FormRange tab. In total we have nine rows (B2 to B10) because there are nine options to choose from.)
From here is works the same as shown in the video.
I also adapted the formula in the column ‘Revised Session name’ in the FormRanger tab.
Instead of just saying that all places are taken, I added the name of the option to the text using a reference to the cell with the name of the option. (For the first option the cell is B2.):
=IF(C2
Thank you so much. This is exactly what I need for the checkbox instead multiply choice. Great Job!
This worked for the first item, but though the worksheet updated the second item as "My text.....", the option still could be chosen on the form. Can you please help?
Edit - Actually, only the first choice, whichever it is, gets the "My Text...", all other choices can be chose multiple times.
OMG! Thank you!!! Saved me soooo much time and makes me feel so versatile at work.
Nice video. One input tho, please enlarge/zoom, instead having full desktop estate. Kind of hard to see
Absolutely brilliant, thank you so much, please add the date option if possible that would be the icing on the cake. Thanks so much so helpful
This is very helpful!!!!!!!!!!!!!!!
This was a lifesaver
Thank you so much for this...
Very helpful. Thanks bud
This is a little different than the version i used last year and even though it required adding a new worksheet and a few formulas I think it's actually easier than the version I used last time. Thanks for the video it was great!!!
I did all you show here, all correct, but then when I answer the form the count number rest at 0 and form ranger doesn't work.
Thank you. The solution works however it requires the Form Ranger to keep running in the background. Else some changes dont reflect until we open the form and run the add on again
Hi there, thank you so much for this! I am trying to set up a form where interns can select the time slots they want to work per week. I have a question set up per each day of the week, all with 5 options for different time slots. They can basically select as many as they want. However, when I look at the sheet under each "session" where I am supposed to see a count, it does not count time slots that were selected if others were selected for that same session. So, if they selected "Monday 10-11" AND "Monday 11-12," these are not being counted. Would you happen to know why or how to make it count these selections?
thanks , but how to apply all that to session 2&3 as well as??
SO helpful! Thank you so much
JP Prezzavento, I have a quick question. Is it possible to add some simple HTML to the form text when it displays that the event is full (using it for wait list registrations) ? I'd like to be able to say "=if(C2>7, "Class is FULL. Register for the Wait List.", B2)" but when I tried that, it showed the bold tag as just regular text, and didn't interpret that as HTML formatting. Any ideas on how I could accomplish that? Thanks so much!
Thank you for your video. This is for multiple choice question. I would like to ask if we can use form ranger to limit responses for checkboxes? Please let me know. Thanks so much.
It kind of worked for me, however it is not updating to "Full" in real time. I did put to update with every form submission. However, it only updated one response. I checked and the formula was carried over to each cell on the sheet. I have no idea how to fix it.
This was so helpful! But after you test your form, how do you erase your test submission to allow room for other submissions? Thanks!
When you have more than one values list in your form, where do you type the other names in the give this values list a name? It's at time 6:00 in your video, you only listed session one.
Thanks this is very helpful!
Extremely Helpful! Thanks!
Great Tutorial.
What if I have sections? Lat say I want to have 3 sections and 5 sessions within each sections. Does the same formula applies? Tqia
why forms sometimes do not auto-update even though we have enabled auto-repopulate on form submit & every hour
does this only work for multiple choice questions? I'm working on a form for one checkbox question and the formRanger sheet isn't populating accordingly....
hi sir, how if the add ons can't work when selected, this also applies to the add ons called "limit form", I've tried on 2 different accounts, the results are the same
When I select Form Ranger from add ons I only get the Help option. Not Start. What am I doing wrong?
For some reason my counter is not working. I triple checked my countif statement and it is identical as I used all the same coloms. Help!
amazing, thanks
So I did this. I need to use the form weekly tho. So I deleted my rows that were used. I went to form and deleted all responses. So basically a brad new form. Now none of my responses will come over to the google sheet. they just stay in the google form responses.
Very helpful for organizing the sign ups for my football spectator buses.
Thank you so much for the video. I’ve a query, I tried doing exactly the same, but in my case only Session 1 changes to revised session name, but session 2 & 3 still counts after the limit and doesn’t changes to revised session name in the form. Could you give me instructions how to fix that?
in germany use ; instead of , -Then it works also
Thank You!
Hi - Thanks for this but when the capacity is reached it does not delete the option on the form? - 'Available' shows -1?
It there a way to include a date option so that the answer selection once it has meet the limit value it will not be there until the time limit expires.
Thank you so much this was the most helpful
Hello. I would like to ask a question for a similar topic. Is there any way for restricting people from giving the same answer to two subsequent multiple choice questions? I would need this restriction for every pair of questions. Thank you very much for your time.
Hi, this is great! You're a really good teacher!
Just have a query at min 6.08 - Am I supposed add a range for every row of options?
Catherine McMahon Thanks for the compliment, Catherine!
Yes. I add a new range for each question. 4 questions = 4 ranges from 4 spreadsheet tabs.
@@c6edtech great. Thank you so much.
I have a problem, after selecting Which Sheet, it didnt appear anything in Which Data, its just buffering and being blank. Help Me please.
Very nice, thank you.
Hi! Do I need to populate range for each session selection? or populating for one session is enough? thanks in advance!
This has been an absolute saver !! Thanks for explaining it so well .
Awesome! I'm so glad I could help, Monika!
I have been trying to figure out if there is a way to stop a question from being answered once a certain value is selected. I am currently using two questions; 1. Unit #, 2. a Multi Choice Question with 40 rows and 4 columns. The 4 columns are Not Ready, Not Started, WIP, and Done. Whenever a row is Done I don"t want to answer that Row again. Ideally I would like to just have the data show up when anyone types that unit number again but short of that I don't need to update anything that is already Done...Any ideas?
Hi there, it is a good video on the limiting for the number allocated for each item. But how do you reset it back like a library system where someone borrowed the book and wants to return it back. Is there any formula to do so so that after the book was taken away and returning it to the system?? Need some valuable help here..... Thanks.
Hello! Thanks for this. Can you try if there's an update that happened as of this year? The for ranger no longer applies to all of the sessions I put in the column. It only works on the first row. :(
can i block the selection instead of telling people it is full? they can still click on the full timeslot u see
This is amazing, Thank you!
This is a great tutorial! I'm having an issue though that I think is related to the FormRanger....I have images uploaded in my google form that go with some of the answer choices, and they keep disappearing. I also have time slots listed as answer options, and they keep reverting to military time. Help???
Hello, thank you for useful video. Is it possible somehow set the automatic update? FEx. I have lesson Thu 9am and Fri 9am and wanna have limit 15 people, than after it will happen I would like to renew it again from 0, is it possible? Or should I only do it somehow manually? Hope you are still answering :)
Will it refresh everyday ? Or do i have to do it manually?
Thank you so much!!
Hi this is great. However how would I restrict the actual capacity i 5 dates to choose from max people for each date is 6 but his could be 1 people bringing another 5 or 6 different people booking to come on their own?
Hopefully someone has an answer to my question. I need to limit how many people sign up for sessions but I also need to only have one session open at a time. Once session 1 is full, I need session 2 to open, when session 2 is full then session 3 would open. I have two separate regions that I need to create. One region has two sessions, the other region has three sessions. I am still playing with how to open a session after another is full. Would appreciate any advice.
Nice! But I wonder why is this not a built in feature in Google Form in 2022..
thank you for sharing this! I followed the instructions to the T, however, when I do the first formula, it always shows the #name? message. I copied and pasted so there shouldn't be an error with the name. What could be causing this?
This is amazing! Very useful. Just wanna ask, after setup finished and i wanna change the limit session do i need to start up again? Or just change in spreadsheet and it still working?
You can adjust the session limits in your spreadsheet as you need to. If changing the session limit will close that session, you will want to go into the add-on and refresh it. Thanks for your watching!
thank you for this video! you're a lifesaver
I'm so glad I could help, Claire!
I got all the way to 'start Formranger' and it says google refused to connect. Can you help?
Hi, Thank you for the tutorial. It is indeed very helpful! I have situation and would love to hear your opinion. I tried to limit each option to 1, but when multiple people open the form at the same time, the form will show all choices (because the 1st person has not submit the form yet). The problem i found is all of them can still choose the same option and submit and does not show error. Do you have any idea how I can solve this?
Did you find a solution for this?
Very nice tutorial. Thank you !
Thanks!
Thank you, you are a genius
i've installed the add on and it says drive.google.com refused to connect
nice video, thanks you, If I'd like to eliminate the full session on Form what should i do? Thanks you
hi sir , i need the only authorized user should enter the form, once entered no other person should enter in his name , is there any option
very helpful but at the end, i can not do it because there is no way to clik value list? plz help me
I have followed all of the steps but once I get to the last part to set the populate options, I can not find my spread sheet. Does anyone know how to fix this issue?
Thankyou Sir!
I need to ask you something about the form. I did this form,. and i have to limit with 2 check boxes , but when the people submit the answer, the two selected check box passes to a single cell, so it doesn't count
This will only work with a drop-down list or multiple choice question because the text in the cell must be exactly the same as the text used in the countif formula. Sorry for any confusion. Feel free to reach out on Twitter @jpprezz if you want to chat more about this.
Hi,
Quick question. I am a PE teacher and doing this for student to pick an elective and I have max numbers were activity. I followed the directions and am good up to the near end where it says name the values list. I know I have to do this 3 times for my 3 activities but how do I get more than 1 option? It says give the value list a name but there is only room for 1 name. Do I add my first activity and then go back somehow and add my 2nd one? Or is there a way for it do this all at once? I did my value list for my first activity and it works... I have a cap at 20 students and it does say to pick another activity this one is closed, but I don't have that for the other two
So I can getting the sheet to read "This activity is full" but when I am on the form it only says that for the first of 3 activities that they can choose from
The other two activities even though they are closed still come up as open
When I start formranger after following the steps on the google sheets, i don't get an option for select by values---only select range. I can't seem to get select by values?
Michael Maslankowski hit the plus sign then select new range. That should do the trick.
In my form, it starts with the responder having to choose one of two types of classes (adult and children's class). Choosing the adult selection will take the person to one section of the form and choosing the children's class will take them to another section. I set up the spreadsheet for it to limit the responses for the adult class choices . How can I set it up for the children's class choices? Do I create another tab in the spreadsheet? Thanks!
You got it!
Very, very helpful video! does anyone know how can we set a rule like this with two conditions? I have 5 intervals of time and for each one the maximum of people is 14, for each day. Can i ad a question with date and for each day to apply the rule with the maximum people that can register for each interval of time?
Brilliant - than you!
Got confused when you selected Column E for the formula. I thought you would select D? E is blank in your example...
Column E is from the original spreadsheet generated by the form for the registration, not the FormRanger spreadsheet.
I cannot find Form Ranger plugin anymore. Anybody experience the same ?
How can we restrict selection of a check box.
Eg. Option A
Option B
Option c(none)
When we click none other 2 ahould be disabled automatically... Pls. Help. Out
This was extremely helpful. We have one problem still. When we go back into our document and add the formranger, the questions we need to limit (a dropdown checkbox list of classes we need to set limits on for students to sign up) will not show up in the questions list on the form ranger menu. Does that make sense? Can someone help?
you have to add them in. he's using an older version of the form (this video was made in 2017). so the form ranger has updated since then. He does the same thing. It doesn't say "new values list" it just asks you to add them. So the formranger looks different. now the options are "New range" when you click the plus sign. after you go through the process, of selecting (following his directions above) then they'll show up.
Very clear explanation! :) However, although my response spreadsheet reflects accordingly when session is full, the google form does not update concurrently. What went wrong?
Each "this session is no longer available" message has to be slightly different, or it will only update one answer option. When I typed "session 1 is no longer available" "Session 2 is no longer available" etc., it updated correctly.
Nice one.
may i ask something?
after the choices are eliminated from our form. can we change it to a simple sentence(not a question) in the places that where the choices are belong? and not a choices again?
you hope you understand what i'm saying..
You can change it to a statement; however, the radio button will remain on the form. This is explained starting at 3:26 of the video. I hope that helps!
Can anyone help me with app script for limiting response for session per multiple-choice item in the google form?
example
session 1
option 1 (limit response 10)
option 2 (limit response 8)
Its urgent please help me
So, I did this, and my formula works. It shows on my spreadsheet that it is working. It doesn't show up on my form though. On my form, it's still giving me the original two options. Any idea why?
SanctuaryMemory check the re-populate options. Make sure they are both turned on.