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

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

TechLever

7 месяцев назад

5,780 Просмотров

In this video I will show you how you can dynamically update your Google Form's Dropdown, Checkboxes, Multiple choice questions using Google Sheets. You can also update you form whenever new data gets added.
#googlesheets #appsscript #googleform #form #mutiplechoicequestion #quiz #quizquestions #quizzes

☕️😊 Buy me a coffee! ☕️💖
https://buymeacoffee.com/pritamsharma
https://paypal.me/pritamsharma45
-------------------------------------------------------------------

🔗 Spreadsheet Link:https://docs.google.com/spreadsheets/d/1X1Chj99muhrCO3rj-yvXL0UN8SrUoiGK10NDl2Iajsw/copy
🔗 Google Form Link: https://docs.google.com/forms/d/1eJ_p5s3_pXzbgxSkrYHoZIR3lZGfjyhWZFfnCRon2Jg/copy
🔗 Spreadsheet Link for getting Countries and States:
https://docs.google.com/spreadsheets/d/1fHEnfPMqHatichpTbceSElj_xTkidCznrSVtDkuTOVk/edit#gid=1493849997
Ссылки и html тэги не поддерживаются


Комментарии:

@folsterfarms
@folsterfarms - 16.11.2023 12:43

These AI voices are getting better…

Ответить
@shortklipmovie
@shortklipmovie - 18.11.2023 15:33

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

Ответить
@sumanthmudraveni1565
@sumanthmudraveni1565 - 22.11.2023 15:15

I want google form dropdown like fruits, vegetables, non veg

Based on selected option the 2nd drop-down has to show the details

Ответить
@timesavertricks
@timesavertricks - 03.12.2023 06:26

Kindly provide the script (link ) to populate google form

Ответить
@fredbowers5766
@fredbowers5766 - 27.12.2023 03:14

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

Ответить
@digvijay9584957090
@digvijay9584957090 - 28.02.2024 09:31

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.

Ответить
@EquipmentOfficer
@EquipmentOfficer - 07.05.2024 14:20

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

Ответить
@josesoraca4625
@josesoraca4625 - 04.06.2024 00:23

the sheet is not public

Ответить
@jmcgroddy
@jmcgroddy - 26.06.2024 10:06

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

Ответить