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

Hey Business Owners, Attend Business Automation Masterclass👉 kewal.co/y-live and to learn how to Run your Business Stress Free on Autopilot mode📲
Today, we’ll talk about one of the most wanted features of Google Forms. The ability to auto-populate items in Google Forms, directly from Sheets. The Form Ranger addon allows you to set a google form in such a way that you don’t need to add more items to it’s list every day. You can directly get them from Sheets.
If you wish to do more and scale your business to new heights, join our free and interactive Automation Masterclass 👉 kewal.co/y-live
CHAPTERS
00:00 Introduction
01:18 Install the free Addon
02:11 When to use dynamic dropdowns?
03:11 Using Form Ranger
04:19 Creating dropdowns from Sheets
09:47 Conclusion
Kewal Kishan is India’s Leading Business Automation Coach who has successfully trained more than 3500+ SME Owners and 15+ MNCs worldwide. He has been helping business owners bridge the gap between their skills and their growth with simplistic solutions that don’t need any technical skills or years of training. In just 8 weeks, hundreds of business owners have achieved their vision of becoming the most loved and customer-centric ventures.
Check out our business growth tips & tricks from the following list:
Scale Your Business
• How to Scale your Busi...
The Benefits of Google Workspace for Small Businesses
• Introduction to G-suit...
#googleforms #googleworkspace #businessautomation #businesssuccess #businessmentor

Пікірлер: 46

  • @KewalKishan
    @KewalKishan Жыл бұрын

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

  • @matrixsecurityandautomatio427
    @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
    @ashutoshpundeer6125 Жыл бұрын

    This amazing, preparing dd list is an easy job now

  • @JASRIN1020
    @JASRIN1020 Жыл бұрын

    Yes. I am using Google form

  • @Divasiblings
    @Divasiblings13 күн бұрын

    Yes

  • @timesavertricks
    @timesavertricks8 ай бұрын

    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

    @KewalKishan

    8 ай бұрын

    Glad it helped :)

  • @joeexception
    @joeexception11 ай бұрын

    outstanding! thanks for taking the time to walk through that

  • @KewalKishan

    @KewalKishan

    11 ай бұрын

    Glad you enjoyed it! :)

  • @trimurtitransport9391
    @trimurtitransport93918 ай бұрын

    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

  • @debanjandey8902
    @debanjandey89026 күн бұрын

    Can I add a search bar in google form

  • @user-db3oz7po9f
    @user-db3oz7po9f7 ай бұрын

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

  • @PranavVerma1608
    @PranavVerma16082 ай бұрын

    sir, how to make dropdown searchable?

  • @ManojPamnani-jj3no
    @ManojPamnani-jj3no3 ай бұрын

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

  • @dipasis.trustklub4381
    @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

    @KewalKishan

    Жыл бұрын

    Dear Dipasis, In Google Form, you can achieve it via Section based questions. Learn here: kzread.info/dash/bejne/fYWGsNBtdaaWhLw.html

  • @dipasis.trustklub4381

    @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?

  • @unsealedbrush
    @unsealedbrush7 ай бұрын

    What's the limit of this add on?

  • @mohammadalali419
    @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

    @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. :)

  • @umakant40422
    @umakant40422 Жыл бұрын

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

  • @KewalKishan

    @KewalKishan

    Жыл бұрын

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

  • @lochan544
    @lochan5445 ай бұрын

    Showing only help in form ranger after installing

  • @JASRIN1020
    @JASRIN1020 Жыл бұрын

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

  • @KewalKishan

    @KewalKishan

    Жыл бұрын

    Hi Jaswant, Upto 1000 items can be picked.

  • @ArunKumarSingh-OUPL
    @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

    @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

    @ArunKumarSingh-OUPL

    Жыл бұрын

    @@KewalKishan Thanks you so much

  • @irfannadra4437
    @irfannadra44374 ай бұрын

    Hello sir.. i have an issue

  • @vinodkumarPrajapativnd
    @vinodkumarPrajapativnd11 ай бұрын

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

  • @KewalKishan

    @KewalKishan

    10 ай бұрын

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

  • @vinodkumarPrajapativnd

    @vinodkumarPrajapativnd

    10 ай бұрын

    @@KewalKishan yes I see, thanks

  • @davidjtepper
    @davidjtepper9 ай бұрын

    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

    @KewalKishan

    9 ай бұрын

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

  • @user-bn9xu1ty5u
    @user-bn9xu1ty5u11 ай бұрын

    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

    @KewalKishan

    10 ай бұрын

    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 :)

  • @sheetswithsajid5158
    @sheetswithsajid5158 Жыл бұрын

    Kya google form main searchable dropdown ban sakty hay?

  • @KewalKishan

    @KewalKishan

    Жыл бұрын

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

  • @sheetswithsajid5158

    @sheetswithsajid5158

    Жыл бұрын

    @@KewalKishan Thanks❤

  • @wreSTLclub
    @wreSTLclub11 ай бұрын

    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

    @KewalKishan

    10 ай бұрын

    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

    @wreSTLclub

    10 ай бұрын

    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

  • @shinopaints6094
    @shinopaints6094 Жыл бұрын

    sir work nhi ka raha ha

  • @KewalKishan

    @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. :)

  • @April2023-fb6pf
    @April2023-fb6pf6 ай бұрын

    Form duplicate pliz

Келесі