pls replace the script code with this scripts from the link below and deploy once again with option Anyone
As said by tim, it is working fine, if i use above scripts and run.
see
help the script is the same, please help me, mine doesn't work.
I do not understand
New_Crs_Group.aia (1.3 MB)
Your blocks/app appears to be working OK. That is not the problem.
Show how you have deployed the script....
no I understand
I open the sheet from google extensions app script
please help me where I'm wrong at screen app, screen file, app.aia
New_Crs_Group.aia (1.3 MB)
The script url shown on the deployment page is different to the one you show in your app.
I have to enter
and delete in GSAI21 SCRIPTURL
https://script.google.com/macros/s/AKfycbzI6IEISTsrAo2BVdh8Fkt3fo6nfoaTVWBiZvxzZKx8XIf2dvU/exec
CORRECT?
if you run the latest Script url in browser, it should return
Exception: Invalid argument: id (line 5, file "Code") but yours both of the above url returns page not found error. It means you have not deployed correctly it seems. You are missing something. Always run the script url in this format
<Use_Your_script_url>?ID=<use_your_sheet_ID>&SH=<use_your_sheet_name>&FN=readRow&ROW=2
if the above code returns value of 2nd row then your deploy is good else, you are dpoing mistake at anywhere.. (Note; please remove < and > symbol. it is used to denote the places where you want to addthe reqiurd things)
Yes, always replace the latest script url with the previous one
Seems you have not been doing this (in order to keep the script url the same)
I don't understand, everything is ok for me.
you have everything about my app but if you try it and it works
can you tell me what to change please
I'm going crazy
i have opened your gsheet and deployed from my side, see and test the url HERE
It reutns sheet datas which means i have did it correctly..
No problem with code/app/blocks/
Problem with script url. Dot.
you are not alone 
Read through all the links I have provided with regard to creating a google apps script web app, and how to deploy it, and update the script with a new version. Understand all this and it may then become clear where you problem is.
Two of us have tested your app with our own versions of the script (on our own servers) and your app works with both of them. This points us to a problem with your google apps script
Ensure your last deployed web script url on google apps script, is the same one that you are using in your app.
yes it seems correct to me
Have you given the script permissions? It should ask you if you try to run the doGet(e) from the Script Editor (it won't ask if you have already done so).
I'm sorry, I'm giving up
You could try using the native spreadsheet component, this would require the setting up of a service account on Google Cloud Services.
Or you could try storing your data in a different "cloud", e.g. cloudDB / Firebase.
Hi, I attached the aia file, have you tried it? Maybe the problem is the way the app is made or the block code.
I solved i have change script uri in gsai21
1 Like
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.