Dynamically Populate Google Form's Dropdown using Google Sheets

Поділитися
Вставка
  • Опубліковано 1 лис 2024

КОМЕНТАРІ • 37

  • @fredbowers5766
    @fredbowers5766 10 місяців тому +2

    This to me, is elegant programming. I will learn much from your lesson. It looks like a great way to create forms that work right. I will let you know how it goes. I'm just learning these forms. Thanks

    • @tech-lever
      @tech-lever  10 місяців тому

      Glad it was helpful!

  • @josesoraca4625
    @josesoraca4625 5 місяців тому +10

    the sheet is not public

  • @FrederickRooney
    @FrederickRooney Місяць тому

    this is great!!
    Will it work in the field on an android device?

  • @HansieJGEWP93
    @HansieJGEWP93 12 днів тому

    This is really well explained, thank you.
    Is there anyway to automatically update the form dropdowns when the form is opened?

    • @tech-lever
      @tech-lever  12 днів тому

      Yes. You can watch my other video title Auto Update Google Form. I think this will fullfill your requirement.

  • @RobertoMarzocchi
    @RobertoMarzocchi Місяць тому

    thanks. The video and link are very useful!!

    • @tech-lever
      @tech-lever  Місяць тому

      Glad it was helpful!😊

  • @johnjuliusc
    @johnjuliusc 26 днів тому

    Thank you @TechLever

  • @nileshkapadia4722
    @nileshkapadia4722 26 днів тому

    How did you add the button for "Update Google Form" - I did not understand how to do that - please explain.

    • @tech-lever
      @tech-lever  25 днів тому

      By inserting drawing and then attaching script to it,

  • @shortklipmovie
    @shortklipmovie 11 місяців тому

    How to create an input form with response validation from data in a spreadsheet?

  • @downthelinett
    @downthelinett 3 місяці тому +1

    is it possible to update the dropdown list of 2nd dropdown based on selection from dropdown list 1?

    • @tech-lever
      @tech-lever  3 місяці тому

      If your list is small then you can use Dependent Section approach. You will find that video in my channel page. Otherwise you will have to use Custom form. Again you can explore my channel page for the relevant video.

    • @shikhasandeep-cd7tl
      @shikhasandeep-cd7tl Місяць тому

      please share the solution with me, if you found.

  • @timesavertricks
    @timesavertricks 11 місяців тому

    Kindly provide the script (link ) to populate google form

  • @Banny0405
    @Banny0405 Місяць тому

    How long does access to the sheet take to grant?

    • @tech-lever
      @tech-lever  Місяць тому

      I have changed the share settings.

  • @EquipmentOfficer
    @EquipmentOfficer 5 місяців тому +2

    Someone has edited your original form/spreadsheet and broken it, can you please re-upload the original form/spreadsheet

    • @tech-lever
      @tech-lever  5 місяців тому

      Ok. I will check that.

    • @infinity-skies1207
      @infinity-skies1207 Місяць тому

      @@tech-lever any follow up on this? there is still no way for copy-pasting, or even opening it. Could you allow it to be viewed? Thank you!

    • @tech-lever
      @tech-lever  Місяць тому

      @@infinity-skies1207 Please check the description box again. Its allowing to make a copy of the form as well as the Spreadsheet. Btw the code resides in the Spreadsheet.

    • @JasonAndersen-g8k
      @JasonAndersen-g8k Місяць тому

      @@tech-lever The form is still broken. I would like to see the form so I could see how you connect the Checkbox, List, and Multiple_Choice.

    • @tech-lever
      @tech-lever  29 днів тому

      @@JasonAndersen-g8k There is no script attached to the form. It connects by the question title.

  • @jmcgroddy
    @jmcgroddy 4 місяці тому

    Can this be automated to update the google form whenever the google sheet is updated

    • @tech-lever
      @tech-lever  4 місяці тому

      Yes. Go to my channel page. You will see the required video.

  • @malik373
    @malik373 3 місяці тому

    Hello, I love this video however, when attempting to modify an entry automatically right after the submit button is pressed, the field that I'm trying to modify the entry doesn't show anything. How can I modify the code so that I can get the field to automatically update for me

    • @tech-lever
      @tech-lever  3 місяці тому

      I have got another video titled Auto Update Google form. That will work for you.

    • @malik373
      @malik373 3 місяці тому

      @@tech-lever Thanks so much for the quick response. I am using this vid solution because I have external emails in a file that the dropdown is pulling from. I've tried to use the functions from the other vid you recommended but no matter the trigger event...change or insert, nothing seems to be happening when I try to change the value of the field in question.

  • @sumanthmudraveni1565
    @sumanthmudraveni1565 11 місяців тому

    I want google form dropdown like fruits, vegetables, non veg
    Based on selected option the 2nd drop-down has to show the details

    • @tech-lever
      @tech-lever  11 місяців тому

      If you want Dependent drop-down then refer my other video tilted Dependent section form.

  • @alimoursi5454
    @alimoursi5454 Місяць тому

    sheet access denied

    • @tech-lever
      @tech-lever  Місяць тому +1

      You should make a duplicate copy of the Spreadsheet. Hope it helps

  • @folsterfarms
    @folsterfarms 11 місяців тому +1

    These AI voices are getting better…

    • @tech-lever
      @tech-lever  11 місяців тому +2

      Thanks. And it's quite useful for person like me having difficulties in correct sentence framing and articulation.

    • @folsterfarms
      @folsterfarms 11 місяців тому +1

      @@tech-lever I can relate… I often have to translate things into Vietnamese

  • @digvijay9584957090
    @digvijay9584957090 8 місяців тому

    i need some help here to advance this script in 3 ways 1. item must be searchable in menu 2. dropdown/list must be dependent to previous option ( in google sheet data columnwise dependency on the basis of A column B filtered, then on the basis of B column C filtered and so on.) 3. In drop down Add option must be if option not found.