Call Google Apps Script Function from Web App using Google Sheets

[@sulaimang5517]

Hi Curt, Thank you. Absolutely Brilliant!!!

[@aday0123]

Thank you for your video, it really helps!

[@CodeWithCurt]

HTML and Javascript Code in Video Below:

function callOneCellData()
{
google.script.run.withSuccessHandler(function(returnData)
{
document.getElementById("oneCellData").innerHTML = returnData;
}).getOneCellData();
}
function callMultiCellData()
{
google.script.run.withSuccessHandler(function(returnArray)
{
console.log(returnArray);
var stringArray = returnArray.toString();
document.getElementById("multiData").innerHTML = stringArray;
}).getMultiCellData();
}
function callInOutData()
{
var inData = document.getElementById("inData").value
google.script.run.withSuccessHandler(function(outData)
{
document.getElementById("outData").innerHTML = outData;
}).getInOutData(inData);
}
function callData()
{
callOneCellData();
callMultiCellData();
callInOutData();
}

One Cell Data
Multi Data
In Data
Out Data

[@bumpersmith]

You have some of the best subjects on youtube for google sheets and app scripts.
What other's are not doing including yourself is providing subjects utilizing the popular Google Sites , Google Forms, Sheets and Docs together. Why not use the structure of the new Sites which is so flexible and popular to present the data and information? This is a subject few others have hit on but many viewers I am sure would like to utilize. Anyone with sound examples with Sites and Apps Script would set themselves apart in the Google world.

[@arviscesnieks244]

Thank Curt for explaining an example. Is it possible getdata from a spreadsheet image?

[@littleclover2334]

Hi Curt! Thank you for your videos! I learn a lot. I have a question though. I made a form using the google apps script and i made a dropdown list. My question is how to save the informations i entered in the form on the respective tabs based on the dropdown selection? Example i choose Student A on the dropdown list. All information i entered on the form will save on Student A's tab/sheet. Thanks in advance

[@CodeWithCurt]

th-cam.com/video/6dDXaTP5Bgs/w-d-xo.html
In this video I have a dropdown where I call a google apps script from what is selected from the downdown. Let me know if this helps.

[@littleclover2334]

@@CodeWithCurt thank you for your reply. I will definitely apply it to my form. Thanks again

[@CodeWithCurt]

Google Apps Script Code in Video Below:
function doGet(e) {
return HtmlService.createHtmlOutputFromFile('WebApp');
}
function getOneCellData() {
var ss= SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName("Sheet1");
var data = sheet.getRange('A1').getValue();
return data;
}
function getMultiCellData() {
var ss= SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName("Sheet1");
var data = sheet.getRange('A1:C1').getValues();
return data;
}
function getInOutData(inData) {
var outData = "IN DATA: " + inData;
return outData;
}

[@AgendaBioBioCL]

How i delete "This aplicattion was created..." message?

[@francismata4492]

hoping you can share your file and code

[@CodeWithCurt]

If you have trouble finding the code in the comments try this:
-In the comments section, try clicking on 'SORT BY' then clicking 'NEWEST FIRST' and see if they show up.

[@nurasian7355]

Great, please share with we code.

[@CodeWithCurt]

Code is posted in the comments below the video

[@francismata4492]

@@CodeWithCurt no code. please can you share it?

[@CodeWithCurt]

If you have trouble finding the code in the comments try this:
-In the comments section, try clicking on 'SORT BY' then clicking 'NEWEST FIRST' and see if they show up.

[@SunilKumar-ob6vs]

Can anybody help how to call Value ABC in indivisual Text box 1,2 nd 3 like one cell data function pls anyone

[@_ranjit_patil]

Redio voice