101 Apps Script Publish As Web App

101 Apps Script Publish As Web App

.

101 Apps Script: Publish As Web App

Objective:

This tutorial demonstrates app script that is attached to a spreadsheet.

If you want to run a standalone, jump to Step no 3.

1. Create Google Spreadsheet.

Give a name eg 101appdata.

2. Create App Script.

In Google Spreadsheet, go to menu and select Tools/Script Editor.

Gine a name eg 101appdatascript.

3. Add startup codes.

/*script id*/ var SCPID=ScriptApp.getScriptId(); /*active spreadsheet */ var SST=SpreadsheetApp.getActiveSpreadsheet(); /*active spreadsheet id*/ var SSTID=SpreadsheetApp.getActiveSpreadsheet().getId(); /*OR if you are writing a standalone script*/ /*var SSTID=1FhDxI7j0PFtQYF0gCsiAQauQ1QZ-nDTWNPydpQPD3GE*/ /* web request listeners */ /* pass request to handleResponse */ function doGet(e) {return handleResponse(e);} function doPost(e) {return handleResponse(e);} /* handle action request */ function handleResponse(e) {  var lock = LockService.getPublicLock();  lock.waitLock(30000); // wait 30 seconds before conceding defeat.   try {     var cmd = e.parameter.cmd;     var output="test";                 //return ContentService.createTextOutput(JSON.stringify({"result": "success","data": output})).setMimeType(ContentService.MimeType.JSON);     return output   }  catch (e) {/*if error return this*/return ContentService.createTextOutput(JSON.stringify({"result": "error","error": e})).setMimeType(ContentService.MimeType.JSON);}  finally { /*release lock*/ lock.releaseLock();} } /*test function*/ function testFunction(){   var e={parameter:{cmd:"test"}};   Logger.log(handleResponse(e)); }

4. Test

Save.

Run testFunction().

Check Log

5. View execution transcript

It shows the series of code execution including system commands eg Lock and Log.

6. View Log.

It shows the Log output.

You can put the log anywhere in the code to get the app returns a value to the system.

This is what we should get when we run the script.

7. Publish As Web App

Before you publish, change the return statement so that the code returns the output in the form of Text Output instead of the regular javascript variable.

Refer

visit link download