Create Multi Select Web App on Google Sheets

[@ricardocalcina2398]

This is pretty cool! Another way would be to use google forms, and link it to a spread sheet. This would be something your could share by email or embed on website to log results.

[@jayasri-ft8040]

Thank you so much bro. Similarly I request you to provide single selection html. Nice bro.

[@generatrendgt1790]

Great Tutorial! Can you build a script with master/details insert data into sheet?

[@CodeWithCurt]

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

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

var name = e.parameters.name.toString();
var colors = e.parameters.colors.toString();

AddRecord(name, colors);

var htmlOutput = HtmlService.createTemplateFromFile('MultiSelect');
htmlOutput.message = 'Record Added';
return htmlOutput.evaluate();

}
function AddRecord(name, colors) {
var url = ''; //URL OF GOOGLE SHEET;
var ss= SpreadsheetApp.openByUrl(url);
var dataSheet = ss.getSheetByName("DATA");
dataSheet.appendRow([name, colors, new Date()]);
}
function getUrl() {
var url = ScriptApp.getService().getUrl();
return url;
}

[@nurasian7355]

Thank you. How to create multi dependent drop-down with Google Apps Script. Thank you.

[@rightangle1946]

I need multiple row data submit by one click from web app. please try!

[@SMARTBOY-ri8sz]

How save local host multi selected data in google sheet

[@CodeWithCurt]

HTML File MultiSelect Code in Video Below:




Web App Multi Select