Tech Tip # 86 - Create a google form that automatically fills and eliminates question choices

[@einSeelowe]

hi there. im currently testing this add-on, it's awesome.. Is there any way to change the options before submiting the form? i.e. you choose RED color, and with that selection a 2nd dropdown list change the colors derived from RED ---> PINK, ORANGE, PURPLE. (if you pick BLUE ---> LIGHT BLUE, GREEN, PURPLE; etc..)

[@omaraburaya1482]

Hello, is there an option to make it limited to a certain number of choices for example 5 reds maximum and then the choice gets eliminated ?

[@bravowhiskey7077]

this is excellent. it is simple and very useful.

[@K1llerQu33nBee]

Thank you so much for this tutorial! Helped us organize a secret santa here in the UK

[@laydeiwoodard1362]

This is a great video and it helped in a great ways. I'm actually trying to create a google form that once filled out, auto-populates responses from your previous submission the next time you open the form. This seems to be very difficult to find for Google Forms. Any insights would be greatly appreciated.

[@michellenobile4199]

Is there a way to have an option where someone can enter an answer, like their yearly income OR, if they don't know, select a "come back to this" so at the end of the questions, they will be shown the questions they didn't answer? It's easier for a long form to just skip a required answer and continue to answer, then come back to the questions later.

[@jerry1769]

Hey Tom, great info. However, I am trying to make a form that I can fill out when taking calls from potential customers. (Currently, I have a sheet that has about 40 fields of data - some I type in, some are drop downs and others I have a formula to auto populate other fields - aka price of package, additional people cost, ect) How can I select, say - Diamond Package and make it auto populate $400, and additional player fee of $22.50, ect? Also, would like to have it populate the data into my spreadsheet after I select submit?

[@dimo6871]

Hi, I wonder why my selected option is not eliminated.