Google Forms - Drop Down List from Spreadsheet Using Apps Script

Показать описание

Learn how to update Google Forms dropdown lists from Google Sheets spreadsheet values using JavaScript & Apps Script.

#googleforms #dropdown #Spreadsheet

Рекомендации по теме

Комментарии

This will have better workflow than having to update both the sheet and the form everytime a dropdown is updated.
With your script, you just update Sheet's options list then run the script and you'll have consistent sheet and form data.
Great job - Thanks!

richardmhain

Really good teaching style, casually explaining your logic as you type makes it easy to follow.

FIRE_EVERYTHING

Been my long time question's journey.. finally someone has the answer..very helpful..many thanks..

MrTotokf

I watched 3 tutorial videos before this.... this one helped me a lot.... thanks!

DennisBuccat

I love your easy teaching style! Very easy to follow. The step by step troubleshooting is amazingly informative. Thank you!

SilverfoxTOAO

This is really my favorite channel. Much appreciated.

bellbenefitsgroup

Wonderful! You've answered my request!! :))
This has helped me a lot, and I'm very grateful.
Hopefully it helps many others as well.
And as always, excellent explanation.
Thank you! Thank you!!
(...but now I undestood your suggestion to use Web app instead...)

rogersantoyo

Thanks for this video, I had an issue with repeated data values, because I was using last names. but I used concatenate and merged first and last names and it worked like a charm...

hanshernandez

Great teaching skills means a great person! Awesome tutorials! Thank you

hadireg

I'm still very new to App Script and learning JS right now to help improve upon what I can do to make things where I work more efficient and automated. I've learned so much from your video's. Just wanted to send a little something to say thanks.

GeekyDad

Thank you for this clear step by step explanation. I am selftaught myself, but your explanation took away a lot of the guess work when trying to code. Thanks for explaining why you code certain things you do. THis will be very useful for all my other type of coding!

litening

They have an add-on called Form Ranger which can do this now.
I am really thankful to you for making this video though.

Avi

Very Informative Tutorial, Thanks for Sharing 👍

I request you to please make a tutorial on response through a trigger on form submit with the relevant results in an email.

Hope to see this in your next video.

Regards

i.k.shaikh

Great guide - I've adapted this with alert dialogues to push changes to forms. Thank you! The next update will be to allow the user to choose what type of data is in the form, and then update accordingly - Dropdown or Radio Button

TanveerChandok

Your tutorial style is impressive it can help both beginners and seniors.

kivancaktas

This tut deserves a " subscribed"!

carlosmiquelkoivula

Thank you for the effort. This is a good starting point for me when I'm trying to grab data from a spreadsheet to prepopulate a form. That said, this is a bit too complex for someone who just wants to grab values from a single column in a spreadsheet and put them in a single question in a form. A much simpler and more straight-forward tutorial should be more helpful.

amirsyafrudin

Hi, Thanks for this tutorial. It was really helpful. I have a spreadsheet with thousands of unique ids call them emp IDs. Now I want to put a validation that inputs given by any google form user must be validated from that emp ids in spreadsheet. Currently they are putting it manually. Even if I create a dropdown as explained here, it will be difficult for them to search from thousands of IDs and select correct one. Your help is really appreciated.

atulsrivastava

You teach quickly and efficiently, your lessons answer all my questions and allow me to move forward quickly. And in addition it is a real pleasure to watch your videos. Even I like reading articles, learning through your videos is great and fast, to my opinion. Thanks thanks thanks !

flyjodel

Why still GAS community soo small? And VBA still VERY HUGE!!!

homejonny

Google Forms - Drop Down List from Spreadsheet Using Apps Script

Dynamically Populate Google Form's Dropdown using Google Sheets #googlesheets #googleform

How to add dropdown menu in Google Forms

How to add dropdown menu in Google Forms

Google Forms - Drop Down List from Spreadsheet Using Apps Script

How to build Conditional Dropdowns in Google Forms

Automate Google Form Drop Down Menu | Google Forms - Create Dropdown Lists

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

Dropdown Questions in Google Forms

Create Email Signature with Hubspot Email Signature Generator

Google Forms - Create Dropdown Lists and Multiple-Choice Questions from Google Sheets

Dependant dropdown list google form | Cascade dropdown list |Dynamic Dependent dropdown list

Create a drop down list in Google Sheets

How to add Dropdown list in Google Sheet? ( In 20 Seconds) | Data Validation trick #shorts

Use Drop Down when more than 4 options in Microsoft Form

Don’t Use Google Forms Without These FREE Add-Ons!

Google Forms Dynamic Drop-Down List from Google Sheets in Google Form || Form Ranger Add-ons in form

How to Create Google Forms with Conditional Logic (Branching Questions)

Google Forms - Populate Options on Questions From Google Sheets

Enable Multiple Dependent Dropdown in Google Forms:GAS071

How to Create a Drop-Down List in Google Sheets

Drop Down list in Google form

Create an HTML Form Dropdown from a Google Sheet using Google Apps Script

Google Web App - Create Dependent Drop Down

How to Add a Dropdown List for data validation in Google Sheets