Form Ranger Add-on | Google Forms Dynamic Drop-Down list from Google Sheet

[@KewalKishan]

Form Ranger is a game changer Google Form Add-on! Subscribe for Business Growth👉 kewal.co/youtube

[@debanjandey8902]

Can I add a search bar in google form

[@sydiptos]

Hello Sir, I run a delivery service and to manage day to day deliveries i use Google Forms and Sheets. Now, I have a list of addresses saved in Google Sheets along with phone numbers and while typing phone number in Google Forms I want the address to auto poulate in Google Form. Is it possible?

[@KewalKishan]

Hi, we have switched to new and amazing technology. All you queries will be solved as we are conducting Business Automation Workshop. I would be interacting with Business Owners & training them on how to automate their Business. Kindly register on this link: kewal.co/TaskAppInvite

[@ManojPamnani-jj3no]

This does not work for a long list. For eg I have a list of 468 members

[@SalmaArif-u1o]

it needs conditional dropdown. i tried using codes from several source but none works so far

[@rockstarjobearning9022]

Mere pass 500 item h to dikkat ye h k un 500 me se choose krna kya aisa nhi ho skta k m usse related kuch word type kru or usse related hi item aye Please suggeat

[@KewalKishan]

Hi, we have switched to new and amazing technology. All you queries will be solved as we are conducting Business Automation Workshop. I would be interacting with Business Owners & training them on how to automate their Business. Kindly register on this link: kewal.co/TaskAppInvite

[@matrixsecurityandautomatio427]

With the grace of God and with your help i am using this from last 6 months and this change my and my worker's way of doing things. Thanks to u KK Sir

[@ashutoshpundeer6125]

This amazing, preparing dd list is an easy job now

[@JASRIN1020]

Yes. I am using Google form

[@dipasis.trustklub4381]

is there any option where by selecting the department from dropdown, employee names will be shown in g form from that respective department only?

[@KewalKishan]

Dear Dipasis, In Google Form, you can achieve it via Section based questions. Learn here: kzbin.info/www/bejne/gYK1f6Fqeqhjirs

[@dipasis.trustklub4381]

@@KewalKishan Thanks for your reply. In the selection based questions option, I have to type the data manually in G Form. But, is there any option where the data will be in linked G Sheet, but I can select the suitable answer of that question in G Form?

[@PranavVerma1608]

sir, how to make dropdown searchable?

[@trimurtitransport9391]

I want to create a google form to have people select the stop for their pickup or drop. Also i want to add charges to be visible to them for their respective stop but only after they select a stop. that too charges should be visible as per the stop selected is it possible ? if yes how to create such kind of form

[@KarishmaAgrawal-g7f]

Hi, I have a list of around 4000 institutes. Can this be added with this addon?

[@lochan544]

Showing only help in form ranger after installing

[@davidjtepper]

Help! I am not seeing Form Ranger as an Extension in Google Sheets. I searched Google Sheets > Extensions > Add-ons > Get Add-ons. But it is not showing when I search for it.

[@KewalKishan]

Form Ranger is for Google Forms. workspace.google.com/marketplace/app/form_ranger/387838027286

[@April2023-fb6pf]

Form duplicate pliz

[@irfannadra4437]

Hello sir.. i have an issue

[@timesavertricks]

You are Simply great and have and shared game changer tricks for google forms. you made my 1hr task get done within 1 mins. Thanks a lot

[@KewalKishan]

Glad it helped :)

[@unsealedbrush]

What's the limit of this add on?

[@umakant40422]

thanks sir , sir i want remove emplye name from drop dwon list after complete servery , can posible ?

[@KewalKishan]

Yes. It is possible to update Google Form drop down after submission. Formulas required in Google sheet which update the column

[@mohammadalali419]

hello , i would like to ask you (when i add new row to google sheet and it updated to forms and make new response , and then the response will update on response sheet with complete new rows not only the new row , sorry for my bad description ? could you please help me

[@KewalKishan]

Hi Dear, Kindly join our live masterclass - www.kewal.co/y-live to learn about google workspace( including google forms and sheets) and whatsapp automation to know about how you can automate and scale your business to 10X using Google workspace and whatsapp automation. :)

[@JASRIN1020]

There is any limitations of Drop-down means how many row form rangers picked

[@KewalKishan]

Hi Jaswant, Upto 1000 items can be picked.

[@wreSTLclub]

It is not auto-populating the dropdown question. I create the range and it shows the correct data in the preview, but then never does anything to the form. I logged out of all other google accounts and it still isn't working. What is the conflict here? It seems so simple, but it just doesn't make the question.

[@KewalKishan]

Hi Dear, kindly check the data again as the range should not contain the duplicate entries. If you are enrolled with us, then kindly raise a ticket from the support page our technical team will surely help you. :)

[@wreSTLclub]

Thanks for the response and all the great video tutorials. As it turns out, I learned that a space generated counts as a duplicate entry. While I saw no duplicates, the form had cells with just a space as entry. (I was populating a list of names, combined from a different spreadsheet where the names were separated by first and last name.) I had to delete all empty rows from the original spreadsheet where the entries were coming from. @@KewalKishan

[@RobTucker-k1n]

This is good. It is a shame that you need to wait an hour, or submit an empty form to update the list. It would be better if this updates when the form is opened.

[@KewalKishan]

Hi Dear, this addon is provided by Google only. Kindly join our live masterclass to know about how you can automate and scale your business to 10X using Google workspace and Whatsapp automation- www.kewal.co/y-live :)

[@Divasiblings]

Yes

[@joeexception]

outstanding! thanks for taking the time to walk through that

[@KewalKishan]

Glad you enjoyed it! :)

[@ArunKumarSingh-OUPL]

Hi Kishan I'm using this add-on to create a dynamic dropdown list but this is a limited option, you have only 70 to 75 items in a dropdown list. if you have any other option add 150 to 200 items in the Google Forms Dynamic Drop-Down list from Google Sheet.

[@KewalKishan]

Hi Arun, Great question. Well you can add upto 1000 items from google sheet in google form drop down from this addon.

[@ArunKumarSingh-OUPL]

@@KewalKishan Thanks you so much

[@vinodkumarPrajapativnd]

Is there a way to make a searchable drop down in google form?

[@KewalKishan]

HI Vinod, this feature is not a part of google form.

[@vinodkumarPrajapativnd]

@@KewalKishan yes I see, thanks

[@sheetswithsajid5158]

Kya google form main searchable dropdown ban sakty hay?

[@KewalKishan]

Google Sheets me searchable Drop down bna skte hain. Google form me section based form bna skte hain.

[@sheetswithsajid5158]

@@KewalKishan Thanks❤

[@shinopaints6094]

sir work nhi ka raha ha

[@KewalKishan]

Kindly join our live masterclass - www.kewal.co/y-live to learn about google workspace and whatsapp automation to know about how you can automate and scale your business to 10X using Google workspace and whatsapp automation. :)