Тёмный

Web App - Google Sheets CRUD - Part 1 - Load Views 

Learn Google Sheets & Excel Spreadsheets
Подписаться 274 тыс.
Просмотров 201 тыс.
50% 1

Learn how to make a Web App to Create, Read, Update & Delete data in Google Sheets. We'll be using Bootstrap (getbootstrap.com/) & JavaScript Apps Script.
In this part we'll be creating a view engine to load views.
This is Part 1 from Userform Level 3 Series - Google Sheets CRUD
• Userform Level 3 Serie...
HTML/CSS/JavaScript Fundamentals
• HTML & CSS Crash Cours...
JavaScript Array Methods
• Google Apps Script Int...
Userform Level 1 Series
• Google Sheets - Userform
Userform Level 2 Series
• Google Sheets Userform...
#webapp #googlesheets #crud

Опубликовано:

 

3 авг 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 303   
@lossless4129
@lossless4129 4 года назад
You are most likely one of, if not the greatest RU-vid teachers in this area. Unbelievable content, thank you!
@madBambula
@madBambula 3 года назад
I'm not English speaking, but it is amazing. Best lessons ever
@OneDeed90
@OneDeed90 3 года назад
Yeah. He makes RU-vid ads worth it.
@wimino367
@wimino367 2 года назад
@@OneDeed90 He makes RU-vid Premium worth it
@jonahdavepedrajas4716
@jonahdavepedrajas4716 4 года назад
This is what I'm waiting for! I'm very excited for the succeeding part :) great tutorial 👍
@reposit5713
@reposit5713 3 года назад
I know one, it would take ages for person like me who is all hands solely in Front-end to config such environment for further do. Thanks a lot. I am literally kowtowing for hours wasted of yours, and yours saved for us, sharing such cool stuff. I am learning everyday, but this Chicago guy literally knows what he is doing. What ideas of reusability! Wow! Keep it up!
@pabami34
@pabami34 4 года назад
This is what I have been looking for! Thank you! I can't wait for the following series!
@getdavemoore
@getdavemoore 4 года назад
0.53 secs in and I'm sold! Top job 👍
@fabriciosouza408
@fabriciosouza408 4 года назад
This is just outstanding man! I can't say how gratful I am for your videos, they're really help me! Thanks again!
@packland
@packland 4 года назад
I loved your videos about google apps script. Im building exactly one contacts data system and this videos will save me. Thank so much from Brazil.
@josedejesusfragozolopez6396
@josedejesusfragozolopez6396 4 года назад
Presente en esta nueva e interesante serie. Muy útil, adaptable y educativa.... Gracias !!!
@maleliang3769
@maleliang3769 4 года назад
As always, great content this series sounds promising, well done, you are an amazing man, thanks!!!!
@lionelfabre8320
@lionelfabre8320 4 года назад
Excellent. Just what I need to implement after your level 2 playlist. Thanks for your great job !
@cookjeremiah
@cookjeremiah 4 года назад
Also what I was waiting for . You are the boss sir !!!! Kudos
@ahmadabdullahjim1760
@ahmadabdullahjim1760 4 года назад
you are doing great sir. hope you will help us like this in the future. all of your tutorials are really helpful.
@acolbeck6615
@acolbeck6615 3 года назад
These are an amazing set of videos. I am so impressed by the things you have taught me to do in Google Sheets
@wampphp
@wampphp 4 года назад
You are doing a really great job!!!
@kafkareader3212
@kafkareader3212 4 года назад
I want to say a big Thank You. Your videos helps me a lot. Big part of mine work i base at information that you give me through RU-vid. So, I want to be a sponsor of your channel. Pls, add button for that. I think that action from my side will be a little part of mine gratefulness for your amazing work here.
@franco4538
@franco4538 4 года назад
Wow This is Great!!! I'm excited with next part
@nicksonbonke2608
@nicksonbonke2608 4 года назад
Woow I have been waiting for this one bruh. U just the best
@yannick-rogerblanc6313
@yannick-rogerblanc6313 3 года назад
Great, just Cool ! Let's go for the next !
@jhicinternational
@jhicinternational 3 года назад
thanks, man, you are a gift from God!👏👏👏👏
@findthetruth3021
@findthetruth3021 4 года назад
I live your videos man because you are always making amazing videos. Wow
@sebiporini
@sebiporini Год назад
I love u beibiiiiii. I am learning a looooot! Thank you so much for this tutorial! God bless youuuu. 😊
@vongvilaiinthasanh741
@vongvilaiinthasanh741 2 года назад
Best lesson for learning Thanks.
@sheyanran508
@sheyanran508 4 года назад
I’ve been waiting for this. :-)
@neogamma2128
@neogamma2128 2 года назад
sir, you have helped my life a lot. thank you
@rightchanger3012
@rightchanger3012 4 года назад
bro waiting for your next video. really you are awesome ..
@khmerkeyinfo3518
@khmerkeyinfo3518 4 года назад
Awesome can't wait to see next video
@siddharthjain6629
@siddharthjain6629 4 года назад
😵😵😵@what a video@loved the end result@I appreciate your work!!@difficult programming but the end result is so good that it is worth put all the effort in understand ing that programming..(as i am not from programer background) @keep working like this sir..
@apolovzla_ccs
@apolovzla_ccs 4 года назад
Excellent buddy, as always... 👍
@AbdulmalickSalum
@AbdulmalickSalum Год назад
am proud for you man, a'm victim of learning this designed but i have fail in one thing of capturing the one who will edit the sheet and his or her sign should be seen in a column that i will suggest
@virterra
@virterra 4 года назад
I agree with Lossless. This is awesome stuff.
@jordancote7972
@jordancote7972 3 года назад
such great videos! Thank you for the great content!
@wakt
@wakt 3 года назад
This is so good. Pretty powerful stuff. You should add a button for donations. If you do that, allow yourself to take cryptos as well
@androidbox6876
@androidbox6876 7 месяцев назад
I repeatedly watched this video for over 10 times. 🤓
@luuminhvuong
@luuminhvuong 4 года назад
If only you can include the example app script. Love what you do ,
@DaveThrash
@DaveThrash 4 года назад
I'm very grateful to you.
@lauraa.3593
@lauraa.3593 4 года назад
Excellent! Thank you!
@aleksey3750
@aleksey3750 4 года назад
You are super. Please make more videos.
@juansebastianpolaniaramire4530
@juansebastianpolaniaramire4530 3 года назад
Dude, great content!
@vivekneymar2283
@vivekneymar2283 2 года назад
Heyyy friend. Thanks for all the knowledge you’ve taught me. Okay now I have constructive feedback : when creating a search engine that searches and retrieved rows in the data table, you taught me to search in columns 2,3,4 etc or whatever. A suggestion to speed up the search engine : concatenation of the columns you’re going to search in in a single column. Search for keywords in this index column. 🚀🚀🚀🚀
@juliol.7081
@juliol.7081 2 года назад
Thank you, great video. You are expert!! 👏👍
@ExcelGoogleSheets
@ExcelGoogleSheets 2 года назад
Thank you!
@azlanmn5502
@azlanmn5502 2 года назад
tqvm for sharing this! really appreciate it!
@meetadii
@meetadii 4 года назад
Thanks for sharing.. great tutorial .. I m a fan of yours... looking for subsequent videos.. when would next video be released.
@mask75260
@mask75260 4 года назад
Same here webapp series are best.
@pichit.raetai
@pichit.raetai 4 года назад
Thank you very very very much
@visiontv1175
@visiontv1175 3 года назад
Hi, Great series !!!! really helpful in my project. I have gone through multiple times with this series but I do have just one question how can I just view the rows data without adding the search input box?? please help me with this it would be really great for my project. Thank you :)
@dancunchiriga
@dancunchiriga 4 года назад
super.. thank you
@ligoregiomechelen8118
@ligoregiomechelen8118 3 года назад
My favourite youtube channel without any doubt! Any plans to do a crud example like this published deployed as webapp instead of via custom menu in Spreadsheets?
@ExcelGoogleSheets
@ExcelGoogleSheets 3 года назад
It takes 5 minutes to convert this to a Web App. Check out my other channel for more info ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-bwy1TS6If38.html
@chocaletyboy88
@chocaletyboy88 4 года назад
Many many thanks
@emilianoreyes
@emilianoreyes 4 года назад
Thank you!!!
@stansuen8072
@stansuen8072 4 года назад
Awesome
@user-ji2pr9js4j
@user-ji2pr9js4j 4 года назад
Great!
@osama1989ali
@osama1989ali 4 года назад
you are very great man , I have a question : I want to know how many times word repeats in one cell?
@TheTramos00
@TheTramos00 4 года назад
Definitely the best Google Sheets RU-vid channel ! ALL steps are indicated in the 5 CRUD videos ? I'm going to start typing the code so please tell me.
@ExcelGoogleSheets
@ExcelGoogleSheets 4 года назад
Part 6 is coming up and that should be it.
@feadrijustyaulia2976
@feadrijustyaulia2976 Год назад
you're unbeliavable amazing. thanks for your tutorial that give so much help if you don't mind, may i ask you something ? can we create an auto new table data based on data we choose ?
@66Komodo
@66Komodo 4 года назад
thank You
@abdullahquhtani4247
@abdullahquhtani4247 4 года назад
Great. It’s one of the best tutorials ever BUT it is USELESS if you don’t add users (Authentication and Authorization ) functionality to this project. Thank you 🙏
4 года назад
User Management is way to big to put it in this series of tutorials. It deserves its own. But this alone is very helpful, thanks the author a lot!
@roquesyves6598
@roquesyves6598 4 года назад
Exellent - Very good ! - In an other video, can you explain us, how insert picture in html part ? - Thank you
@anthonysilvey3784
@anthonysilvey3784 4 года назад
I'm not on Patreon, but I really want to buy you a coffee...or send a few bucks your way. Your videos are amazing.
@ExcelGoogleSheets
@ExcelGoogleSheets 4 года назад
Thanks Anthony! You may do so on this page www.chicagocomputerclasses.com/youtube-learn-google-spreadsheets/
@anthonysilvey3784
@anthonysilvey3784 4 года назад
Your coffee this morning is on me! Thank you again for posting such awesome content.
@sierramendoza2835
@sierramendoza2835 4 года назад
Cool!
@DivitKalem
@DivitKalem 3 года назад
Hi, I learned a lot from you. I'm grateful to you. I designed a web app with what i learned from you, a roster preparation app. I'd like to use Google Analytics for it, but no data is coming. I think, the reason for this is that Google runs my codes as an . Is there a solution for this? Thank you.
@mindzen2107
@mindzen2107 4 года назад
great tutorial, can you please continue this on how to publish it as an web app and also load some images from the table url strings
@carloffbootyduty6560
@carloffbootyduty6560 4 года назад
I would like to know how to publish it as a web app as well, that would be brilliant
@ajgorman1
@ajgorman1 4 года назад
What awesome work! Is the code files available for this project?
@assiadellanotte3638
@assiadellanotte3638 4 года назад
Great! A question I would to load automatically the Web App in a sidebar in the sheet without use the menu. How could I proceed?
@fredyservada
@fredyservada Год назад
dude. u is a G o d
@ytdavide
@ytdavide Год назад
Beautiful 😍
@ExcelGoogleSheets
@ExcelGoogleSheets Год назад
Thank you! Cheers!
@lesptitsoiseaux
@lesptitsoiseaux 2 года назад
I wonder why I don't have the 'Project' option and only Script or HTML under the new button? Has this been dropped since? Oh, and thank you. Thank you, so very much. Your videos have helped me at work so much I'm building my next role thanks to you. If you are in Vancouver I'd buy you lunch once the plague abates!!!
@H-do8tr
@H-do8tr 3 года назад
GREAT WORK! BUT I can’t seem to get the Search tab to print the text in the search.html :( help me
@patrickserrano4966
@patrickserrano4966 3 года назад
me too.
@uelifluppi
@uelifluppi 2 года назад
Thanks!
@ExcelGoogleSheets
@ExcelGoogleSheets 2 года назад
I appreciate it!
@vnvlthm007
@vnvlthm007 4 года назад
Thank you for these videos. Once you switched to Bootstrap I can't seem to make it work any longer. I followed a lot of your older videos and it always worked so far. I also notice that each time I do evaluate(), GAS tells me that it is not a function. Maybe it plays a role in that problem.
@ExcelGoogleSheets
@ExcelGoogleSheets 4 года назад
Bootstrap has nothing to do with it. It seems like you've already narrowed down your problem. If evaluate is not a function then something went wrong in your HtmlService.createTemplateFromFile part. So check those lines carefully.
@vnvlthm007
@vnvlthm007 4 года назад
@@ExcelGoogleSheets I will, thank you for your hard work !
@bobykumar3960
@bobykumar3960 3 года назад
god of google sheets
@anishpillai
@anishpillai 4 года назад
is it possible to create separate views for user....like in your tutorial, I would like to have edit and delete customer button for managers only and executives should only be able to search customers?
@ccjdrive3946
@ccjdrive3946 3 года назад
Hi great tutorial, have you made the source code available? Thanks in advance.
@walterelemino
@walterelemino 2 года назад
You are a great teacher. I would like to ask a question why my code have error it says html.evaluate is not a function? Hope I can answers from you and anybody thank you! :)
@2010Sheb
@2010Sheb 2 года назад
thanks for the video, please tell me how can I somehow load the last 5 records before searching so that the table is not empty?
@palaiscorporativo5084
@palaiscorporativo5084 4 года назад
Love your videos...I'm making a new app based on them. One question...how to make input data persist when changing the views if they constantly reload? For instance a selected checkbox.
@ExcelGoogleSheets
@ExcelGoogleSheets 4 года назад
Save it some place. You could use PropertiesService.getUserProperties() service. It's not simple if you're not already comfortable with web development.
@exyoris
@exyoris 4 года назад
This might be a very dumb question, but I'm just starting out. I'd like to have my web app outside of Google Sheets and to access it through an url, not as another menu. How would I go about this? Very much appreciated!
@user-mm4qo3bk2p
@user-mm4qo3bk2p 11 месяцев назад
I am enjoying your CRUD course, but have run into an issue when adding in the logic for the callback (25:14). I have reviewed my code character by character and it matches your example, but I cannot get the new title to appear, in fact, nothing appears when the tab is clicked. I would appreciate any thoughts on where I might be missing something.
@dcscla
@dcscla 3 года назад
Amazing video!! Thank you so much!! I'm just wondering how to deal with an error that says: "cb() is not a function". My form just loads one view at a time. Or it loads search view and then don't load anything else, or it loads Add Customer View and then don't load anything else. What I'm doing wrong? I double checked my code, but I'm benginner. Thank you a lot once more for your amazing videos!!
@jimmyantoniocorzon172
@jimmyantoniocorzon172 3 года назад
I have problems when clicking on the it sends me to different HTML templates when clicking I can't find the problem in the console
@jimmyantoniocorzon172
@jimmyantoniocorzon172 3 года назад
I have the same problem
@jimmyantoniocorzon172
@jimmyantoniocorzon172 3 года назад
document.getElementById("link").addEventListener("click",view); check your points in the so-called
@jimmyantoniocorzon172
@jimmyantoniocorzon172 3 года назад
it worked for me
@miskairali2762
@miskairali2762 2 года назад
you teach awesome can you provide me online class for it
@emmanuelgomezalvarez5953
@emmanuelgomezalvarez5953 Год назад
MVP
@kal_the_pal
@kal_the_pal 2 года назад
I really wish you would make the code available! Would make life so much easier!
@AnandRaoMoram
@AnandRaoMoram 4 года назад
Great help if possible please share the code also
@catnop1912
@catnop1912 4 года назад
Sir ! How can I use that form on a separate .html web page on another server and then read,write,delete data from spreadsheet?
@jankleber6130
@jankleber6130 Год назад
thank you very much. when i open the form and switch the tab, it have much longer time (5 sec+) for the first load the html in the tab. At the next switch its load much faster. What can i do to fix this?
@renetoong3625
@renetoong3625 4 года назад
this is great.i do have a question, this program will this allow multiple users. example 30 - 50 users at the same time?
@mask75260
@mask75260 4 года назад
More than 100
@mask75260
@mask75260 4 года назад
But simultaneous executions only 30.
@renetoong3625
@renetoong3625 4 года назад
appreciate the responses as i am developing something like this in my workplace
@wctins
@wctins 3 года назад
Hi. First of all, thanks for the excelent videos!! How can I set a CRUD as a webapp? Actually I need a way to search in a sheet as a webapp because we are afraid someone mess up our google sheet. Thanks in advanced
@ExcelGoogleSheets
@ExcelGoogleSheets 3 года назад
ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-bwy1TS6If38.html
@yosoydineroenabundancia5088
@yosoydineroenabundancia5088 3 года назад
Spanish.........?; muy buen contenido; apenas entiendo el ingles como quisiera ver el contenido de este canal en español.
@reviewguy1766
@reviewguy1766 3 года назад
19:10 This didn’t work for me. The loadSearchView doesn’t show when I click on the Search tab. I couldn’t find any errors in my code and followed you exactly. Can you please help me?
@grantdotulong2327
@grantdotulong2327 3 года назад
same problem here, we have a newer version of bootstrap's template. not sure if that has anything to do with it. Please help!
@maisterPernat
@maisterPernat 3 года назад
you need to add "return" into your loadPartialHTML_ function. Whole final line of this function should be "return htmlServ.evaluate().getContent();"
@michaelporton845
@michaelporton845 3 года назад
@@maisterPernat I have the same problem. loadSearchView was not showing anything. Please help. Thank you:D
@grantdotulong2327
@grantdotulong2327 3 года назад
@@maisterPernat Already have that coded in my loadPartials.gs. I'm 100% sure I have followed the tutorial thoroughly.
@maisterPernat
@maisterPernat 3 года назад
@@grantdotulong2327 try checking for typing errors then. I was following this tutorial a week ago with latest version of bootstrap and it works for me. The only thing I changed is added this return statement
@vorichie2146
@vorichie2146 3 года назад
Thank you so much for the video.. however I cant seem to get the Search tab to print the text in the search.html.. please help!
@H-do8tr
@H-do8tr 3 года назад
Me too!
@manivelarung
@manivelarung 3 года назад
Need advise from anyone, please. Appsheet vs Web App? Is it OK to go with google sheet as DB or shud I choose anything else like MySQL (am little good at T-SQL)? Recently I upgraded many junk of MS EXCELS to Google sheets. Am using this for my Textile factory operation tracking purpose (we do fabric printing as job orders for our customers). I track different departments in my factory. I tried to make an intranet website for this using HTML, Angular, Mongo. But I cudnt get time for learning as I moved from IT to textile industry. Now looking for options to make work easier and make my staff (some are blue collared staffs) to touch the data safely and easily. I saw Appsheets and this Web App. Dont know which one I shud go with. I was in prod support in my IT life, so not good at core coding. My goal is to make - Any Layman to update the tracking data - Need to generate dashboard, reports that shud be visible for management (including me ) - Database and any tech that am gonna use shud be free (my partners are not gonna interest and invest in IT. I need to make use of anything comes for free) - need to show fabric design images in every job card across every department wise tracking we dnt have any server running 24 hrs in our factory. Thats why I moved to google sheet for now to have the data access outside the factory too. I have design images in our Google drive, from where I access the thumbnail and display in google sheet for now
@amheritagevdo3932
@amheritagevdo3932 2 года назад
I am relatively new to programming and I just want something simple. I want a code in add, update, delete and search responses in my google form. In the google form there is only the submit button, I want all those buttons. Is there an add-on or something similar. Tried to use appsheet and it was even too hard for me. Hope there is something easier.
@nunomarques6106
@nunomarques6106 Год назад
I've seem some videos from you and they are great. Congratulations and keep the good work. It's possible to have a example with a bootstrap table with data and when we click on add emove or edit button, the form used apears to perform the tasks we need? Thank you
@nunomarques6106
@nunomarques6106 8 месяцев назад
Can you answer to my question? Can i make a donation and get access to code? Thank you
@nunomarques6106
@nunomarques6106 6 месяцев назад
Do you are atending to update CRUD videos?
@nunomarques6106
@nunomarques6106 3 месяца назад
No answer.... awsome :P
@luqmansecond6375
@luqmansecond6375 3 года назад
Hi, thank you for the great video! I tried sharing my Google sheets with the custom menu to another user and the other user is unavailable to see/use the custom menu. Is there anyway to do this? I'm trying to set a user interface for the data stored in my Google sheets to facilitate looking up of data via search bars for the end users.
@ExcelGoogleSheets
@ExcelGoogleSheets 3 года назад
Menu should work for other users just fine. Not sure why you're having issues.
@riteshpandey5082
@riteshpandey5082 4 года назад
Sir, in this whole series you also didn't talk about upload item, Please make it in coming video
@ConsulthinkProgrammer
@ConsulthinkProgrammer 3 года назад
use webApp
@peraruor
@peraruor 10 месяцев назад
Hi, was trying to look for the Starter Template. Turns out, is not the same template anymore. It also has, what it appears to be arabic letters on some of the sample data. Any advice? Are you planning to update this video. I think is one of the most valuvole ones. Thank you so much for your time.
@ahmadabdullahjim1760
@ahmadabdullahjim1760 3 года назад
It shows problem with form responses sheets. working perfectly with other sheets that are non-form responses. How can i solve this sir?
@mohamed.montaser
@mohamed.montaser 4 года назад
some videos in Userform Level 3 Series playlist are private, are they upcoming videos?
@MateusMoreira-di9wh
@MateusMoreira-di9wh Год назад
is it possible to create a button that automatically loads the form instead of loading it from the menu bar?
@selyprimagustian_5p6_38
@selyprimagustian_5p6_38 Год назад
Hi sir, I wrote the code according to your video and I have evaluated the duration of the video for 3 days only to find out how to move the page to another page but all stuck, can you help me with the matter of switching pages with the code you show in the video series, thx
Далее
Как похудеть на 10 кг ?!
07:06
Просмотров 554 тыс.
Convert Google Sheets into a REST API
14:10
Просмотров 4,9 тыс.
WebApp to search and display a Sheets table
31:53
Просмотров 2,6 тыс.
Как похудеть на 10 кг ?!
07:06
Просмотров 554 тыс.