Google Forms - Populate Options on Questions From Google Sheets

Поділитися
Вставка
  • Опубліковано 12 гру 2021
  • In this video, I demonstrate how to take options on a Google Sheet and populate those options onto Google Forms Questions using Apps Script. Video, Code, and Documentation can be found at codewithcurt.com/populate-opt...

КОМЕНТАРІ • 59

  • @crisbartlett3088
    @crisbartlett3088 2 роки тому +7

    Thanks! I've watched several of your videos and can't thank you enough! Especially grateful for the copies of the script you provide. For a non-tech person, this has saved me not only time but $$. Much appreciated.

  • @H-do8tr
    @H-do8tr 2 роки тому +2

    Good! But how can I make a searchable drop down list?

  • @BowenSQP
    @BowenSQP 2 роки тому +2

    I would second the comment below- could you please share the code for populating a spreadsheet to a check box or other form question set-up?

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

    I only need to populate questions from sheets, is it possible? If yes please help me with codes. Please!

  • @wemiotubusin8638
    @wemiotubusin8638 4 години тому

    How does one populate a check box(with sheets0 based on an answer of a previous question asked in a form?

  • @goochiebrooks8911
    @goochiebrooks8911 2 роки тому +2

    Can you have a set of questions to populate based on the response from a drop down list?

  • @americansecurityironworks7000
    @americansecurityironworks7000 2 роки тому

    I want to create something similar with the option that if you pick option A then question 1, 2 & 3 will pop out, if I choose option B question 4, 5 & 6 will pop, can you advise please

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

    very good, but bit complex for someone with no coding knowledge. any easier way

  • @joaopaulolemosbenevides1679
    @joaopaulolemosbenevides1679 Рік тому +2

    Do you know how i can populate a question based on previous answer? Let's say i want to know the city in which you live in, so first I ask the State and then the list of cities that will show will be the cities of that specific state.

  • @FazlulHaque77
    @FazlulHaque77 2 роки тому

    In google Form how can I validate email addresses against a list of 10 thousand email address list stored in a Google Sheet? Is there any app script or video you can refer to? Thanks in advance

  • @jeffs7153

    How to have multiple sections with different question types? Or even the same question type..

  • @ronvynzerdevera2547

    Nice! Thank you. Is there a way i can apply this on dropdown questions?

  • @darvzglen14344

    Is there a way that we can add another filled in the form that will also layer an "if" or "if else" options? For example, if I will choose 1 the next filled will automatically put Mine, if I choose 2 it will automatically put Yours.

  • @Anhttse02596

    In a google form I have many questions. How do I format each question to my liking?

  • @BraveHeart-ht8zf

    If the contents of the dropdown list are large, can the search function appear on Google Forms?

  • @gundars13

    getQuestionValues @

  • @huhummmmmmm

    Can you populate the form further down based on user selections in multiple questions above?

  • @marythomas6478

    Oh my gosh! It worked! Thank you very much.

  • @silmasellsmore.realtor

    Where is it that we copy the code from on

  • @shawnireland2926

    Sections (Invalid conversion for item type: PAGE_BREAK) breaks this code, any way to account for having questions in different sections?