Which Database is best for an school admission app

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:

image

1 Like

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


Do you see such option in dropdown

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

Change Execute to Me and then I believe you will be able to see Anyine, even anonymous

1 Like

I think i don’t know that

right @dora_paz i got it now it is set to anyone even anonymous

1 Like

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
1 Like

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.

1 Like

It will also help if you put some data (anything will do…) in your spreadsheet, so we can see it being returned…

1 Like

post50

too much of posts

:upside_down_face: :upside_down_face: :upside_down_face:

1 Like