Dynamically Populate Google Form's Dropdown using Google Sheets

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

КОМЕНТАРІ • 40

  • @fredbowers5766
    @fredbowers5766 11 місяців тому +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  11 місяців тому

      Glad it was helpful!

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

    the sheet is not public

  • @PassagesIntern1
    @PassagesIntern1 7 днів тому

    Thanks! This is very helpful. Is there a way to have the headers dynamically populate on the form if you want to add additional questions?

    • @tech-lever
      @tech-lever  6 днів тому +1

      I think yes

    • @PassagesIntern1
      @PassagesIntern1 5 днів тому

      @@tech-lever Thank you! I essentially want to do exactly what your video shows; however, I'd like it to pull the header information into a form too. What would be the change in script? Thank you in advance

  • @FrederickRooney
    @FrederickRooney 2 місяці тому

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

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

    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  Місяць тому

      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!😊

  • @shortklipmovie
    @shortklipmovie Рік тому

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

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

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

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

      By inserting drawing and then attaching script to it,

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

    Thank you @TechLever

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

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

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

      Ok. I will check that.

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

      @@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  2 місяці тому

      @@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  Місяць тому

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

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

    Kindly provide the script (link ) to populate google form

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

    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  4 місяці тому

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

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

      @@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 Рік тому

    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  Рік тому

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

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

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

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

      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 2 місяці тому

      please share the solution with me, if you found.

  • @Banny0405
    @Banny0405 2 місяці тому

    How long does access to the sheet take to grant?

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

      I have changed the share settings.

  • @jmcgroddy
    @jmcgroddy 5 місяців тому

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

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

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

  • @alimoursi5454
    @alimoursi5454 2 місяці тому

    sheet access denied

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

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

  • @folsterfarms
    @folsterfarms Рік тому +1

    These AI voices are getting better…

    • @tech-lever
      @tech-lever  Рік тому +2

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

    • @folsterfarms
      @folsterfarms Рік тому +1

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

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

    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.