Google Sheets Userform - Dependent Dropdown in a Web App

[@via.arvanh6045]

Hi, I just wanted to say thank you so much for this series! I have a background in mechanical engineering, software development and am looking to use it to start a fitness business! :) These videos are helping me to gain momentum and properly organize my data. Thank you so much, what was suppose to take me until the end of the year will only take me a few weeks now!!

[@everspader]

Super congratulations on all the video series. Sick content. You not only have a great teaching skill to explain what you are coding but you also go step by step on the flow of the code, which is something I haven't seen in any other videos. Keep up with the amazing work!

[@muhammedytunca]

Thanks a lot. I became addicted to your videos. 😅

[@raulrojas2777]

Thanks for sharing! Greetings from Paraguay!

[@ExcelGoogleSheets]

Thanks for watching!

[@Kevin-sr3ur]

Firstly, I must commend you for a very detailed and straightforward explanation, however, wouldn't it be more helpful for beginners if you offered access to the Google Spreadsheet and Script?

[@ravemanlex]

Thank you. This is exactly what I needed as reference

[@skarabayev]

Thanks a lot! You are making amazing things. Keep doing this. You made life easier.

[@nguyenthilananh3784]

What can i do if i want datalist in the Item Name, not the dropdown. because at some case, the list is really long to scroll down to pick item. It's better if we can type some text and field show the closest result

[@nguyenthilananh3784]

Also, my script does not get all the item from the limited sheet. is it because the size is too large. data size is about 400 row? Thanks very much for your time.

[@ianpropst-campbell6028]

Excellent tutorial! Always appreciate the content from this channel. Little bit stuck though. The items are populated when I select "fruits" (i.e. the first category), but nothing gets populated when I check "vegetables." So somehow the code works for the first dropdown item, but not for the second. Has anybody else had a similar problem?

[@Success.simplified_]

!!!! I used importrange function to copy a range from one sheet to another and I made some column in that sheet which were filled manually. how can i fix the manually/static filled data with the automatic/dynamic filled data?

[@piratestevebrown873]

Thanks for providing - excellently done! This is my first video and perhaps I am not familiar with your protocols, but to save trying to hand type from freeze-frame video images, is it possible to get a copy of the sheets with the scripts to reproduce and modify? Apologies if that is an inappropriate question or the content is available somewhere and I am just am not seeing it.

[@karlocamusgutierrez8931]

Hi man, first of all I want to thank you for these videos, I have to ask you to know if it is possible to create two dependent dropdown that are based on the same dropdown, If possible, what is the best alternative to solve this problem?

[@littleclover2334]

Thank you for this tutorial. However I have a question. How to auto populate information based on drop down selection to be automatically saved in their respective tabs. Like if i choose a student(A) in the dropdown list. All the information that i entered in the form will be saved on the student(A) tab?thanks

[@anupsoni9764]

Thank sir 👍 this help me lot , r u published books for the same if yes please inform

[@TheCloudMage]

Hi, Great Videos. Really helpful. I faced a minor problem while following the instructions el.innerHtml = ' '; (or) el.innerHtml = ' did not clear the existing dropdown options. el.options.length = 0; (or 1 in my case with a default disabled option) worked.

[@ExcelGoogleSheets]

innerHTML it's case sensitive

[@hunnyshah9885]

I tried both ways, but still stuck with all options, unable to derive dependency. Would appreciate your help

[@giamar3026]

Hi my favorite youtube teacher! Have a question for you. I apply this functionaly to a form, all is going well unless you entry from a MAC computer, do you know something about this error?. I remember some functions in VBA excel doesn't work on MAC, could be something like this? and in this case do you have other video with other method to add to a form a dropdown dependent? Thank you very much, as always

[@ExcelGoogleSheets]

Works fine for my Mac. Gotta be something else. Make sure you're logged in with the right account.

[@giamar3026]

