How do you grab a photo from your device's storage?

[Randomly_Mythic]

You know the code in Apps Scripting how do I send the code to app inventor

[TIMAI2]

You get the script url when you deploy the web app in Google Apps Script.

[Randomly_Mythic]

I got this error message

[TIMAI2]

Looks like google is returning an html file error message.

Check you have deployed your web app correctly, and that your files and folders have the correct permissions.

[Randomly_Mythic]

Can you please explain what type of permissions I was suppose to deploy. I just put permissions that sounds good to me

[TIMAI2]

Again you need to read all of this:

Everything you wanted to know about Google Apps Script, but were afraid to ask

Well, not quite "everything", but enough to help create a script, deploy it, update it and approve permissions for it, to begin with. Of course, there is the official documentation: Google Apps Script First two guides to deploy a google apps script, standalone and one that is bound to a spreadsheet: Second a guide to update your google apps script to a new version after editing the script: Third a guide to correctly reviewing permissions for a script (this is also covered in the second …

and what I said here:

@TIMAI2

note: the image folder is set to anyone with the link (as are the files inside). The spreadsheet can either be restricted or anyone with the link.

[Randomly_Mythic]

Im so sorry but I got hit with this message right here

[TIMAI2]

As expected, you did not read or follow the links I provided:

[Randomly_Mythic]

I received an error message at my Execution log

Attempted to execute doGet, but could not save

function doGet(e) {
var ss = SpreadsheetApp.getActive(1YsG5LJb5mkFP3w1k0-WVv-kQ7rAvS9o-16zKuyUbBlLUX5D-foYn0lzl);
var sheet = ss.getActiveSheet();
sheet.clear();
sheet.appendRow( ['Filename', 'FileType', 'FileID', 'ViewUrl'] );

var folderId = '1EjhZxyuFy_edited_wkS--QdpauABaMpU';
var folder = DriveApp.getFolderById(folderId);
var contents = folder.getFiles();
var file, name, id, url, type;

while(contents.hasNext()) {
file = contents.next();
name = file.getName();
id = file.getId();
url = "https://lh3.googleusercontent.com/d/" +file.getId();
type = niceFileType(file.getMimeType());
sheet.appendRow( [name,type,id,url] );
}
SpreadsheetApp.flush();
rng = sheet.getDataRange().getValues();
return ContentService.createTextOutput(JSON.stringify(rng));
}

function niceFileType( mimeType ) {

if (typeof this.fileType === 'undefined') {
this.fileType = {};
this.fileType[MimeType.FOLDER] = "Folder";
this.fileType[MimeType.GOOGLE_APPS_SCRIPT] = "Google Apps Script";
this.fileType[MimeType.GOOGLE_DOCS] = "Google Doc";
this.fileType[MimeType.GOOGLE_DRAWINGS] = "Google Drawing";
this.fileType[MimeType.GOOGLE_FORMS] = "Google Form";
this.fileType[MimeType.GOOGLE_SHEETS] = "Google Sheet";
this.fileType[MimeType.GOOGLE_SLIDES] = "Google Slides";
this.fileType[MimeType.JPEG] = "JPG";
this.fileType[MimeType.PNG] = "PNG";
this.fileType[MimeType.BMP] = "BMP";
this.fileType[MimeType.GIF] = "GIF";
this.fileType[MimeType.SVG] = "SVG";
this.fileType[MimeType.PDF] = "PDF";
this.fileType[MimeType.CSV] = "CSV";
}
return (this.fileType.hasOwnProperty(mimeType)) ? this.fileType[mimeType] : "UNKNOWN";
}

[TIMAI2]

Try, as shown in my example, running the script from your app, do you get a list back in your responseContent ?

[Randomly_Mythic]

My believe that the code is due to the spreadsheet save file from the AppsScript because I found a save file for this script and place it where I saw it on the source.

Your code did work but no spreadsheet connected to it and it said the same error message

[TIMAI2]

Sorry, do not understand what you are saying or doing.

@Randomly_Mythic

spreadsheet save file from the AppsScript

@Randomly_Mythic

because I found a save file for this script and place it

[Randomly_Mythic]

I have no idea what is wrong all I know is it has something to do with the spreadsheet code

[Taifun]

@Randomly_Mythic

it said the same error message

You get an error message back in html format

How to show raw responseContent from your app when debugging

Many developers often get stuck when trying to handle the response content from an online server after making a GET request using the web component. Those trying to help often ask to see the raw responseContent being returned. When using companion this can be copied and pasted to the community for those trying to help to use with debugging. This is how you might return that information / data to a label. BLOCKS [image] DATA Do It Result: ""Name","Date of Birth","Age" "Adah","06/04/1999","2…

Taifun

[Randomly_Mythic]

Below is how I got it so now I am wondering how can we fix this issue

[Taifun]

This thread is trapped in an endless loop
Start reading again from here

How do you grab a photo from your device's storage?

Looks like google is returning an html file error message. Check you have deployed your web app correctly, and that your files and folders have the correct permissions.

Taifun

[Randomly_Mythic]

Could you please tell me if I wrote the code correctly because I know that I copied the save file of the spreadsheet and pasted it where it went in the sources you provided me

Also I tried again again got the same results

[TIMAI2]

@Randomly_Mythic

var ss = SpreadsheetApp.getActive(1YsG5LJb5mkFP3w1k0-WVv-kQ7rAvS9o-16zKuyUbBlLUX5D-foYn0lzl);

You cannot do this you just want:

var ss = SpreadsheetApp.getActive();

@Randomly_Mythic

var folderId = '1EjhZxyuFy_edited_wkS--QdpauABaMpU';

You need to use your own folder id that contains your images, not the dummy id I provided in my example script

[Randomly_Mythic]

I'm just thinking out of curiosity instead of doing google sheet could we just do a folder for the companion like the app gives you the folder in Google drive to use and you put your own files into it

[TIMAI2]

Would that work for all app users?

How would users share their files with other users ?