Use formRanger to Limit Multiple Choice Responses in a Google Form

  Рет қаралды 171,123

JP Prezzavento

JP Prezzavento

Күн бұрын

Пікірлер: 183
@mirrormerecos1920
@mirrormerecos1920 6 жыл бұрын
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.
@c6edtech
@c6edtech 6 жыл бұрын
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.
@joannawatson4061
@joannawatson4061 6 жыл бұрын
JP Prezzavento that’s a great idea too!
@cynthiauchendu
@cynthiauchendu 4 жыл бұрын
I noticed this as well. Thanks for the tip!
@jari_mentega
@jari_mentega 3 жыл бұрын
yeah me too..but any suggestion so that the session still there but we make the button not work to push?
@emiliemontagnet
@emiliemontagnet 3 жыл бұрын
@@jari_mentega Another video suggested using drop-downs instead of buttons; that way, the choice should disappear
@beckysimmons9840
@beckysimmons9840 4 жыл бұрын
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!
@jamessmithmunoz1232
@jamessmithmunoz1232 2 жыл бұрын
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!!
@sanjoy1st
@sanjoy1st 4 жыл бұрын
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.
@vickilawless3653
@vickilawless3653 2 жыл бұрын
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!
@maqta007
@maqta007 5 жыл бұрын
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
@rebeltaylor7124
@rebeltaylor7124 3 жыл бұрын
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!
@bwa3155
@bwa3155 2 жыл бұрын
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.
@joannawatson4061
@joannawatson4061 6 жыл бұрын
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.
@c6edtech
@c6edtech 6 жыл бұрын
Thanks for the comment, JoAnna! I'm so glad I could help.
@themichro
@themichro 5 жыл бұрын
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
@jamvortix
@jamvortix 3 жыл бұрын
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.
@sumobi
@sumobi 4 жыл бұрын
This is the best video I have found explaining FormRanger! Thank You!
@vickilawless3653
@vickilawless3653 2 жыл бұрын
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!
@NganTran-tp4vb
@NganTran-tp4vb Жыл бұрын
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.
@ishtiaqarif3010
@ishtiaqarif3010 2 жыл бұрын
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?
@enasjaber5632
@enasjaber5632 3 жыл бұрын
thanks , but how to apply all that to session 2&3 as well as??
@mirchi2510
@mirchi2510 2 жыл бұрын
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
@rugmaable
@rugmaable 4 жыл бұрын
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.
@sangeethasanthebennur
@sangeethasanthebennur 3 жыл бұрын
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....
@tiffanywilson6842
@tiffanywilson6842 Жыл бұрын
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.
@wanshahrazuddinbwanabdulra6763
@wanshahrazuddinbwanabdulra6763 11 ай бұрын
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
@shamsulsalihin6004
@shamsulsalihin6004 3 жыл бұрын
why forms sometimes do not auto-update even though we have enabled auto-repopulate on form submit & every hour
@markryan785
@markryan785 2 жыл бұрын
When I select Form Ranger from add ons I only get the Help option. Not Start. What am I doing wrong?
@cnrdff
@cnrdff 4 жыл бұрын
Hi - Thanks for this but when the capacity is reached it does not delete the option on the form? - 'Available' shows -1?
@jgranum01
@jgranum01 3 жыл бұрын
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!
@MonikaR2006
@MonikaR2006 Жыл бұрын
Thaaank you so much for this very clear and easy tutorial. This was exactly what I needed!
@ingahildebrandt4317
@ingahildebrandt4317 2 жыл бұрын
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!
@w.gierveld361
@w.gierveld361 4 жыл бұрын
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
@hsienshienhsia4507
@hsienshienhsia4507 3 жыл бұрын
Thank you so much. This is exactly what I need for the checkbox instead multiply choice. Great Job!
@mmramida1829
@mmramida1829 6 жыл бұрын
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!!!!
@jinmingooi313
@jinmingooi313 4 жыл бұрын
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.
@agkvlogs8518
@agkvlogs8518 3 жыл бұрын
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. :(
@genesisherrera6769
@genesisherrera6769 6 жыл бұрын
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?
@johnhatten4133
@johnhatten4133 3 жыл бұрын
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.
@allih8021
@allih8021 4 жыл бұрын
You just completely made my day! Thanks for such a quick, simple and easy to follow tutorial.
@c6edtech
@c6edtech 4 жыл бұрын
And you just made my day with your kind comment. :-)
@zulz1997
@zulz1997 3 жыл бұрын
Will it refresh everyday ? Or do i have to do it manually?
@jasonpayne2334
@jasonpayne2334 3 жыл бұрын
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.
@ianburst
@ianburst 4 жыл бұрын
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!
@Nappi46
@Nappi46 Ай бұрын
Is formRanger still working? Based on the reviews I don't believe it is
@rosevadnai8495
@rosevadnai8495 4 жыл бұрын
This was so helpful! But after you test your form, how do you erase your test submission to allow room for other submissions? Thanks!
@sherilkarstens6891
@sherilkarstens6891 4 жыл бұрын
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.
@janegovednik1982
@janegovednik1982 3 жыл бұрын
Can't thank you enough for this! You made it so clear and easy.
@stephensutton7227
@stephensutton7227 3 жыл бұрын
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
@stephensutton7227
@stephensutton7227 3 жыл бұрын
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
@stephensutton7227
@stephensutton7227 3 жыл бұрын
The other two activities even though they are closed still come up as open
@mrsscushing776
@mrsscushing776 4 жыл бұрын
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?
@jundaaaaaaaaaa
@jundaaaaaaaaaa 3 жыл бұрын
can i block the selection instead of telling people it is full? they can still click on the full timeslot u see
@umeshks2339
@umeshks2339 4 жыл бұрын
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
@marinakarli1301
@marinakarli1301 5 жыл бұрын
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.
@veronikakopecka1527
@veronikakopecka1527 4 жыл бұрын
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 :)
@thinhse
@thinhse 5 жыл бұрын
I used this add-on to display information of seats available of a course. Very useful add-on.
@MathiasGronqvistPrakticum
@MathiasGronqvistPrakticum 2 жыл бұрын
Nice! But I wonder why is this not a built in feature in Google Form in 2022..
@registrar04laca23
@registrar04laca23 4 жыл бұрын
Hi! Do I need to populate range for each session selection? or populating for one session is enough? thanks in advance!
@chriscoffee4123
@chriscoffee4123 7 жыл бұрын
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?
@seacoastlearningcenter8879
@seacoastlearningcenter8879 3 жыл бұрын
I got all the way to 'start Formranger' and it says google refused to connect. Can you help?
@olympus95
@olympus95 4 жыл бұрын
I have a problem, after selecting Which Sheet, it didnt appear anything in Which Data, its just buffering and being blank. Help Me please.
@courtcummings4378
@courtcummings4378 3 жыл бұрын
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???
@efrainsaucedo3134
@efrainsaucedo3134 3 жыл бұрын
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?
@movableimages
@movableimages 3 жыл бұрын
Nice video. One input tho, please enlarge/zoom, instead having full desktop estate. Kind of hard to see
@m.maslankowski5136
@m.maslankowski5136 5 жыл бұрын
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?
@c6edtech
@c6edtech 5 жыл бұрын
Michael Maslankowski hit the plus sign then select new range. That should do the trick.
@boerofede
@boerofede 5 жыл бұрын
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
@c6edtech
@c6edtech 5 жыл бұрын
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.
@beckygarrett3726
@beckygarrett3726 4 жыл бұрын
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?
@katkelly22
@katkelly22 4 жыл бұрын
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.
@raedellevanfossen6054
@raedellevanfossen6054 7 жыл бұрын
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!
@c6edtech
@c6edtech 7 жыл бұрын
You got it!
@sandramughal9768
@sandramughal9768 4 жыл бұрын
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
@farahabdulhalim
@farahabdulhalim 3 жыл бұрын
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?
9 ай бұрын
Did you find a solution for this?
@salinabintisallehkpm-guru5407
@salinabintisallehkpm-guru5407 5 жыл бұрын
very helpful but at the end, i can not do it because there is no way to clik value list? plz help me
@juzailahbintemohamedamin3002
@juzailahbintemohamedamin3002 3 жыл бұрын
Very clear explanation! :) However, although my response spreadsheet reflects accordingly when session is full, the google form does not update concurrently. What went wrong?
@monicahofmann5005
@monicahofmann5005 3 жыл бұрын
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.
@asifannur
@asifannur 4 жыл бұрын
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
@scottwyman6116
@scottwyman6116 5 жыл бұрын
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!!!
@dhummelful
@dhummelful 7 жыл бұрын
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.
@c6edtech
@c6edtech 7 жыл бұрын
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 KZbin.
@dhummelful
@dhummelful 7 жыл бұрын
Thanks for replying. I found a different add on that did what I needed. Thanks!
@c6edtech
@c6edtech 7 жыл бұрын
Dana Hummel you're welcome! What did you use to get the job done?
@Tiffany.J87
@Tiffany.J87 4 жыл бұрын
OMG! Thank you!!! Saved me soooo much time and makes me feel so versatile at work.
@phiesty2
@phiesty2 5 жыл бұрын
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?
@mohdzamreeabdul3935
@mohdzamreeabdul3935 2 жыл бұрын
I cannot find Form Ranger plugin anymore. Anybody experience the same ?
@gauravkumarverma9141
@gauravkumarverma9141 7 жыл бұрын
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.
@c6edtech
@c6edtech 7 жыл бұрын
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)
@kris10bee1
@kris10bee1 6 жыл бұрын
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?
@c6edtech
@c6edtech 6 жыл бұрын
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.
@mirrormerecos1920
@mirrormerecos1920 6 жыл бұрын
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.
@lindaasaro9059
@lindaasaro9059 7 жыл бұрын
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.
@c6edtech
@c6edtech 7 жыл бұрын
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.
@paiinlove1992
@paiinlove1992 6 жыл бұрын
nice video, thanks you, If I'd like to eliminate the full session on Form what should i do? Thanks you
@daveyoung6895
@daveyoung6895 7 жыл бұрын
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.
@c6edtech
@c6edtech 7 жыл бұрын
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.
@daveyoung6895
@daveyoung6895 7 жыл бұрын
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.
@SanctuaryMemory
@SanctuaryMemory 6 жыл бұрын
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?
@c6edtech
@c6edtech 6 жыл бұрын
SanctuaryMemory check the re-populate options. Make sure they are both turned on.
@MusaHf
@MusaHf 6 жыл бұрын
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..
@c6edtech
@c6edtech 6 жыл бұрын
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!
@miguelate
@miguelate 7 жыл бұрын
I am trying to limit the number of responses to one. I have about 20 teams that will have to chose a team number but sometimes they make human errors and select the wrong team number. If I limit to one and they make a mistake do I need to go back and change the limit on the spreadsheet to reenable the ability to resubmit? and hit refresh I guess on the form ranger settings? I'm think of one team member that won't see his number because someone else chose it by mistake so that number is gone. How can I add it again?
@c6edtech
@c6edtech 7 жыл бұрын
I just had to deal with an issue link this an hour or so ago. First, go in to the response spreadsheet and delete/change the response that is an error. If you check your formula, you should see that number has changed back to zero. Then, open up your form, start the formRanger add-on and refresh the questions. After you do that, the answer choice should be available again. Let me know if you need more help.
@miguelate
@miguelate 7 жыл бұрын
Thanks!
@damarisroulette4963
@damarisroulette4963 4 жыл бұрын
Got confused when you selected Column E for the formula. I thought you would select D? E is blank in your example...
@andrewvinson9964
@andrewvinson9964 4 жыл бұрын
Column E is from the original spreadsheet generated by the form for the registration, not the FormRanger spreadsheet.
@ralucanicolae9433
@ralucanicolae9433 4 жыл бұрын
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?
@saifulstudioworks9162
@saifulstudioworks9162 4 жыл бұрын
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?
@c6edtech
@c6edtech 4 жыл бұрын
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!
@prasannaprasanna3315
@prasannaprasanna3315 2 жыл бұрын
Very helpful. Thanks bud
@nicolewuelleh8637
@nicolewuelleh8637 6 жыл бұрын
I have tried to do this numerous times and I never get "populate from values list" I always get "populate from range" and no values list option. Populating from range doesn't seem to work. Does anyone know what I'm doing wrong? Or is this possible when they can choose more than one option? I need to allow them to choose more than one option, but cut those options off after so many people have selected that option. Help!
@elizabethanne5403
@elizabethanne5403 6 жыл бұрын
You can do the range just the same. The problem that I found was that the excel sheet auto populated via the form for responses won't pull up through rangerForm, so instead, create a spreadsheet in your google drive and then link the form to the spreadsheet you just created. Then, within formRanger, select the correct spreadsheet, select your column, and hit update. It works just the same in this video minus the "range" word difference. Good luck!
@nicolewuelleh8637
@nicolewuelleh8637 6 жыл бұрын
I'll give that a go, thank you!
@amartyachatterjee1831
@amartyachatterjee1831 6 жыл бұрын
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
@catemcm
@catemcm 6 жыл бұрын
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?
@c6edtech
@c6edtech 6 жыл бұрын
Catherine McMahon Thanks for the compliment, Catherine! Yes. I add a new range for each question. 4 questions = 4 ranges from 4 spreadsheet tabs.
@catemcm
@catemcm 6 жыл бұрын
@@c6edtech great. Thank you so much.
@imdwayim92
@imdwayim92 3 жыл бұрын
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
@lolaquadri4857
@lolaquadri4857 2 жыл бұрын
This was a lifesaver
@sethimonika
@sethimonika 7 жыл бұрын
This has been an absolute saver !! Thanks for explaining it so well .
@c6edtech
@c6edtech 7 жыл бұрын
Awesome! I'm so glad I could help, Monika!
@nikkiprophet
@nikkiprophet 6 жыл бұрын
got almost all the way through and them it said "populate from range" instead of "populate from values list." What did I do wrong I wonder?
@c6edtech
@c6edtech 6 жыл бұрын
Hi Nikki- I believe that formMule updated their UI since I posted this video. You should be able to click the + to the right of the range to create a new range/value list.
@ritastramel5177
@ritastramel5177 6 жыл бұрын
I have the same issue --my only option is "Populate from range"--but I don't understand your reply. Where is the + I'm supposed to click? Thanks!
@owwabpbh9706
@owwabpbh9706 4 жыл бұрын
does this still work? is this applicable for free?
@soumenhalder7506
@soumenhalder7506 Жыл бұрын
cell capture limit number of cells in add-ons Form ranger, Please tell me sir
@dhubuccgh
@dhubuccgh 2 жыл бұрын
This is very helpful!!!!!!!!!!!!!!!
@gaspynko
@gaspynko 5 жыл бұрын
How does this work when I want to use checkboxes?
@thinhse
@thinhse 5 жыл бұрын
Create a section with checkboxes or dropdowns or multiple choices as usual. When you activate the add-on you can choose which section you want to apply.
@howtodo5062
@howtodo5062 Жыл бұрын
Thank you so much for this...
@dinaschaefer9618
@dinaschaefer9618 7 жыл бұрын
Extremely Helpful! Thanks!
@nevekolondzic9472
@nevekolondzic9472 5 жыл бұрын
the session count does not work for me either. can you please help!
@c6edtech
@c6edtech 5 жыл бұрын
Hmm....check a few things: 1. your vlookup formula is looking at the right search criteria; 2. there aren't spaces after the "session names" in your spreadsheet. Those are usually my two pain points with this.
@dineshgohil2808
@dineshgohil2808 3 жыл бұрын
Great Tutorial.
@ronnedal
@ronnedal 7 жыл бұрын
When I type "=count" the only choice that comes up is =countunique there is no =countif. Am I doing something wrong?
@c6edtech
@c6edtech 7 жыл бұрын
I don't think so. Just go ahead and type "=countif" and then the rest of the formula.
@ronnedal
@ronnedal 7 жыл бұрын
I can see now that if I use my private Google account it works. But when I use my education account it doesn't. Strange, why would they make such limitations to education accounts?
@c6edtech
@c6edtech 7 жыл бұрын
That is strange. I use =countif all the time with my edu account. I even used my EDU account for this video.
@ronnedal
@ronnedal 7 жыл бұрын
Found the solution now. The problem is that Google was using Swedish instead of English for formula names. But I found the setting to change it to english since I have no clue of what they've might have translated it too. Now I can get on with you're guide. Thanks!
@c6edtech
@c6edtech 7 жыл бұрын
Great!
@claireschembri5554
@claireschembri5554 6 жыл бұрын
thank you for this video! you're a lifesaver
@c6edtech
@c6edtech 6 жыл бұрын
I'm so glad I could help, Claire!
@danielfernandez7503
@danielfernandez7503 7 жыл бұрын
I don’t see the option for new value list?
@c6edtech
@c6edtech 7 жыл бұрын
Have you found it yet?
Limit Google Form Responses with Form Ranger
14:53
Shawn Beard (Techy Coach)
Рет қаралды 30 М.
Google Forms and the Form Ranger Add-on
7:40
Patrick Cauley
Рет қаралды 15 М.
I'VE MADE A CUTE FLYING LOLLIPOP FOR MY KID #SHORTS
0:48
A Plus School
Рет қаралды 20 МЛН
УЛИЧНЫЕ МУЗЫКАНТЫ В СОЧИ 🤘🏻
0:33
РОК ЗАВОД
Рет қаралды 7 МЛН
Google Forms - Tutorial 02 - Auto Responses or Certificates
9:09
Flipped Classroom Tutorials
Рет қаралды 199 М.
Creating Google Form Session Sign Up Limits with FormRanger
8:57
Jennie Magiera
Рет қаралды 140 М.
Transformers (how LLMs work) explained visually | DL5
27:14
3Blue1Brown
Рет қаралды 4,2 МЛН
Google Forms - Field Validation & Regular Expression for Response Validation Tutorial - Part 2
12:53
Learn Google Sheets & Excel Spreadsheets
Рет қаралды 118 М.
Google Forms Tutorial
29:15
Kevin Stratvert
Рет қаралды 1,3 МЛН
Restrict Google Form Participants with These Two Options
8:31
How to Limit Multiple Choice Responses in Google Forms
7:17
Simpletivity
Рет қаралды 135 М.
I'VE MADE A CUTE FLYING LOLLIPOP FOR MY KID #SHORTS
0:48
A Plus School
Рет қаралды 20 МЛН