Which Database is best for an school admission app

[luv.ak.tech (Aarush Kumar)]

@havish

make it in .aia in post

This is a learning platform. No one is going to give you a ready made aia , try yourself if you get stuck there is community and author of the guide to help you.

[havish (Havish coder)]

@luv.ak.tech

learning

yes if you make it will help to learn blocks and techniques used

[luv.ak.tech (Aarush Kumar)]

@havish

it will help to learn blocks

if you just wanna learn it is already given in the guides given above ?

[Still-learning (1-2-3-4...)]

@havish

techniques used

If you follow the way given in the above thread(also aia) you can design… sample url given to you

Go to th above url mentioned, copy all the script codes, paste into your script editor, deploy into web app, this will act as your script url…

Copy the sheet id from the google sheet

tick the show list as json from the project setting (your app)

thats all

Final web url be like this,

---

https://script.google.com/macros/s/AKfycby-APpgS-oqmLrOb1se5e_s8cVgV4-4xzv15j0naTmlOHBIHgs/exec?ID=1sL2YIpHexSHSP0aCNKgHwbfdELP7fPIJsuXpj-TG6Dw&SH=Sheet1&FN=addRow&DATA=["GSR", "GSR", "Male", "6", "Address", "3/2/2022", "Mother Name", "12345", "Tamil", "Hindu", "Caste", ""]

[Still-learning (1-2-3-4...)]

[havish (Havish coder)]

@Still-learning

copy all the script codes

Please correct errors in that i cannot find it

[Still-learning (1-2-3-4...)]

share the complete script url

[dora_paz (Dora)]

This is the response from

https://script.google.com/macros/s/AKfycby-APpgS-oqmLrOb1se5e_s8cVgV4-4xzv15j0naTmlOHBIHgs/exec?ID=1sL2YIpHexSHSP0aCNKgHwbfdELP7fPIJsuXpj-TG6Dw&SH=Sheet1&FN=addRow&DATA=["GSR", "GSR", "Male", "6", "Address", "3/2/2022", "Mother Name", "12345", "Tamil", "Hindu", "Caste", ""]

[havish (Havish coder)]

can you say what to do once more step by step it will be easier for learning

[Still-learning (1-2-3-4...)]

1. Go to script editor of your desired gsheet
   

2. Paste all the code given in the tim ai2 web page and click deploy web app
   

   

3. Give permission to access anyone
   

also change the sheet to view by anyone

Also you can use this guide to how to do deploy the google sheet

Google Sheets and Apps Script

Disclaimer. My english sucks. Because I WANT to use Google Sheets !!! When I think about using Google sheets along with my application, I want a few basic things. They are adding (and possibly removing) rows and columns, reading (and possibly replacing) values ​​in the required cells, and doing these things from my app. Yes, I want custom API for my app, with blackjack and hookers! Is it really that hard? It took me a week to find answers and compile all information, i want to share with you n…

[havish (Havish coder)]

i have tried but IDK what happened spreadsheet did not get what i submitted while testing

if you know please edit :
aia (i tired using web1 but IDK if it is wrong) -
addreg (1).aia (35.1 KB)
My script url - Sign in – Google accounts

please find wrong and say to me

[Still-learning (1-2-3-4...)]

it seems you have not did well the deploy process. please read the above guide in which you can find the full details and compare with my screenshots…

[havish (Havish coder)]

i have did it -

[TimAi2 (metricrat)]

@Still-learning

also change the sheet to view by anyone

This is not necessary. The script should have read/write access to the spreadsheet, even if it is private

[havish (Havish coder)]

@TimAi2

script should have read/write access

do it require additional things to do or as a default permissions are allowed?

[TimAi2 (metricrat)]

@havish

do it require additional things to do or as a default permissions are allowed

I am sorry, I do not understand what you mean ? All I was saying is that if the script is owned by your google account, and the spreadsheet is also owned by the same google account, then the script can access the data, therefore the app can access and edit the data.

[havish (Havish coder)]

okay sorry i was thinking a long

[havish (Havish coder)]

what to do please help me

[Still-learning (1-2-3-4...)]

See , instantaneously i have created a script url to send data from app to gsheet with Timai2 guide…

[havish (Havish coder)]

wonderful! but my is not working