Reading data from two Sheets

MIT App Inventor Help
, ,
1

How Do I Use 2 Sheet in one spreadsheet file, Please help!!

image
image1392×652 65.4 KB

please find app script as below

function doGet(e) {

return ManageSheet(e);

}

function doPost(e) {

return ManageSheet(e);

}

function ManageSheet(e) {

//READ ALL RECORDS

if ( e.parameter.func == "ReadAll") {

var ss = SpreadsheetApp.getActive();

var sh = ss.getSheets()[0]; 

var rg = sh.getDataRange().getValues(); 

var outString = '';

  for(var row=0 ; row<rg.length ; ++row){

    outString += rg[row].join(',') + '\n';  

  } 

return ContentService.createTextOutput(outString).setMimeType(ContentService.MimeType.TEXT);

}

//DELETE SINGLE RECORD

else if (e.parameter.func == "Delete") {

var record = e.parameter.id;

var ss = SpreadsheetApp.getActive();

var sh = ss.getSheets()[0];

sh.deleteRow(parseInt(record) + 1);  

return ContentService.createTextOutput("Success");

}

//READ SINGLE RECORD

else if ( e.parameter.func == "ReadRecord") {

var ss = SpreadsheetApp.getActive();

var sh = ss.getSheets()[0];

var rg = sh.getDataRange().getValues();

var outString = '';

outString += rg[parseInt(e.parameter.id)].join(',');

return ContentService.createTextOutput(outString).setMimeType(ContentService.MimeType.TEXT);

}

}

2

Hello,
explain with more detail what do you want, what have you tried and what part are you having problems with.

3

I just want to set Individual Button for read sheet Individually. for example Button-1 for Sheet1, Button-2 for Sheet2

4

You can modify tour scripts to allow a new paramater "screenName" and adda a new parameter into your calls...for example, for the "ReadAll" function you can use an additional parameter in call:
?func=ReadAll&sheetName="Sheet1" for the button1 or
?func=ReadAll&sheetName="Sheet2" for the button2

and in your script you can do something like:

if ( e.parameter.func == "ReadAll") {

var ss = SpreadsheetApp.getActive();

if ( e.parameter.sheetName == "Sheet1") {
   var sh = ss.getSheets()[0]; 
} else
   var sh = ss.getSheets()[1];
...
...

and something similar for the other funtions...

5

Or simply:

var sh = ss.getSheetByName(e.parameter.sheetName);

and send the sheetName parameter from your app.