Re: [Apps-Script] JSON to HTML -> Don't Show

[Andrew Roberts]

Use onSuccessHandler() to get result from script.google.run

On Sat, 12 Sep 2020 at 17:56, MinJu Jung <speed...@gmail.com> wrote:

JSON to HTML -> Don't Show

-------------------------------------------------------

Code.gs

-------------------------------------------------------

function doGet(e){

return HtmlService.createTemplateFromFile('MainPage').evaluate();

 // Change Spread Sheet url

 

 //return RunSS(); 

  

}

function RunSS(){

 var ss = SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheets/d/1tEhUsQkP3TTdHBXk7BzkEZiK20oGH1TVcug7BEb0NaE/edit#gid=0");

// Sheet Name, Chnage Sheet1 to Users in Spread Sheet. Or any other name as you wish

 var sheet = ss.getSheetByName("email");

  var jo = {};

  var dataArray = [];

// collecting data from 2nd Row , 1st column to last row and last column

  var rows = sheet.getRange(2,1,sheet.getLastRow()-1, sheet.getLastColumn()).getValues();

  

  for(var i = 0, l= rows.length; i<l ; i++){

    var dataRow = rows[i];

    var record = {};

    record['name'] = dataRow[0];

    record['email'] = dataRow[1];

    

    dataArray.push(record);

    

  }  

  

  jo.user = dataArray;

  

  var result = JSON.stringify(jo);

  

  return ContentService.createTextOutput(result).setMimeType(ContentService.MimeType.JSON);

  

}  

-------------------------------------------------------

MainPage.html

-------------------------------------------------------

function RunSeverScripts(){

var DataResultJSON = google.script.run.RunSS();

var x, i;

printf(DataResultJSON);

for (i = 0; i < DataResultJSON.id.length; i++) {

  x += DataResultJSON.id[i] + "<br>";

}

document.getElementById("demo").innerHTML = x;

}

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/29e2cf5e-c5c1-44a9-8054-377ad4919cfao%40googlegroups.com.