@@ExcelGoogleSheets Thank you. I think is an onclick inside html that call a function to upload the data on the firstDropDown to a textBox. I could not use the eventListener on my system where i have the form with the dropdown inside, i think because i built this system with HtmlService.createHtmlOutputFromFile and you work here with HtmlService.createTemplateFromFile at the doGet, so i have to call onChange function and also onclick added from html, and it work fine from windows but not from MAC could it be posible?

[@ExcelGoogleSheets]

No, this is all happening on the server side, so it would not have anything to do with Mac or Windows.

[@romainbeytout2250]

Hi, thank you so much for this video and for all the others !! So wonderful, I love it! I have a question, would it be possible to add a third dependent dropdown ? I tried but unfortunately it's not working... I know you published another video about this subject but it's not coded the same way... It would be wonderful if you could help me. And thank you again !!!

[@mayanktripathi4u]

Thanks for sharing informative video. Please do help, I am using separate HTML / JS file (not the .html file from App scripts), and getting below error for "google.script.run.withSuccessHandler(loadObject).getObject();" Error : "Uncaught TypeError: Cannot read properties of undefined (reading 'run') at window.onload"

[@ExcelGoogleSheets]

There is not google.script.run in your browser, so that would never work. I have a video on my other channel where I create JSON api from google sheets and then use external HTML/JS to interact with that API. You might want to check that out instead. Channel name is Get __it done!

[@bulbulahmed3098]

Sir Excellent

[@ExcelGoogleSheets]

Many thanks

[@tanveerhussain3881]

Nice

[@education951]

Thank you for a very comprehensive tutorial series. As a follow-up, I'd like to ask how to dynamically create a pre-filled via URL. Call it item-category in your tutorial I changed it to item-email (.../exec?item-email=EMAIL). I have tried it and it doesn't work. Did I miss something?

[@ExcelGoogleSheets]

I'd use google.script.url and fill the fields with front end javascript developers.google.com/apps-script/guides/html/reference/url

[@education951]

@@ExcelGoogleSheets Thank you for your advice. I'll give it a try although I'm not sure I can understand how, especially regarding dropdown lists

[@khanyameyiswa1356]

Sir I'm still an intermediate in Web Apps and Scripts. I did the adding of the dropdown but when I was doing the dependent dropdown my code is running but does not seem to be working. The dropdowns are not appearing anymore. Even the button now it's not working. The code is exactly the same. I don't know what might be wrong.

[@umairsarwar1066]

Did you find Solution for this Problem?

[@acestar17amc]

Can we request a copy of the scripts you used here?

[@farhanmuntaqo]

I really want something like this to be able to works with Google Forms. Dynamic choices based on previous answer.

[@ExcelGoogleSheets]

This won't work in a regular Google Form. But you can deploy this as a Web App and then use it as a replacement.

[@devx0]

Hey man, first I wanna thank you for the great effort and the lovely content you give. as I am following you long since the beginning. I have to ask about 2 things is there is any way that we can build our own translation method " NOt Google translate inside the sheet or using the google script API, is there's anyway I can set a func to a cell or a range without inserting it to the cell it self using google script? once again thanks and hopefully you read this

[@ExcelGoogleSheets]

There is probably a way, but I don't exactly understand what you're trying to do.

[@devx0]

@@ExcelGoogleSheets Iam trying to have my own translator like =googletranslate but my own dictionary , vlookup is not the best option since I might have more than once content in the cell

[@ExcelGoogleSheets]

kzbin.info/www/bejne/iYbWaGekrKuAfLs

[@devx0]

@@ExcelGoogleSheets thx man for this but unfortunately I need to have my own translator not google translator, can I build my own dictionary using google app script?

[@ExcelGoogleSheets]

So the answer is yes, however, building a dictionary is not a simple task. People have entire teams working on dictionaries for years and they still can't get it right.

[@Dr.DanhVinh]

Please do drop down for the Web App - Google Sheets CRUD

[@admatt32]

Hi.i'm just starting subscribe your chanel for 1 week and I really like your clips but I just have some problems with my code. I wrote dynamically add/remove rows but I can't submit data fields to spreadsheet. Can you give me some advice please. Or just reply me with some clips that would help me a lot. Thank you.

