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!!
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!
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!
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.
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 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!!!
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
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
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.
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.
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?
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!
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?
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!
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, 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?
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.
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.
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.
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 :)
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.
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?
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.
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
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???
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
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?
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!
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?
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.
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?
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.
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?
JP thank you for your wonderful and clear instruction video. I followed it almost all the way to the end and ran into trouble at the very last step. In my case, I'm trying to create audition time slots every 5 minutes across multiple hours. I have one drop down question list of roughly 70 time slots in total. When I clicked "update question list" on Form Ranger it changed all the times in my form from PM to AM. I don't think I fully understood the last point where you talk about the Name Range. In any case, I just had the idea that if I change it from drop down to multiple choice it might work. It's not changing the name of the timeslot. I think I've messed up on the last step. Any tips?
Kristen Beever Hi Kristen! My last statement about the named ranges is for instances where you have more then one question that needs to happen options eliminated. I don't know why the times would change on you.
The times change for some reason if your format is Auto - seems to advance everything by two hours. If you go to Format > Number and select Plain Text, the world will right itself.
Not sure if you're still answering questions on this topic...but I have followed the instructions and for some reason my location count column is not pulling the information from the Form Response tab. What could be the error there? =CountIf('Form Responses 1'!D1,B2) This was my formula.... Do you see something wrong with it? I am trying to create a form for the kids at school to choose which organization they will do their community service.
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!
In the above example, a person has the choice to choose EITHER session 1 OR session 2 OR session 3. If i want a person to choose multiple sessions but not more than 2 sessions. Can this be done? Can we use check boxes instead of radio buttons in questions where we want to set the limits? How does check boxes will be reflected in spreadsheet? Please help.
I would create two separate questions, one for each time slot. Be careful to make sure you give the sessions slightly different names in each question (I use a -2 for all second session choices)
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.
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?
Can you show (or tell me how) how I could have multiple selections over 3 sessions - eg 3 rounds of workshops which people have to choose 1 in each round. Thanks.
Dave Young make three separate questions in the form, making sure that each session name is unique. In your spreadsheet, make 1 tab for each question. Then when you run formMule, you will map three spreadsheet tabs, one for each question. The most important thing to keep in mind is that even if sessions have the same name, make sure that the names are unique, maybe adding a 1, 2, and 3 after session names fort sessions 1, 2, and 3. Hopefully that makes sense.
Thanks. That is what I thought I would have to do but can not getting it working properly. (I guess you mean FormRanger rather than Mule?) I did the formula for each sheet to reference the correct column but must be missing something.
How do I add multiple values in the values list in FormRanger. The video shows him entering session 1 selection in the values list. How would you add session 2 selection and Session 3 selection, and so on? Any assistance would be much appreciated. Thanks.
In your spreadsheet, just create another table for each additional session, making sure that the session names are slightly different, so using -2, -3 so that formRanger understands that it is looking at two different things.
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?
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!!
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!
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!
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.
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.
Can't thank you enough for this! You made it so clear and easy.
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!!!!
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. :-)
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
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!
Thaaank you so much for this very clear and easy tutorial. This was exactly what I needed!
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!!!
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
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
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
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
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.
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.
This is very helpful!!!!!!!!!!!!!!!
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?
Extremely Helpful! Thanks!
Very helpful for organizing the sign ups for my football spectator buses.
Very helpful. Thanks bud
Thank you so much for this...
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!
This was so helpful! But after you test your form, how do you erase your test submission to allow room for other submissions? Thanks!
This was a lifesaver
SO helpful! Thank you so much
in germany use ; instead of , -Then it works also
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?
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!
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....
thanks , but how to apply all that to session 2&3 as well as??
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.
Great Tutorial.
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?
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.
Thank you so much this was the most helpful
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.
Very nice tutorial. Thank you !
Thanks!
This has been an absolute saver !! Thanks for explaining it so well .
Awesome! I'm so glad I could help, Monika!
Hi - Thanks for this but when the capacity is reached it does not delete the option on the form? - 'Available' shows -1?
Hi! Do I need to populate range for each session selection? or populating for one session is enough? thanks in advance!
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 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.
Nice! But I wonder why is this not a built in feature in Google Form in 2022..
Thank You!
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.
why forms sometimes do not auto-update even though we have enabled auto-repopulate on form submit & every hour
This is amazing, Thank you!
Very nice, thank you.
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
When I select Form Ranger from add ons I only get the Help option. Not Start. What am I doing wrong?
thank you for this video! you're a lifesaver
I'm so glad I could help, Claire!
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 :)
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.
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?
amazing, thanks
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.
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
Thank you, you are a genius
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!
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. :(
Will it refresh everyday ? Or do i have to do it manually?
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???
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
Thank you so much!!
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?
Nice one.
I have a problem, after selecting Which Sheet, it didnt appear anything in Which Data, its just buffering and being blank. Help Me please.
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!
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?
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.
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.
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?
nice video, thanks you, If I'd like to eliminate the full session on Form what should i do? Thanks you
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.
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.
JP thank you for your wonderful and clear instruction video. I followed it almost all the way to the end and ran into trouble at the very last step. In my case, I'm trying to create audition time slots every 5 minutes across multiple hours. I have one drop down question list of roughly 70 time slots in total. When I clicked "update question list" on Form Ranger it changed all the times in my form from PM to AM. I don't think I fully understood the last point where you talk about the Name Range. In any case, I just had the idea that if I change it from drop down to multiple choice it might work. It's not changing the name of the timeslot. I think I've messed up on the last step. Any tips?
Kristen Beever Hi Kristen! My last statement about the named ranges is for instances where you have more then one question that needs to happen options eliminated.
I don't know why the times would change on you.
The times change for some reason if your format is Auto - seems to advance everything by two hours. If you go to Format > Number and select Plain Text, the world will right itself.
Not sure if you're still answering questions on this topic...but I have followed the instructions and for some reason my location count column is not pulling the information from the Form Response tab. What could be the error there? =CountIf('Form Responses 1'!D1,B2) This was my formula.... Do you see something wrong with it? I am trying to create a form for the kids at school to choose which organization they will do their community service.
Hmm...I'm not too sure without looking at the spreadsheet. If you're still having issues let me know and we can connect off TH-cam.
Thanks for replying. I found a different add on that did what I needed. Thanks!
Dana Hummel you're welcome! What did you use to get the job done?
Thankyou Sir!
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!
very helpful but at the end, i can not do it because there is no way to clik value list? plz help me
In the above example, a person has the choice to choose EITHER session 1 OR session 2 OR session 3. If i want a person to choose multiple sessions but not more than 2 sessions. Can this be done? Can we use check boxes instead of radio buttons in questions where we want to set the limits? How does check boxes will be reflected in spreadsheet?
Please help.
I would create two separate questions, one for each time slot. Be careful to make sure you give the sessions slightly different names in each question (I use a -2 for all second session choices)
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.
can i block the selection instead of telling people it is full? they can still click on the full timeslot u see
Brilliant - than you!
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.
Can you show (or tell me how) how I could have multiple selections over 3 sessions - eg 3 rounds of workshops which people have to choose 1 in each round. Thanks.
Dave Young make three separate questions in the form, making sure that each session name is unique. In your spreadsheet, make 1 tab for each question. Then when you run formMule, you will map three spreadsheet tabs, one for each question.
The most important thing to keep in mind is that even if sessions have the same name, make sure that the names are unique, maybe adding a 1, 2, and 3 after session names fort sessions 1, 2, and 3.
Hopefully that makes sense.
Thanks. That is what I thought I would have to do but can not getting it working properly. (I guess you mean FormRanger rather than Mule?) I did the formula for each sheet to reference the correct column but must be missing something.
I got all the way to 'start Formranger' and it says google refused to connect. Can you help?
How do I add multiple values in the values list in FormRanger. The video shows him entering session 1 selection in the values list. How would you add session 2 selection and Session 3 selection, and so on? Any assistance would be much appreciated. Thanks.
In your spreadsheet, just create another table for each additional session, making sure that the session names are slightly different, so using -2, -3 so that formRanger understands that it is looking at two different things.
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?