Thanks for the video! I knew that conditional forms were possible, but I couldn't figure out where the options were. Your great video game me the solution in minutes! Thanks for taking the time to make it!
Issue regarding required subquestions if they answer no. I am trying to understand vehicle accessibility on a small island. So I have about 3 questions per section. If they answer yes in that section, I want them to complete the next two, if no, continue to next section. The next two are set as required but if they hit no they still have to fill these out. If I do not set them as required, I might not get the data I need for detailed analysis. Example below. Q1 Sec 1: Do you own a car? Yes - continue to Q2 No - goto next section Q2 section 1: What sort of car? Ford Holden Mazda Toyota Other Q3: What type? Sedan Wagon SUV Ute Q1 Section 2: Do you have access to someone elses car? Yes: continue to next question No: submit form Q2 section 2: Who can you access it from? Friend Family Work Other Perhaps the only solution is to create a section for every question (30 plus) which makes it seem long with many headings. Other solution is to remove 'required' for each sub-question which may limit the quality of the data. Is there another solution? Thanks, Zac
it help me a lot, but there is one thing I notice that if I click YES then it will proceed to the section you've set , but after that you will proceed to the next section, it should be sumbit
For this, you want to have some sort of End section that you can jump to (maybe a "Thanks for filling out this form" message or something). Then, at the very bottom of each section that you conditionally jump into, you can select "After section _, GO TO SECTION _ (End)" to skip to a screen where you can submit.
This is amazing, thank you! Any idea how to do this with a linear scale question? Trying to organise an event with (1) being not likely going and (5) being very likely. Don't want people who aren't going answering questions that would influence the event
I have a question about Google forms: There are 10 students and they will do one activity each and give points to each other. The points are between 10 and 100. Each point will be used once. If the first student gives 50 points to the second student, he will not be able to give 50 points to the third student. The 50 points will not appear when scoring the second and other students. How can I do this? Thank you.
Hi, thanks for the explanation 1- How can I run the web link directly after the submit form button? 2- How can I show the sender's mail in the form field without typing it? 3- How do I get a student to check-in and check-out only twice a day ? Thank you ....
I created a Google form and added questions. I want to remove from the form as soon as he gives a wrong answer to a question without showing him any further questions. How to do it? As it is here, we have to create one section for each issue. Then the form does not look right.
I am trying to create a Google form with date picker which shouldn't allow a user to select less than today. So what I am wanting to do is to only allow selection as either today or a future date however I am stuck as I am unable to make it work. Is their a way to do the above using Google form controls or scripts? If yes, I had totally loved to see a video tutorial on it pls. Thanks in advance.!!
Really appreciated for this great session. But I wanna ask about the response data collection in spreadsheet. If I prepare conditional question i.e. a questionnaire consistent several sections for different respondent but all of these responses if I want to count for one answer, how can I merge it to one row in the output?
Hi, I have a question here! Say for example: I have given multiple options in the first section to choose from. It can one option or multiple options (Checkboxes). Each option is connected to a certain type of questions in later sections. The person who is filling the form should only be able to see questions related to his/her choice of selection is the first question. Please let me know how do I do that in google forms. Your response is awaited.
Is there a way to make if statement with multiple conditions? For instance, if a user chooses a from section 1 and b from section 2, go to section 4 or something similar.
Hello good sir. I have this very long conditional set of questions on my form, and now the output on the spreadsheet is a very wide list of data where there are lots of blank cells (for unanswered/unnecessary questions) and the answered ones has a lot of gap/empty cells between them... How can this be remedied?
Again very good video. I had a issue when I made it a required. It would give an error saying you need to do required questions. Maybe they changed it since I made forms. I tried using forms as encoding data. it takes to long. Like if you have Items purchased. You might have 1 item one day next day it might be 15. I also have other categories as well that it would pass by the items. Just like you did. It make a good data base. but the time to encode was to long. Maybe you might know a different way.
Very helpful. I have a question about formatting the data in the form response Google Sheet. Some of my questions are quite long. In the response spreadsheet, the entire question plus the answer (multiple choice or checkbox) is included in the first row. is there there a way to separate the question from the response options in the data sheet?
I have a question, is there any option to set the confirmation message as per the question type? means that the confirmation message is not the same for every question? Thanks!
I have a long form with conditional logic. I want the form to give me two different answers when a section is checked, but it is not doing that. I am willing to communicate by email. I need help.
the problem with this is when you duplicate the sections, in spread sheets the quesrion also duplicated so you will get 2 columns with the same question it gets so messy.
I would like to get that when a person submits a form, in the confirmation window that appears later, they put the corresponding number of the response sent. For example, when the first response is sent that says "Your response has been received, it is number 1", in the second response it is number 2, and so on.
. In quiz if we make 5 sections, each containing 20 questions. So total no. of questions will be 100. Students are expected to solve two questions from each section so that he can solve total 10 questions. Now can the students be assigned any two random questions from each section... so that each student will get different 10 questions in different order. Is this possible?
Hey there hows it going?? . May you kindly help me about Google forms?? . Imagine that i need make a 200 employees list on the first questions… my crew need mark 50 best ones… second questions needs to be listed JUST these 50 bests…3ª question they will mark top 30 bests and ONLY this 30 to be listed on the Next question… i need to doing this to funnel from 200 to end in the top 20 bests employees in 4 questions … do you know how may i do this ?? . Forms, some specific extensions or some Google forms hack?? . Help meeeeee
This allows me to go to another section based on a specific answer. But it doesn't allow me to pop up new question based on an answer in the same section? Let me clarify a little... Suppose I am collecting some info on someone and I put a question "Are you a student?" I want to pop up a second question- "What is the name of your institution?" If he/she chooses "Yes" as the answer in the first question. Unfortunately, I don't find any option in google form to do that.
hi, thank you. I have another question. Can we use like this? For an example : The name and Index numbers are must correct, then we go to the next page. Else, we cant go to next page. Can we do it on google forms?
@@kumuthajuwarajan4042 if the index number is variable( different for every person) you can not put that as a condition to continue the survey cause google forms can't be connected to the base of legitamate/correct index numbers, you can either put the red asterix on the index number so it is obligatory field to answer therefor the next question can't be accessed...(choose the short answer type)
The session is good! But I have a doubt. I created 10 questions. I want to give customized comments based on their merit mean I want to give Message-1 if he/ she got 6 or above 6 points out of 10 else want to display Message2. Is it possible in Google forms Microsoft forms? Please help me Thank you!
What I want is, two dropdown A & B, and when we select one option from dropdown A the values in dropdown B should be selected according to the value in A.... Can you please help me if it is possible to do...?
Trying to work with Google sheets I have products from different companies with their codes I want to look up in product code For duplicate if so I wanted to go to coast and calculate which one is cheapest by how much then give me how much and what company or give me if possible the cost on each of the companies for example company a cost $.20 more than Company B and Company c coast $.30 less than Company b or something like that
FYI: conditional logic tutorial actually starts at 3:07
fucking thanks!
Literally couldn't wait for him to get to the point! Note to self - just read comments before watching videos like this.
Thanks ❤️
Thanks for the video! I knew that conditional forms were possible, but I couldn't figure out where the options were. Your great video game me the solution in minutes! Thanks for taking the time to make it!
thank u, this is help me to finish my job..
Excellent video! This really helped me out!
👍
Video was really helpful. Thank you so much sir.
❤❤
Thanks... Most useful video...
Thanks for the video
This is very informative and helpful video thanks sir :)
It's really helpful 😊... thanks
Thank you! This is so easy to do.
Glad it was helpful!
Super helpful. Thank you!
This really Helps. Thanks a TON!! I SUB
Issue regarding required subquestions if they answer no.
I am trying to understand vehicle accessibility on a small island. So I have about 3 questions per section. If they answer yes in that section, I want them to complete the next two, if no, continue to next section. The next two are set as required but if they hit no they still have to fill these out. If I do not set them as required, I might not get the data I need for detailed analysis. Example below.
Q1 Sec 1: Do you own a car?
Yes - continue to Q2
No - goto next section
Q2 section 1: What sort of car?
Ford
Holden
Mazda
Toyota
Other
Q3: What type?
Sedan
Wagon
SUV
Ute
Q1 Section 2: Do you have access to someone elses car?
Yes: continue to next question
No: submit form
Q2 section 2: Who can you access it from?
Friend
Family
Work
Other
Perhaps the only solution is to create a section for every question (30 plus) which makes it seem long with many headings. Other solution is to remove 'required' for each sub-question which may limit the quality of the data. Is there another solution? Thanks, Zac
thank u that was very helpful
it help me a lot, but there is one thing I notice that if I click YES then it will proceed to the section you've set , but after that you will proceed to the next section, it should be sumbit
For this, you want to have some sort of End section that you can jump to (maybe a "Thanks for filling out this form" message or something). Then, at the very bottom of each section that you conditionally jump into, you can select "After section _, GO TO SECTION _ (End)" to skip to a screen where you can submit.
This was really helpful, but how can I leave an automatic comment for each answer?
Thank you, I learnt condition questions in the Google forms
thankyou it was a very helpful
Thanks for the video.It was of great help.
Thanks for the video. helped a lot thanks
Appreciative for this video. Gonna go implement this now.
thank you, i was looking this video for long time, but finally i found it
This is amazing, thank you! Any idea how to do this with a linear scale question? Trying to organise an event with (1) being not likely going and (5) being very likely. Don't want people who aren't going answering questions that would influence the event
Thank Sir, very helpful!
Great!
I have a question about Google forms:
There are 10 students and they will do one activity each and give points to each other. The points are between 10 and 100. Each point will be used once.
If the first student gives 50 points to the second student, he will not be able to give 50 points to the third student. The 50 points will not appear when scoring the second and other students. How can I do this? Thank you.
Hi, thanks for the explanation
1- How can I run the web link directly after the submit form button?
2- How can I show the sender's mail in the form field without typing it?
3- How do I get a student to check-in and check-out only twice a day ?
Thank you ....
Fixed my problem, thanks buddy
Really Nice Video Sir
Great Job! Instructive, str8 to the point and practical. I was able to replicate immediately...Many thanks
I created a Google form and added questions. I want to remove from the form as soon as he gives a wrong answer to a question without showing him any further questions. How to do it? As it is here, we have to create one section for each issue. Then the form does not look right.
thanks a lot Sir
I am trying to create a Google form with date picker which shouldn't allow a user to select less than today. So what I am wanting to do is to only allow selection as either today or a future date however I am stuck as I am unable to make it work. Is their a way to do the above using Google form controls or scripts? If yes, I had totally loved to see a video tutorial on it pls. Thanks in advance.!!
Really appreciated for this great session.
But I wanna ask about the response data collection in spreadsheet.
If I prepare conditional question i.e. a questionnaire consistent several sections for different respondent but all of these responses if I want to count for one answer, how can I merge it to one row in the output?
have you figured out how to do i, sir? My spreadsheet is now so wide.
@@giane911 i have the same problem. Have you found an answer? Hehe
Same problem too. Have you found a solution, sir?
Hi, I have a question here!
Say for example:
I have given multiple options in the first section to choose from. It can one option or multiple options (Checkboxes). Each option is connected to a certain type of questions in later sections. The person who is filling the form should only be able to see questions related to his/her choice of selection is the first question. Please let me know how do I do that in google forms. Your response is awaited.
Thanks bro..
Too many sections which makes it confusing. Video should be streamlined.
I watch all your videos, thanks a lot
Is there a way to make if statement with multiple conditions? For instance, if a user chooses a from section 1 and b from section 2, go to section 4 or something similar.
do you know how to prevent a back button for people changing their answers
Hello good sir. I have this very long conditional set of questions on my form, and now the output on the spreadsheet is a very wide list of data where there are lots of blank cells (for unanswered/unnecessary questions) and the answered ones has a lot of gap/empty cells between them... How can this be remedied?
That's very useful. Thanks very much.
what if i dont want them to go back
Hi this video very useful but you can help me the scrippt update dropdown list and set go to section base . thank you very much
Again very good video. I had a issue when I made it a required. It would give an error saying you need to do required questions. Maybe they changed it since I made forms. I tried using forms as encoding data. it takes to long. Like if you have Items purchased. You might have 1 item one day next day it might be 15. I also have other categories as well that it would pass by the items. Just like you did. It make a good data base. but the time to encode was to long. Maybe you might know a different way.
Thank you so much for this video. 😻
Thank you, very helpfull
very useful, thank you!
Thankyou so much...😍😍 This is what I was looking for...
THANKS po.
Very helpful. I have a question about formatting the data in the form response Google Sheet. Some of my questions are quite long. In the response spreadsheet, the entire question plus the answer (multiple choice or checkbox) is included in the first row. is there there a way to separate the question from the response options in the data sheet?
I have a question, is there any option to set the confirmation message as per the question type? means that the confirmation message is not the same for every question? Thanks!
I have a long form with conditional logic. I want the form to give me two different answers when a section is checked, but it is not doing that. I am willing to communicate by email. I need help.
Are conditional questions only allowed with multiple choice field type or is it possible with other field types too like Multiple Choice Grid ?
I am trying to do this in the form script any suggestions?
the problem with this is when you duplicate the sections, in spread sheets the quesrion also duplicated so you will get 2 columns with the same question it gets so messy.
Can we do that conditional sections with Checkboxes or if answers are more than 1
I would like to get that when a person submits a form, in the confirmation window that appears later, they put the corresponding number of the response sent.
For example, when the first response is sent that says "Your response has been received, it is number 1", in the second response it is number 2, and so on.
Hi, my setting will be refresh back to normal if someone already fill the form.
Can you solve how to lock these settings?
Thank you
How can I allow multiple people to complete the same form without submitting it?
Thanks a lot
How are you able to get the text field besides 'Other' option in some of the Technical questions?
Is there any way to create a form that terminates upon a specific answer and sends the taker to a different ending screen?
Thanks
thanks 🙂
. In quiz if we make 5 sections, each containing 20 questions. So total no. of questions will be 100.
Students are expected to solve two questions from each section so that he can solve total 10
questions. Now can the students be assigned any two random questions from each section... so that
each student will get different 10 questions in different order. Is this possible?
You'll have to build a Web App for this. Google Forms doesn't currently support this.
May Allah bless you
Hey there hows it going??
.
May you kindly help me about Google forms??
.
Imagine that i need make a 200 employees list on the first questions… my crew need mark 50 best ones… second questions needs to be listed JUST these 50 bests…3ª question they will mark top 30 bests and ONLY this 30 to be listed on the Next question… i need to doing this to funnel from 200 to end in the top 20 bests employees in 4 questions … do you know how may i do this ??
.
Forms, some specific extensions or some Google forms hack??
.
Help meeeeee
This allows me to go to another section based on a specific answer. But it doesn't allow me to pop up new question based on an answer in the same section?
Let me clarify a little... Suppose I am collecting some info on someone and I put a question "Are you a student?" I want to pop up a second question- "What is the name of your institution?" If he/she chooses "Yes" as the answer in the first question. Unfortunately, I don't find any option in google form to do that.
Did you ever get an answer to this?
@@adanyi8827 Nope.
Sr hw can we create or make an analysis for some questions
How to solve the problem when the sheets are not getting updated
hi,
thank you. I have another question.
Can we use like this? For an example :
The name and Index numbers are must correct, then we go to the next page. Else, we cant go to next page. Can we do it on google forms?
3:23 You can put "submit form" on the wrong answer to end survey there and then, can't skip to the next section or continue
@@JB-tt6ct thanks
But my question is
first they enter the name then they enter their index number. These are correct then, they go to the next page.
@@kumuthajuwarajan4042 if the index number is variable( different for every person) you can not put that as a condition to continue the survey cause google forms can't be connected to the base of legitamate/correct index numbers, you can either put the red asterix on the index number so it is obligatory field to answer therefor the next question can't be accessed...(choose the short answer type)
The session is good!
But I have a doubt. I created 10 questions. I want to give customized comments based on their merit mean
I want to give Message-1 if he/ she got 6 or above 6 points out of 10 else want to display Message2.
Is it possible in Google forms Microsoft forms? Please help me
Thank you!
I have the 3 dots but I only have dedcription I do not not have based on answer why is this?
Can we validate answers based on previous questions, like, total of answer 2 and 3 must be equal to answer 1
No, you'll have to create a Web App to do something like that. ruclips.net/video/RRQvySxaCW0/видео.html
Is it possible to set "go to section by the response" in google scripts?
I have some problem. the ans. Show red cross though thr answer is correct.
I dont have that option, i only have "response validation".
It only works on multiple choice questions.
@@willwilson8377 Thanks for your insight Will !!!! I had the same issue than Frensiow before reading your answer !!!! Thanks a lot !
Thank you:)
:)
how to split answer to in spreadsheet to different sheet
The response i am getting through this, contains all element which user haven't selected.
excellent!
What I want is, two dropdown A & B, and when we select one option from dropdown A the values in dropdown B should be selected according to the value in A.... Can you please help me if it is possible to do...?
By creating sections you can do it, just google about sections
Thankssss
How do we have Name Email Cell Nos YES/NO (Multiple) in a form ?
Trying to work with Google sheets I have products from different companies with their codes I want to look up in product code For duplicate if so I wanted to go to coast and calculate which one is cheapest by how much then give me how much and what company or give me if possible the cost on each of the companies for example company a cost $.20 more than Company B and Company c coast $.30 less than Company b or something like that
The first three minutes were pretty useless...
i need this done in VUE
xlnt tutorial
3.14 you're welcome
Nc
This didn't need to be 7 minutes
🙏🏻
Thank you! This is so easy to do.
Very helpful. Thank you!