Google Sheet and Google Drive

[STEFANO_CHERUBINI]

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

[TIMAI2]

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

[STEFANO_CHERUBINI]

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

[TIMAI2]

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

[STEFANO_CHERUBINI]

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

[Juan_Antonio]

I think this tutorial of @TIMAI2 is easier:

[FREE] Google Sheets for AppInventor (replicant) using Google Apps Script

With reference to this previous guide: I have now written an extension to compliment the google apps script, therefore no need to write any complicated block structures. The extension follows the original blocks provided by Tommy Heng, but updates and improves on them. It has not yet been aligned with the latest version of the Google Sheets component currently available for testing (as of writing this), although it appears to be much the same. Google Sheets for AppInventor Latest Version: …

[STEFANO_CHERUBINI]

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.

[Juan_Antonio]

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.

Sync Google Sheets to a Firebase Realtime Database

We have a Google Sheets: [firebase_googlesheet1] We want that when a data is changed in Google sheets, it is modified in real time in a Firebase Realtime Database. [firebase_googlesheet2] And also in an app with the Firebase component. We will follow this tutorial: https://medium.com/firebase-developers/sheets-to-firebase-33132e31935b

[STEFANO_CHERUBINI]

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

}

[Juan_Antonio]

[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

[TIMAI2]

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

[STEFANO_CHERUBINI]

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

[TIMAI2]

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

[STEFANO_CHERUBINI]

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

[TIMAI2]

@STEFANO_CHERUBINI

everything is correct

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

[STEFANO_CHERUBINI]

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

[TIMAI2]

@TIMAI2

show your:

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

please

[Juan_Antonio]

[STEFANO_CHERUBINI]

you are the best