avoid this error… just deploy with new number and go on… even if i do it will show, just skip and continue
You did not publish/deploy your web app.
You cannot just run doGet(e) in the script editor, it requires parameters (from your app or in a browser url)
But you need to give this access when using the legacy editor:
Once you have done that, you can test your web app in your browser:
<YOUR SCRIPT URL>?FN=readSheet&ID=<YOUR SPREADSHEETID>&SH=<YOUR SHEET NAME>
Looks like this:
https://script.google.com/macros/s/AKfycbyNECxxxCzY0HXXXa8W49LEJHGQ1MeuWeqRqhYmag6BMtINYkkI/exec?FN=readSheet&ID=1O1tRBxxxjs1MiFvVs0VCXXXJYTc4g_GB8wfVO3A9Es&SH=Sheet1
This should return all the data on your sheet
Ah, are you working inside a domain (what used to be called G-Suite) ?
If so, you will need an Admin for Google Workspace in your institution to give you permissions to set your script to Anyone,even anonymous
I think i don’t know that
but still it is not solved
What happens if you try your web app in the browser? what is returned ?
oh it redirected me to my spreadsheet do u have example url (working)
Would need your script url, spreadsheetID and sheetname for that.
sure
i will give it here
spreadsheet url : School addmission - Google Sheets
script url : Error
name : School addmission
You haven’t deployed script. Below you can see one from mine’s test
https://script.googleusercontent.com/macros/echo?user_content_key=ZlSBCbunp8t923iVvuY9-eKyw3QtEqghsaTiAqmQOtQ81PLBUAJ-OXNnEwEwylR2wBB9ZoCCBjnOSV_7tv4NJSc4fIE7gnxym5_BxDlH2jW0nuo2oDemN9CCS2h10ox_1xSncGQajx_ryfhECjZEnKiwvrVkIgqgNEvBaDy0VrmpoiiFi6uv0XareBAqkWHH58LX6JHv-08mxnQi5uIDsKOIp7sEUsJ2&lib=MOmVqdoIl6k9OlAHDlJCG4bLQuUZr8v_g
Thank you. This returns:
Script function not found: doGet
You need to publish your web app to a new number. Select New (2) and publish again.
It will also help if you put some
data (anything will do…) in your spreadsheet, so we can see it being returned…