TIMAI2
Dear, I already Downloaded aia file From https://ai2.metricrat.co.uk/guides/google-sheet-crudq-ii#h.4tsz5wpr71pl
Then I change only Script URL & ID ( I use Deployment ID from above the Script URL), I Crate Google Sheet Same to yore Sheet. This Is my google Sheet URL
https://docs.google.com/spreadsheets/d/1K7ZWNFfmxNnSWoF1ia1u8n4EmLKLG0p8-EjSSsF6MLM/edit#gid=0
Dear
How I Solve This Problem?
In your blocks is where there is a problem.
For your variable id you need to use your spreadsheet ID, in your case this:
[s]https://docs.google.com/spreadsheets/d/[/s]
1K7ZWNFfmxNnSWoF1ia1u8n4EmLKLG0p8-EjSSsF6MLM
/edit#gid=0
then it should work for you
In the aia project you had not changed the variable id. However, having changed it the error still arises.
The problem is somewhere wioth your script / url ???
Your script url in the aia project does not match the one you show in your post.
Check that the one listed in your last deployment matches with the one in your blocks
Sorry My Dear,
I change ID And Script Url. But No Good result. Show the Same Massage.
This Is my Sheet Script Url
Deployment successfully updated.
Deployment ID
AKfycbyWsZip5F1MqGBASyXpFYGQYX7StxICzmTnUebe1AN4Q0bavD1wRF49yve3Vr3kIGSEdA
And This is my Sheet Url
https://docs.google.com/spreadsheets/d/1K7ZWNFfmxNnSWoF1ia1u8n4EmLKLG0p8-EjSSsF6MLM/edit#gid=0
How can I be free from this problem?
I see that your spreadsheet is called CRUDII, but that your first sheet is called SH. Try changing the name of your first sheet to CRUDII so that it matches what you are sending in the blocks.
Thank you. I Am So Happy For Your Response.
Hi dear, 1st again thanks for yor response. Its possible to add photo in this list.
Of course
read everything here:
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
