Google Sheet and Google Drive

To update the google sheet from the app, you will need to create a google apps script web app, in order to be able to modify data. This is why i provided a link to my guide.

Ho, do I have to change everything then? sorry but I'm not very good I tried but I don't understand you can change it for me?
Thank you

You do not necessarily need to change what you have already done, but you need to add much more to do what you want.
What do you not understand? If you do it, you will understand :slight_smile:

hello, I beg your pardon you are definitely very good. I unfortunately no, I don't know how to do The script and edit so the app is Google Sheet. could you kindly give me a Aia file to download so I can modify that or you make a modification to my app please help would be important to me. thanks

If you want an aia project, an example is provided in the link above

HELLO, SORRY THAT MEANS
Will You Need: A Google Apps Script Web App?
WHAT SHOULD I DOWNLOAD?
THANKS AS ALWAYSI want my app to remain as it is, only clicking on the names on the screen allows you to change the wording and save.
so when I reopen the app the changes are saved
please help me i'm new i managed to do only this
help you are great

I think this tutorial of @TIMAI2 is easier:

hi guys it is possible that from my project I can make the fields editable and save them either on the Google sheet or in the app. thanks you are great.

Using TextBox you can send data to Google Sheets. You can also insert a Form-Sheet in Google Sheets.
Here's an example with Firebase, but you can do it more easily.

hi antonio you are very good i'm going crazy i made this code. please know how I can make the cells editable from my app so that they are not editable and the content can be saved to google sheet in Drive.
in the forum there is the file and the link to the sheet
you can change me I don't understand how to do it
help Thank you

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);
}

//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);
}
//UPDATE SINGLE RECORD
else if (e.parameter.func == "Update") {
var ss = SpreadsheetApp.getActive();
var sh = ss.getSheets()[0];
var data = [ [ e.parameter.name, e.parameter.phone ] ];
sh.getRange("B"+(parseInt(e.parameter.id)+1)+":C"+(parseInt(e.parameter.id)+1)).setValues(data);
return ContentService.createTextOutput("Success");
}

}

[quote="STEFANO_CHERUBINI, post:15, topic:64495"]
how I can make the cells editable from my app so that they are not editable
[/quote] ?

Copy /Paste script in Extensions / App Script

Well done, you have found youtuber HeyKal's imprecise script (poorly copied from me somewhere), which requires you to have a bound apps script project with your spreadsheet, and to ensure that your data is only in the first sheet of the spreadsheet

Juan_Antonio
I help you with everything done
can you help me and make the changes active?

You need three elements setup correctly and interacting with each other:

  1. Google Sheet
  2. Google Apps Script Web App
  3. Appinventor app

Have you correctly set up your google apps script web app? Linked to your spreadsheet, selecting the correct sheet on the spreadsheet? Published(Deployed) and authenticated your web app?

Do you have the web app script url in your Appinventor blocks?

Is the url you are sending to the web app formatted correctly, and contains all the correct parameters for the web app to function?

For further assistance you need to answer/confirm the above, then show your:

  • relevant blocks, particularly your web component calls
  • entire web app (as text, not an image)
  • screenshot of your spreadsheet

TIMAI2 everything is correct then I posted file Aia and link is all public you can check it too if you want. thanks I would be grateful if you help me

Then your app should be able to update the google sheet using the web app, yes ?

yes by clicking on the example username
cherubs turn 12-21
I want from the app if I write cherubs 13-21 he saves it in the app and in the google sheet, I can't
help please

please


blockrr

you are the best