[@ExcelGoogleSheets]

Please share your code here. I'll try to see if I can spot the problem.

[@admatt32]

​@@ExcelGoogleSheets This is some part of my code (I'm just start coding btw) Use Add or Remove Input Fields Dynamically using jQuery - MyNotePaper by Md Obydullah แบบฟอร์มความต้องการสิ่งของบริจาคและที่ได้รับบริจาค ชื่อหน่วยงาน: กรุณาระบุหน่วยงานของท่าน สถานคุ้มครองและพัฒนาคนพิการบ้านเฟื่องฟ้า สถานคุ้มครองและพัฒนาคนพิการบ้านราชาวดี ชาย สถานคุ้มครองและพัฒนาคนพิการบ้านราชาวดี หญิง

[@admatt32]

ลบแถว เพิ่มข้อมูล // add row $("#addRow").click(function () { var html = ''; html += ''; html += ''; html += ''; html += ''; html += ''; html += 'ลบแถว'; html += ''; html += ''; $('#newRow').append(html); }); // remove row $(document).on('click', '#removeRow', function () { $(this).closest('#inputFormRow').remove(); });

[@admatt32]

ลบแถว เพิ่มข้อมูล ส่งข้อมูลทั้งหมด // add row2 $("#addRow2").click(function () { var html = ''; html += ''; html += ''; html += ''; html += ''; html += ''; html += 'ลบแถว'; html += ''; html += ''; $('#newRow2').append(html); }); // remove row2 $(document).on('click', '#removeRow2', function () { $(this).closest('#inputFormRow2').remove(); }); ลบแถว เพิ่มข้อมูล ส่งข้อมูลทั้งหมด // add row2 $("#addRow2").click(function () { var html = ''; html += ''; html += ''; html += ''; html += ''; html += ''; html += 'ลบแถว'; html += ''; html += ''; $('#newRow2').append(html); }); // remove row2 $(document).on('click', '#removeRow2', function () { $(this).closest('#inputFormRow2').remove(); }); I have submit button but i don't know how to code it.

[@ExcelGoogleSheets]

The accurate way to approach it will be the last video in the current series. The question is, where do you want the information from all those inputs fields to go? So say they add 5 input boxes and enter some information in each, how should that information appear on the spreadsheet?

[@91bast]

Hi ! first, thanks so much for your tutorial. But i used your code and i have a big problem ! In my "getDropDownArray" function, I tried to add a lot of columns, it works until 20 columns. For more, my javascript's arraysOfArrys is considered null... I DON'T UNDERSTAND!! Anybody got a solution please ??? in my

[@91bast]

I finnaly found it... my data base had some numbers formated with € symbol ... now it's ok

[@JLsantos1995]

Hi sir can i ask for the source code or google sheet file of the tutorial?

[@CuongNguyen-lz1bq]

I just want tell you that Thanks very much

[@aneeshtech416]

Thanks

[@jainishsantoki1803]

Hi, watching your videos I learn a lot, for my project, I want to add a dependent dropdown which can collect data HORIZONTALLY and create a dropdown list. How can I do that?.

[@lb4082]

PLEASE HELP Ugh!!! Can you (or anyone) please give me a copy of this script please. I watched all 4 videos and followed along(multiple times, but I'm messing something up)

[@ExcelGoogleSheets]

What's the code you have?

[@lb4082]

@@ExcelGoogleSheets OMG you responded!! Actually..I was having issues with another video."GAS dependant dropdown with user interface side panel and bootstrap... But I finally got it! I only had to watch it 1 million times! I had a parentheses in the wrong place and now I know why it's so important that thing's highlight! Anyways, I'm obsessed with your vids! More please :)

[@viditnagory5280]

Thanku sir ji, please fill script link available in your video description basic google form dependant dropdown hmtm and js all script etc Thanks & Regards Jiten

[@superjaw]

Like

[@vladk.6589]

Лайк подписка бубенцы

[@pichit.raetai]

Follow