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...?
Can we have dependant Dropdown menu like If i select District X so its Sub district/ sub unit are shown. If i select District Y so its sub units to be shown ?
Very close to what I'm looking for. Looking to populate a field from a previous question. Question 1 would be to enter your name. Question 2 is multiple choice for what meal you want beside your name.
I want to do something like when I select one value in form drop down other field should be fill automatically base on reference value. How can I do it in Google form.
Is this dynamic? For example, if I set it up to link to a column in a Google Form, which is fed to from a JotForm submission, will it add the options as they complete the Jotform?
Well you really don't need Form Ranger to do that. Copy the data from the Excel sheet and just past that information into the text box. What I was really looking for is 1. If I select State and only the List of those district listed under that state should appear in the next drop down. 2. If I select the first item then the, cost of that item auto populate in the next option.
If I am going to select "Country" option as US , I want all US "States" to be populated under it. If I Choose Country as UK, all relative options needs to be populated, How can we achieve that in Google forms????
Incredible. That's how it feels each time I feel like something isn't possible but later find that it is. Thank you for this. Might you also know how to insert an interactive table within Google Forms? By interactive, I mean editable. Cheers
Hello, I'm a special education teacher and use google forms for various purposes. I'm wondering if there is a way for my students to have access to predictive text when they are filling out short or long answer questions?
Hi teacher! Hope you please showing me how to type (the first Alphabet) and choose the data when it apparence, not scroll up/dowm to find the data we need? Does we have any add on like that on the google sheet market app? Thank you!
Hi wanted to know how to put in the correct chices in the quiz form in bulk. Adding answers to each question is tedious specially when there are 50 to 100 questions
I can see where this would be very useful, but it's not quite what I'm looking for. Is there a way to select fields from a row in a Sheet to populate a form, and then have other questions on that form be answered by the user?
Is it possible to create a dropdown sub-section from the original dropdown list? Example, this is a resident doctor form that I am creating, so I will have a few different headings; under each heading there will be a list of different procedures in "dropdown" format so they can choose which procedure they performed. Then from the procedure they choose, I'd like another dropdown where the resident doctor's preceptor can assign how they made out with the procedure from a list of choices, "Reporter", "interpreter", "Manager" or "Educator". Do you have another video that will help me with this?
I did not get a reply, however I figured out a different way to do it. I still created a dropdown of "99" topics to choose from, then after I added a multiple-choice section so from the topic chosen from the dropdown, they can be evaluated on that topic in the next multiple-choice section. This worked well and still made the form much, much shorter. Hope this helps you.
hi thanks great tip. is there a way to make a conditional dropdown 2 dropdown questions the second dropdown will fullfil depending the answer in first question thanks in advance
Great information. Thank you for sharing. So, is there a way to create a form that populates with data from a sheet but only adding a selected row rather than the data contained in the entire column?
What if I want to have Country - State - City If I choose America, only the states of America should be visible and then cities of only that state. 100+ countries can still be managed But how to manage info of all states and cities of all countries?
Hey man - great video. What if I have 500 possible selections? Do you know anything about if google forms allows you to do a 'search' and auto fill function to better the user experience and not have to look through 500 options?
useful video thanks. Is there any way to have the list of choices in the form auto populate the latest values IMMEDIATELY if there is a change in the list in the google sheet? The once an hour or update only upon submit in the form is not ideal for us. Thanks
Is there a way to make consecutive drop-downs dependent i.e districts based on country selected previously ;; or food menu items based on preference (vegetarian, vegan, lactose-free, etc.) Thank you!
I want to have a form with radio buttons so I can select multiple items but each one is exported to a spreadsheet in another row rather than putting all entries in one cell. This so I can do vlookups of each option. Any ideas?
How can auto fill the info of student on the base of single info provide by student.when all info is available with the form owner and available in excel or Google sheet.
Hi there I need to create a google form for our COVID-19 Health Screening Questionnaire. I have the questions - but we have a few 1000 employees and I need to be able to verify/validate an employee against a DB etc. Any ideas for me. Much appreciated Andrew
My list of values are arranged in more than one column. As each column is of one category. How can i select all values for this dropdown, as it is showing only one?
HI, I need to know if is possible within a google form to autofill serial numbers from other google sheet , or look for exciting serial number when you texting, this is to avoid texting a wrong serial number I need them to fill.
Very good video. We're a cotton inspection company and want to use it for LC number update automatically from others form data. But i'ts not. It's only showing the last data when I add form ranger. Advice me for update Please.
Hi i create mcq quizzes daily in my group. I have cropped the questions from various question papers . What im doing now is import each image seperately on to each question and create options A B C D for each question and mark the correct answers all seperate for each quetsion . It takes a lot of time. Is there any way to make quizzes like this easily with less steps. Please help
Hi there, How can I set a Multiple Selection in a Dropdown? I am doing a form that includes a list of countries and I would like to have people choose different options in the Dropdown, because selecting Multiple choice boxes will make the form really long
Good day sir, this is very helpful, but my problem is a dynamic drop down, Ex. I need to choose first the "PROVINCE" and then the "DISTRICT" will populate depend on the province selected? Please help thanks :)
Thanks for that--super helpful. We have a paper student registration form where we pre-fill individual student placements for the upcoming year (via mail merge) and then let them select their electives. Any idea how I might accomplish this with a G Form?
Let me make sure I understand you correctly. If you have a student, John Doe, you want to show them classes that they've already been enrolled in (core courses perhaps) as well as give them options to enrol in electives? Any more details you can provide would be helpful.
Could you please elaborate. In this particular episode, I demonstrated how you can fill in form choice values based on data in a spreadsheet. Please explain your use case for using names and addresses and I will let you know if I can come up with a solution.
My list of values are arranged in more than one column. As each column is of one category. How can i select all values for this dropdown, as it is showing only one?
Hi I have created a form that I send to clients to gain a lot of information. I have the info being stored in sheets, if that client decides to sign with us I would like to pre populate a new form with all of the info they gave me initially so they don't have to fill it all out again. Can I do this with Form Ranger? If not is there another tool I can use in Google Form to accomplish this? Thanks
Excuse me, can someone tel me If There IS an option to autoconolete when someone IS typing his name? I have that frequently problem because i need full names and people uses to Add just first name or something like tha
Anyone familiar with google spreadsheets and form? We're needing to automatically sort the date once someone fills out and submits the form..the form asks 3 questions- month , date, name...would like to to sort by month...thanks for all help.
I tried this but Form Ranger throws out the following error: ScriptError: This action would increase the number of cells in the workbook above the limit of 2000000 cells.
We don't like using Form Ranger due to the permission requirements that are invasive to our privacy such as "Connect to an external service ", "Send email as 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...?
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...?
I am also looking for exactly the same thing
me too
Can we have dependant Dropdown menu like If i select District X so its Sub district/ sub unit are shown.
If i select District Y so its sub units to be shown ?
Exactly I wanted to know the same. Could you please help me on this question.
Yes, need solution for this....
Thansk great tip ... is it possible to have different people complete different parts of the same submission. Eg manager and support team?
Very close to what I'm looking for. Looking to populate a field from a previous question. Question 1 would be to enter your name. Question 2 is multiple choice for what meal you want beside your name.
Can you do a video on cascading drop-down list?
I want to do something like when I select one value in form drop down other field should be fill automatically base on reference value.
How can I do it in Google form.
I am also looking for exactly the same thing.
even i need the same
i think this is what you are looking for? th-cam.com/video/iYcZU1UzTmE/w-d-xo.html
@@jhoanejn1 This link is related to Spreadsheet, not Google Form.
Is it possible to search in a drop-down list when there is more than 100 items
Detail: you will need to give A LOT of permissions to this addon for it to work. This meaning: give access to your files / Google Drive.
Is this dynamic? For example, if I set it up to link to a column in a Google Form, which is fed to from a JotForm submission, will it add the options as they complete the Jotform?
Can I use Form Ranger in cascaded/dependent dropdown list? Thanks!
Well you really don't need Form Ranger to do that. Copy the data from the Excel sheet and just past that information into the text box. What I was really looking for is
1. If I select State and only the List of those district listed under that state should appear in the next drop down.
2. If I select the first item then the, cost of that item auto populate in the next option.
If I am going to select "Country" option as US , I want all US "States" to be populated under it. If I Choose Country as UK, all relative options needs to be populated, How can we achieve that in Google forms????
hi, did you ever figure out how to do this? i have a similar problem im trying to fix
So have you found the solution?
I also would love to see a drop down based on criteria from a previous answer
Hi, you can try this to see if it works.
th-cam.com/video/AUM6s-hbX6w/w-d-xo.html
Yes, need solution for this....
Incredible. That's how it feels each time I feel like something isn't possible but later find that it is. Thank you for this. Might you also know how to insert an interactive table within Google Forms? By interactive, I mean editable. Cheers
Hello, I'm a special education teacher and use google forms for various purposes. I'm wondering if there is a way for my students to have access to predictive text when they are filling out short or long answer questions?
Really clean and easy to follow video! Thanks!!
Hi, what if drop-down list is having more than 1000 option can we just type initial words and can choose from drop-down list?
It is possible to do it as a dropdown menu? I didn't find this option in the new version of Forms
Hi teacher! Hope you please showing me how to type (the first Alphabet) and choose the data when it apparence, not scroll up/dowm to find the data we need? Does we have any add on like that on the google sheet market app? Thank you!
Thank you so much! :)
You're welcome!
Can we show items in a drop down based on certain conditions?
Hi Can you do a video that show how to auto populate specific Google Form fields, based on dropdown choice
THANK YOU!!!!! I've been looking for this
Hi wanted to know how to put in the correct chices in the quiz form in bulk. Adding answers to each question is tedious specially when there are 50 to 100 questions
How to create dynamic dropdown list in Google form????
Ex: First to select the country name,then the state ,and then the city...
Yes, need solution for this....
I can see where this would be very useful, but it's not quite what I'm looking for. Is there a way to select fields from a row in a Sheet to populate a form, and then have other questions on that form be answered by the user?
Can I use thousands of names in the form as auto population
Is it possible to create a dropdown sub-section from the original dropdown list? Example, this is a resident doctor form that I am creating, so I will have a few different headings; under each heading there will be a list of different procedures in "dropdown" format so they can choose which procedure they performed. Then from the procedure they choose, I'd like another dropdown where the resident doctor's preceptor can assign how they made out with the procedure from a list of choices, "Reporter", "interpreter", "Manager" or "Educator". Do you have another video that will help me with this?
I am looking for the same, did you find how to do it?
I did not get a reply, however I figured out a different way to do it. I still created a dropdown of "99" topics to choose from, then after I added a multiple-choice section so from the topic chosen from the dropdown, they can be evaluated on that topic in the next multiple-choice section. This worked well and still made the form much, much shorter. Hope this helps you.
@@pattirach4173 Can you share video on this ?
Is it possible to have auto update to the option if the source of range updated?
Yes, need solution for this....
hi thanks great tip.
is there a way to make a conditional dropdown
2 dropdown questions the second dropdown will fullfil depending the answer in first question
thanks in advance
Not that I know of, sorry.
Great information. Thank you for sharing. So, is there a way to create a form that populates with data from a sheet but only adding a selected row rather than the data contained in the entire column?
Linda, Can you explain what you are looking for a little more. Could yo provide an example spreadsheet?
doesn't work after Chrome update
What if I want to have Country - State - City
If I choose America, only the states of America should be visible and then cities of only that state.
100+ countries can still be managed
But how to manage info of all states and cities of all countries?
Hey man - great video. What if I have 500 possible selections? Do you know anything about if google forms allows you to do a 'search' and auto fill function to better the user experience and not have to look through 500 options?
Hello,
Based on the selection of District, can the value State be auto populated in next question??
Please help
Yes, need solution for this....
Thank you so much! You saved me a lot of time!
you're welcome.
useful video thanks. Is there any way to have the list of choices in the form auto populate the latest values IMMEDIATELY if there is a change in the list in the google sheet? The once an hour or update only upon submit in the form is not ideal for us. Thanks
awesome! saved me a bunch of time
You're welcome. I'm glad you found it valuable.
is there a way to ask for short answer, and when the user write his name it will search within a defined domain in google sheet?
Is there a way to make consecutive drop-downs dependent i.e districts based on country selected previously ;; or food menu items based on preference (vegetarian, vegan, lactose-free, etc.) Thank you!
Can you specify if this is going to work for a regular user not owner user of the form.
Can you also populate ANSWERS in questionnaires, in the same way?
I want to have a form with radio buttons so I can select multiple items but each one is exported to a spreadsheet in another row rather than putting all entries in one cell. This so I can do vlookups of each option. Any ideas?
Great Tip!! Thank you!
You bet!
How can we get filled another's question depend on another's filled filling.
Can I put a search bar in the answers if my answers are a lot ? How?
How can auto fill the info of student on the base of single info provide by student.when all info is available with the form owner and available in excel or Google sheet.
hi, i have a list of 1000 lines and i think its not working with long lists - is there a limit? (it works on other lists)
Really helpful and easy to follow, thanks so much!
Thanks for the feedback.
Hi there
I need to create a google form for our COVID-19 Health Screening Questionnaire. I have the questions - but we have a few 1000 employees and I need to be able to verify/validate an employee against a DB etc.
Any ideas for me.
Much appreciated
Andrew
My list of values are arranged in more than one column. As each column is of one category. How can i select all values for this dropdown, as it is showing only one?
HI, I need to know if is possible within a google form to autofill serial numbers from other google sheet , or look for exciting serial number when you texting, this is to avoid texting a wrong serial number I need them to fill.
Thanks... great! Time Saving and Helpful.
Glad it helped
can you use it on different questions on the same for for different values?
Very good video. We're a cotton inspection company and want to use it for LC number update automatically from others form data. But i'ts not. It's only showing the last data when I add form ranger. Advice me for update Please.
Hi i create mcq quizzes daily in my group. I have cropped the questions from various question papers . What im doing now is import each image seperately on to each question and create options A B C D for each question and mark the correct answers all seperate for each quetsion . It takes a lot of time. Is there any way to make quizzes like this easily with less steps. Please help
Yes, need solution for this....
Thank you very much my BOSS!
Hi there, How can I set a Multiple Selection in a Dropdown? I am doing a form that includes a list of countries and I would like to have people choose different options in the Dropdown, because selecting Multiple choice boxes will make the form really long
Just worked out a simple solution. Copy and Paste from Sheets into Forms will do the trick too (but it's not dynamic).
Glad to know copy and paste works two for one time imports.
Hi, how do i send custom messages on phone from the database that i hav ecaptured using google forms
VERY USE FULL THANKS
You're welcome. I'm glad you found it valuable.
Is the add on safe? Ill be creating a form for highly sensitive data.
Good day sir, this is very helpful, but my problem is a dynamic drop down, Ex. I need to choose first the "PROVINCE" and then the "DISTRICT" will populate depend on the province selected? Please help thanks :)
Yes, need solution for this....
Thanks for that--super helpful. We have a paper student registration form where we pre-fill individual student placements for the upcoming year (via mail merge) and then let them select their electives. Any idea how I might accomplish this with a G Form?
Let me make sure I understand you correctly. If you have a student, John Doe, you want to show them classes that they've already been enrolled in (core courses perhaps) as well as give them options to enrol in electives? Any more details you can provide would be helpful.
Hi Thanks for the video, I did the same as you shown but the records didn't tabulated in the form. I dont know why, please help
Excellent. But how can I do it if I need to take the value of several columns. Example: name, last name, address. Thank you
Could you please elaborate. In this particular episode, I demonstrated how you can fill in form choice values based on data in a spreadsheet. Please explain your use case for using names and addresses and I will let you know if I can come up with a solution.
My list of values are arranged in more than one column. As each column is of one category. How can i select all values for this dropdown, as it is showing only one?
Hi I have created a form that I send to clients to gain a lot of information. I have the info being stored in sheets, if that client decides to sign with us I would like to pre populate a new form with all of the info they gave me initially so they don't have to fill it all out again. Can I do this with Form Ranger? If not is there another tool I can use in Google Form to accomplish this? Thanks
Very useful! Thank you!
you're welcome.
Excuse me, can someone tel me If There IS an option to autoconolete when someone IS typing his name? I have that frequently problem because i need full names and people uses to Add just first name or something like tha
ScriptError: Authorisation is required to perform that action.
That's the error I get when I click on "Start"
You should provide the excel file the public authorization.
This addon requires quite suspicious permissions: send an email on your behalf, edit all your G files....
How did you activate the form-ranger add-on?
How to show the value of specific cell on google forms?
Anyone familiar with google spreadsheets and form? We're needing to automatically sort the date once someone fills out and submits the form..the form asks 3 questions- month , date, name...would like to to sort by month...thanks for all help.
do you still need help w this? If so, send an example form/spreadsheet.
I tried this but Form Ranger throws out the following error:
ScriptError: This action would increase the number of cells in the workbook above the limit of 2000000 cells.
Cedric Fourie - we can have a maximum of 2 million cells in a Google sheet. Do you have extra rows or columns that are empty that you can delete?
how to add Dynamic Drop down List In Googal Form
and I didn't see the "formRanger" what I saw here in my form is AppSheet.
link to form ranger?
chrome.google.com/webstore/detail/formranger/faepkjkcpnnghgdhiobglpppbfdnaehc?hl=en
i am facing some issue on run time and displaying "ReferenceError: "FormRanger" is not defined." how to resolve it
Thanks, a great tip!
you're welcome
Hi, kindly help in creating dependent dropdown in Google form
Yes, need solution for this....
Thank you
You're welcome
Hi very useful thank you
you're welcome
Very helpful -- thanks!
Glad it helped.
thanks
You're welcome!
Thankyou but I want n loop the section could you plz
FormRanger is not available
hai...frist i can you used this api, and sudently , showing message thirt party not allowed to using this api, fyi i using free gmail
thanks a lot. But it takes too much to update
doesn't work after Chrome update
Doesnt load questions.
Not clear step until you have to show the result. This video show nothing.
Thank you for the tip. However, there's a very easy script that can get this job done.
Kindly share this tip please. Is there also a tip that can insert a table into Google Forms?
just copy paste that list in the options field. y doing so much unnecessary things . lol
We don't like using Form Ranger due to the permission requirements that are invasive to our privacy such as "Connect to an external service
", "Send email as 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...?
Yes, need solution for this....
I'm not aware of a way this can be done except for using sections within google forms.
Can we have dependent Dropdown menu like If i select District X so its Taluks are shown.
If i select District Y so its Taluks to be shown ?
Yes, need solution for this....
The only way I know how to do this is by using sections in Google forms.
Is it possible to search in a drop-down list when there is more than 100 items