Google Web App - Create Dependent Drop Down

[@tanveerhussain3881]

World's Best Teacher
Best Quality
Learn Easy and Understand
I Love And Like All Video

[@zedkrimo]

bro u r the best , u made every thing easy and u got me all what i was looking for
i really dont know how to thank u

[@prasathsmart4091]

I have one doubt bro why after submitting the answer did not show in Google sheets pls tell me bro

[@CharteredAccountantGR]

Fabulous work done by you
Thanks a lot 😄😄😄

[@arshadraza1891]

Bro, you are great, what a wonderful way to make dependent dropdown, Can you plz guide how to add more than one dependent dropdown .

[@ricksamo]

Very cool project. would the search look for a database of 3,000 data? Thanks for sharing your knowledge.

[@gsheetssolutions]

Tried to copy the code but I'm getting an error Cannot read property 'toString' of undefined. Why is that? And can we make the Fruit also unique in case there's a duplicate entry?

[@bramuditosotyabaskoro2389]

amazing explaination! keep it up!

[@rafisir2679]

Sir your videos amazing.Sir Please create add or remove multiple input fields in google script

[@MrCarolciciliato]

Hi
Thanks for this! Very good.
I am actually looking for to do this with a dropdown box instead of a select. I am able to get the select box, however I do not know the javascript code to add the selected option into the google sheets. Thanks

[@gayatriushir1265]

Hi !
Thanks for the video.
Can we insert scroll button like to do next value for drop down list by app script?
Please help.
Thank you in advance.

[@CharteredAccountantGR]

Fantastic work thanks a lot 😊😊😊

[@danielcir8675]

Hi Curt, all your videos amazing, one suggestion if I may, could you please upload them in 1080P? Thank you, sir!

[@CodeWithCurt]

Thanks for the suggestion. I will look into it.

[@CodeWithCurt]

Google Apps Script Code in Video Below:
function doGet(e) {
var htmlOutput = HtmlService.createTemplateFromFile('DependentSelect');
var colors = getColors();
htmlOutput.message = '';
htmlOutput.colors = colors;
return htmlOutput.evaluate();
}
function doPost(e) {

Logger.log(JSON.stringify(e));

var name = e.parameters.name.toString();
var color = e.parameters.color.toString();
var fruit = e.parameters.fruit.toString();

AddRecord(name, color, fruit);

var htmlOutput = HtmlService.createTemplateFromFile('DependentSelect');
var colors = getColors();
htmlOutput.message = 'Record Added';
htmlOutput.colors = colors;
return htmlOutput.evaluate();

}
function getColors() {
var ss= SpreadsheetApp.getActiveSpreadsheet();
var lovSheet = ss.getSheetByName("LOV");
var getLastRow = lovSheet.getLastRow();
var return_array = [];
for(var i = 2; i

[@safasbitan885]

Hi thank you tbe code is easy to understand , how to add another level to get the rest of the cells in that row

[@cheslg6809]

How do I send confidential data (e.g address, bank details) from web app to google sheet? Is there a line of code I need to change?
Also can you do tutorial about successhandler for select options instead of using long 'for' scriplets on html as stated in best practices of gs for web apps? Thanks

[@tiraphan]

If editing to have a list of 3 levels, what to do? Can you recommend it? Thanks

[@ConsulthinkProgrammer]

Yes you could do that.

[@bramuditosotyabaskoro2389]

keren mama mu pasti bangga!

[@MLGoldhighlights00]

Can this be done in excel online forms? Or does it only work with google sheets

[@sirmacademy]

How do include the email of the person who answered it?

[@managementjulahaasarees8575]

if using three dependent drop down then which code using

[@mdhare1515]

hello,
need your help to create a dependent dropdown in *google form* in 1 single section,using data or dependent dropdown menus from a google sheet. please guide me or if possible make a video on it.
P.S : Don't want to use logic based section shuffle or *form ranger* or *cascade formatting*.
thanks in advance

[@tvofficial8825]

how to get the dropdown list data in alphabetical order please any help for this
in the given sheet it was started with red even after giving in alphabetical order also it was resulting unevenly in order so, if any one finds the solution please help me in this google scripting

[@filibertodurangarcia1975]

Can we add more dependencies?

[@Rolroorlo]

How can we do this with bootstrap?

[@definetourskalkanairporttr5192]

Hi sir, i just need drop down menu, not dependent Drop down also that dropdown selection need to texted to google sheets? Do you have a video of it? Thanks

[@googleuser6404]

Have you tried Google Forms.

[@raulalfredohuamansauni1955]

Felicitaciones

[@SabanaYasmin-we3ql]

how to prevent re submission of form when reloading the form

[@bmtechothxi2777]

Thank you so muchhhh

[@prasathsmart4091]

Y submit button didn't access Google drive

[@revathiguguloth3990]

Hi sir, can I know ur website

[@CodeWithCurt]

HTML File DependentSelect Code Below:



function GetFruit(color)
{

google.script.run.withSuccessHandler(function(ar)
{
console.log(ar);

fruit.length = 0;

let option = document.createElement("option");
option.value = "";
option.text = "";
fruit.appendChild(option);

ar.forEach(function(item, index)
{
let option = document.createElement("option");
option.value = item;
option.text = item;
fruit.appendChild(option);
});

}).getFruits(color);

};



Web App Dependent Drop Down

[@tareqalsultan]

Go