Google Sheet Tutorial - How To Create A Simple Database in Google Sheet And Work Online

Google Sheet Tutorial - How To Create A Simple Database in Google Sheet And Work Online

Example file

Make a copy of example file and paste the code in script Editor

Click on below link to get code

copy the code
go to Tools - Script Editor
and paste the code
-------------

[frdata]

This tutorial is most helpful for those who already have basic knowledge. I can follow easily even without audio. It is so kind of you to share the app with everyone. Thank you so much

[naveenkumarsabbani]

Please change the link-sharing option of the docs from "Restricted" to "Anyone with the link" so that you don't have to make an effort to grant access to everyone.. Just a suggestion...

[franciscomoren]

Thank you very much. Your video is so educational. God bless you man.

[arturoli]

Awesome. I had no idea it could be done with Google Sheets.

[suresh]

Your scripting guide to create a form for a google sheet is excellent - search, add, Modify and delete ... thanks for the comprehensive brevity ... Thank you so much

[chengxinlam]

I am appreciated it in your sharing script code, it is very easy to apply to many kind of works. Thank you very much.

[adrigs]

Very good ! That is exactly what I was searching for, thank you bro, god bless you.

[Ilham]

Thank You guys, yuo're awesome :)

[alohaapp]

Excelente, llevaba mucho tiempo buscando algo así. Thank you so much.

[cmansuy]

Thank you Sir for sharing your script. It is very useful for people like me who dont know how to write a script.. I am adapting your database and the script itself but am finding

[mihaelarusu]

Hi, this is a great tutorial.
I have a big request from you if you can please tell me how can make this to work for multiple sheets?
Thank you a lot for your tutorials! I wish you all the best!

[MustafaMamdouh]

Thank you so much, You did a great help for us!

[baliongerewiong]

Hi, Sir is it possible to add a print button to the previous database you created the userforrm with images thanks looking forward for more videos from you

[christiantoledopaglumotan]

Already subscribed... Thank you Sir for tutoring us and for the downloadble files

[adrianwalton]

Hard to hear your voice but thank you very much, sir. Sample file and code will be very helpful as I learn to apply this knowledge for my own project..

[drsagasama]

a question....if 2 persons in different place....can their open it in the same time...any problem?

[a]

awesome but you did not show how to make "sheet2"

[DihyaRamadhan]

Sadly dropdown list in google sheet android version uses exact match where we have to write exact word from the beginning matching the words located in particular list.

The thing is different with web version of google sheet, we could write any word, not only from beginning

[adityaviswanathan]

SEARCH AND UPDATE IS NOT WORKING FOR ME, THERE IS NO ERROR IN THE CODE & ONE MORE PLEASE IMPROVE THE AUDIO QUALITY SIR

[vivekasharma]

Great simple words accomplishing high purpose.please suggest code for form to Google sheet and sheet to form in same form