Call Google Apps Script Function from Web App using Google Sheets

[@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

[@sulaimang5517]

Hi Curt, Thank you. Absolutely Brilliant!!!

[@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.

[@aday0123]

Thank you for your video, it really helps!

[@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]

kzbin.info/www/bejne/bJWniZSKhZp1ndU 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; }

[@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

[@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.

[@_ranjit_patil]

Redio voice