Transferred from Google Sheets Test Server to aia server. Save to PDF no longer works

MIT App Inventor Help
1

Ok sir. Thank you very much.
Downloading a google sheet as pdf is working well In that test server. But it didnot work in main server.

blocks
blocks696×732 45.5 KB

2

What does this have to do with the Google Sheets Component ?

What doesn't work on the aia server ?

3

Print as pdf is not working

4

Do you mean Save as PDF ?

Have you looked in your ASD ? (application specific directory)
/storage/emulated/0/Android/data/<packageName>/files/

5

Yes sir. I looked. but Google sheets did not save as PDF in any location.

6

Let me test....

7

Ok sir. I looked. but Google sheets did not save as PDF in any location. May i want to make changes in that code?

/for testing with PC browser

function doGet(e) { 

  var ss = SpreadsheetApp.getActive();

  var sheet = ss.getSheets()[2]; 

  var id = e.parameter.id; 

  sheet.clearContents();

  sheet.appendRow([id]);

  var output = sheet.getDataRange().getDisplayValues();

  return ContentService.createTextOutput(output[0][0]);

}

//for use with AI2

function doPost(e) { 

  var ss = SpreadsheetApp.getActive();

  var sheet = ss.getSheets()[2]; 

  var id = e.parameter.id ; 

  sheet.clearContents();

  sheet.appendRow([id]);

  var output = sheet.getDataRange().getDisplayValues();

  return ContentService.createTextOutput(output[0][0]);

}
8

This has nothing to do with your google apps script.

Tested with companion (spreadsheet monitoring my puppy's weight)

image
image797×393 49.6 KB

Checks out to be present when using the File component and ListDirectory

9

Wow! Yes sir. finall i found that location. Thank you very much. Is there any way to save another location? example download folder

10

Suggest you start here, and work your way down the rabbit hole

11

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.