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.
@c6edtech6 жыл бұрын
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.
@joannawatson40616 жыл бұрын
JP Prezzavento that’s a great idea too!
@cynthiauchendu4 жыл бұрын
I noticed this as well. Thanks for the tip!
@jari_mentega3 жыл бұрын
yeah me too..but any suggestion so that the session still there but we make the button not work to push?
@emiliemontagnet3 жыл бұрын
@@jari_mentega Another video suggested using drop-downs instead of buttons; that way, the choice should disappear
@beckysimmons98404 жыл бұрын
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!
@jamessmithmunoz12322 жыл бұрын
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!!
@sanjoy1st4 жыл бұрын
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.
@vickilawless36532 жыл бұрын
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!
@maqta0075 жыл бұрын
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
@rebeltaylor71243 жыл бұрын
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!
@bwa31552 жыл бұрын
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.
@joannawatson40616 жыл бұрын
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.
@c6edtech6 жыл бұрын
Thanks for the comment, JoAnna! I'm so glad I could help.
@themichro5 жыл бұрын
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
@jamvortix3 жыл бұрын
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.
@sumobi4 жыл бұрын
This is the best video I have found explaining FormRanger! Thank You!
@vickilawless36532 жыл бұрын
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 Жыл бұрын
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.
@ishtiaqarif30102 жыл бұрын
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?
@enasjaber56323 жыл бұрын
thanks , but how to apply all that to session 2&3 as well as??
@mirchi25102 жыл бұрын
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
@rugmaable4 жыл бұрын
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.
@sangeethasanthebennur3 жыл бұрын
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 Жыл бұрын
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.
@wanshahrazuddinbwanabdulra676311 ай бұрын
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
@shamsulsalihin60043 жыл бұрын
why forms sometimes do not auto-update even though we have enabled auto-repopulate on form submit & every hour
@markryan7852 жыл бұрын
When I select Form Ranger from add ons I only get the Help option. Not Start. What am I doing wrong?
@cnrdff4 жыл бұрын
Hi - Thanks for this but when the capacity is reached it does not delete the option on the form? - 'Available' shows -1?
@jgranum013 жыл бұрын
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 Жыл бұрын
Thaaank you so much for this very clear and easy tutorial. This was exactly what I needed!
@ingahildebrandt43172 жыл бұрын
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.gierveld3614 жыл бұрын
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
@hsienshienhsia45073 жыл бұрын
Thank you so much. This is exactly what I need for the checkbox instead multiply choice. Great Job!
@mmramida18296 жыл бұрын
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!!!!
@jinmingooi3134 жыл бұрын
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.
@agkvlogs85183 жыл бұрын
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. :(
@genesisherrera67696 жыл бұрын
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?
@johnhatten41333 жыл бұрын
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.
@allih80214 жыл бұрын
You just completely made my day! Thanks for such a quick, simple and easy to follow tutorial.
@c6edtech4 жыл бұрын
And you just made my day with your kind comment. :-)
@zulz19973 жыл бұрын
Will it refresh everyday ? Or do i have to do it manually?
@jasonpayne23343 жыл бұрын
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.
@ianburst4 жыл бұрын
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Ай бұрын
Is formRanger still working? Based on the reviews I don't believe it is
@rosevadnai84954 жыл бұрын
This was so helpful! But after you test your form, how do you erase your test submission to allow room for other submissions? Thanks!
@sherilkarstens68914 жыл бұрын
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.
@janegovednik19823 жыл бұрын
Can't thank you enough for this! You made it so clear and easy.
@stephensutton72273 жыл бұрын
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
@stephensutton72273 жыл бұрын
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
@stephensutton72273 жыл бұрын
The other two activities even though they are closed still come up as open
@mrsscushing7764 жыл бұрын
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?
@jundaaaaaaaaaa3 жыл бұрын
can i block the selection instead of telling people it is full? they can still click on the full timeslot u see
@umeshks23394 жыл бұрын
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
@marinakarli13015 жыл бұрын
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.
@veronikakopecka15274 жыл бұрын
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 :)
@thinhse5 жыл бұрын
I used this add-on to display information of seats available of a course. Very useful add-on.
@MathiasGronqvistPrakticum2 жыл бұрын
Nice! But I wonder why is this not a built in feature in Google Form in 2022..
@registrar04laca234 жыл бұрын
Hi! Do I need to populate range for each session selection? or populating for one session is enough? thanks in advance!
@chriscoffee41237 жыл бұрын
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?
@seacoastlearningcenter88793 жыл бұрын
I got all the way to 'start Formranger' and it says google refused to connect. Can you help?
@olympus954 жыл бұрын
I have a problem, after selecting Which Sheet, it didnt appear anything in Which Data, its just buffering and being blank. Help Me please.
@courtcummings43783 жыл бұрын
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???
@efrainsaucedo31343 жыл бұрын
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?
@movableimages3 жыл бұрын
Nice video. One input tho, please enlarge/zoom, instead having full desktop estate. Kind of hard to see
@m.maslankowski51365 жыл бұрын
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?
@c6edtech5 жыл бұрын
Michael Maslankowski hit the plus sign then select new range. That should do the trick.
@boerofede5 жыл бұрын
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
@c6edtech5 жыл бұрын
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.
@beckygarrett37264 жыл бұрын
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?
@katkelly224 жыл бұрын
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.
@raedellevanfossen60547 жыл бұрын
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!
@c6edtech7 жыл бұрын
You got it!
@sandramughal97684 жыл бұрын
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
@farahabdulhalim3 жыл бұрын
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-guru54075 жыл бұрын
very helpful but at the end, i can not do it because there is no way to clik value list? plz help me
@juzailahbintemohamedamin30023 жыл бұрын
Very clear explanation! :) However, although my response spreadsheet reflects accordingly when session is full, the google form does not update concurrently. What went wrong?
@monicahofmann50053 жыл бұрын
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.
@asifannur4 жыл бұрын
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
@scottwyman61165 жыл бұрын
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!!!
@dhummelful7 жыл бұрын
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.
@c6edtech7 жыл бұрын
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.
@dhummelful7 жыл бұрын
Thanks for replying. I found a different add on that did what I needed. Thanks!
@c6edtech7 жыл бұрын
Dana Hummel you're welcome! What did you use to get the job done?
@Tiffany.J874 жыл бұрын
OMG! Thank you!!! Saved me soooo much time and makes me feel so versatile at work.
@phiesty25 жыл бұрын
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?
@mohdzamreeabdul39352 жыл бұрын
I cannot find Form Ranger plugin anymore. Anybody experience the same ?
@gauravkumarverma91417 жыл бұрын
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.
@c6edtech7 жыл бұрын
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)
@kris10bee16 жыл бұрын
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?
@c6edtech6 жыл бұрын
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.
@mirrormerecos19206 жыл бұрын
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.
@lindaasaro90597 жыл бұрын
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.
@c6edtech7 жыл бұрын
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.
@paiinlove19926 жыл бұрын
nice video, thanks you, If I'd like to eliminate the full session on Form what should i do? Thanks you
@daveyoung68957 жыл бұрын
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.
@c6edtech7 жыл бұрын
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.
@daveyoung68957 жыл бұрын
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.
@SanctuaryMemory6 жыл бұрын
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?
@c6edtech6 жыл бұрын
SanctuaryMemory check the re-populate options. Make sure they are both turned on.
@MusaHf6 жыл бұрын
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..
@c6edtech6 жыл бұрын
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!
@miguelate7 жыл бұрын
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?
@c6edtech7 жыл бұрын
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.
@miguelate7 жыл бұрын
Thanks!
@damarisroulette49634 жыл бұрын
Got confused when you selected Column E for the formula. I thought you would select D? E is blank in your example...
@andrewvinson99644 жыл бұрын
Column E is from the original spreadsheet generated by the form for the registration, not the FormRanger spreadsheet.
@ralucanicolae94334 жыл бұрын
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?
@saifulstudioworks91624 жыл бұрын
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?
@c6edtech4 жыл бұрын
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!
@prasannaprasanna33152 жыл бұрын
Very helpful. Thanks bud
@nicolewuelleh86376 жыл бұрын
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!
@elizabethanne54036 жыл бұрын
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!
@nicolewuelleh86376 жыл бұрын
I'll give that a go, thank you!
@amartyachatterjee18316 жыл бұрын
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
@catemcm6 жыл бұрын
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?
@c6edtech6 жыл бұрын
Catherine McMahon Thanks for the compliment, Catherine! Yes. I add a new range for each question. 4 questions = 4 ranges from 4 spreadsheet tabs.
@catemcm6 жыл бұрын
@@c6edtech great. Thank you so much.
@imdwayim923 жыл бұрын
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
@lolaquadri48572 жыл бұрын
This was a lifesaver
@sethimonika7 жыл бұрын
This has been an absolute saver !! Thanks for explaining it so well .
@c6edtech7 жыл бұрын
Awesome! I'm so glad I could help, Monika!
@nikkiprophet6 жыл бұрын
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?
@c6edtech6 жыл бұрын
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.
@ritastramel51776 жыл бұрын
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!
@owwabpbh97064 жыл бұрын
does this still work? is this applicable for free?
@soumenhalder7506 Жыл бұрын
cell capture limit number of cells in add-ons Form ranger, Please tell me sir
@dhubuccgh2 жыл бұрын
This is very helpful!!!!!!!!!!!!!!!
@gaspynko5 жыл бұрын
How does this work when I want to use checkboxes?
@thinhse5 жыл бұрын
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 Жыл бұрын
Thank you so much for this...
@dinaschaefer96187 жыл бұрын
Extremely Helpful! Thanks!
@nevekolondzic94725 жыл бұрын
the session count does not work for me either. can you please help!
@c6edtech5 жыл бұрын
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.
@dineshgohil28083 жыл бұрын
Great Tutorial.
@ronnedal7 жыл бұрын
When I type "=count" the only choice that comes up is =countunique there is no =countif. Am I doing something wrong?
@c6edtech7 жыл бұрын
I don't think so. Just go ahead and type "=countif" and then the rest of the formula.
@ronnedal7 жыл бұрын
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?
@c6edtech7 жыл бұрын
That is strange. I use =countif all the time with my edu account. I even used my EDU account for this video.
@ronnedal7 жыл бұрын
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!