Web App - Google Sheets CRUD - Part 1 - Load Views
ฝัง
- เผยแพร่เมื่อ 28 มิ.ย. 2024
- 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
You are most likely one of, if not the greatest TH-cam teachers in this area. Unbelievable content, thank you!
I'm not English speaking, but it is amazing. Best lessons ever
Yeah. He makes TH-cam ads worth it.
@@OneDeed90 He makes TH-cam Premium worth it
This is what I'm waiting for! I'm very excited for the succeeding part :) great tutorial 👍
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!
This is what I have been looking for! Thank you! I can't wait for the following series!
0.53 secs in and I'm sold! Top job 👍
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.
This is just outstanding man! I can't say how gratful I am for your videos, they're really help me! Thanks again!
Presente en esta nueva e interesante serie. Muy útil, adaptable y educativa.... Gracias !!!
I’ve been waiting for this. :-)
As always, great content this series sounds promising, well done, you are an amazing man, thanks!!!!
Excellent. Just what I need to implement after your level 2 playlist.
Thanks for your great job !
Also what I was waiting for . You are the boss sir !!!! Kudos
Great, just Cool ! Let's go for the next !
Wow This is Great!!! I'm excited with next part
Woow I have been waiting for this one bruh. U just the best
you are doing great sir. hope you will help us like this in the future. all of your tutorials are really helpful.
Awesome can't wait to see next video
These are an amazing set of videos. I am so impressed by the things you have taught me to do in Google Sheets
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 TH-cam.
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.
You are doing a really great job!!!
thanks, man, you are a gift from God!👏👏👏👏
If only you can include the example app script. Love what you do ,
I live your videos man because you are always making amazing videos. Wow
such great videos! Thank you for the great content!
Excellent buddy, as always... 👍
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
😵😵😵@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..
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. 🚀🚀🚀🚀
sir, you have helped my life a lot. thank you
Best lesson for learning Thanks.
Excellent! Thank you!
I love u beibiiiiii. I am learning a looooot! Thank you so much for this tutorial! God bless youuuu. 😊
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
I agree with Lossless. This is awesome stuff.
bro waiting for your next video. really you are awesome ..
I'm very grateful to you.
Dude, great content!
tqvm for sharing this! really appreciate it!
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 :)
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?
It takes 5 minutes to convert this to a Web App. Check out my other channel for more info th-cam.com/video/bwy1TS6If38/w-d-xo.html
Thank you very very very much
Thank you!!!
Same here webapp series are best.
Many many thanks
super.. thank you
Definitely the best Google Sheets TH-cam channel ! ALL steps are indicated in the 5 CRUD videos ? I'm going to start typing the code so please tell me.
Part 6 is coming up and that should be it.
Thank you, great video. You are expert!! 👏👍
Thank you!
You are super. Please make more videos.
you are very great man , I have a question : I want to know how many times word repeats in one cell?
I repeatedly watched this video for over 10 times. 🤓
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?
Thanks for sharing.. great tutorial .. I m a fan of yours... looking for subsequent videos.. when would next video be released.
Great!
What awesome work! Is the code files available for this project?
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 🙏
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!
Awesome
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 ?
thank You
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.
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.
@@ExcelGoogleSheets I will, thank you for your hard work !
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.
Cool!
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
I would like to know how to publish it as a web app as well, that would be brilliant
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?
Exellent - Very good ! - In an other video, can you explain us, how insert picture in html part ? - Thank you
Hi great tutorial, have you made the source code available? Thanks in advance.
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.
Thanks Anthony! You may do so on this page www.chicagocomputerclasses.com/youtube-learn-google-spreadsheets/
Your coffee this morning is on me! Thank you again for posting such awesome content.
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?
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!
Me too!
Thanks!
I appreciate it!
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.
Save it some place. You could use PropertiesService.getUserProperties() service.
It's not simple if you're not already comfortable with web development.
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.
Sir ! How can I use that form on a separate .html web page on another server and then read,write,delete data from spreadsheet?
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!
dude. u is a G o d
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?
god of google sheets
this is great.i do have a question, this program will this allow multiple users. example 30 - 50 users at the same time?
More than 100
But simultaneous executions only 30.
appreciate the responses as i am developing something like this in my workplace
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! :)
GREAT WORK! BUT
I can’t seem to get the Search tab to print the text in the search.html :( help me
me too.
some videos in Userform Level 3 Series playlist are private, are they upcoming videos?
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!!
Great help
if possible please share the code also
Beautiful 😍
Thank you! Cheers!
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
I really wish you would make the code available! Would make life so much easier!
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!!!
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.
Menu should work for other users just fine. Not sure why you're having issues.
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
th-cam.com/video/bwy1TS6If38/w-d-xo.html
How will this table with the form open if you use a phone?
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
I have the same problem
document.getElementById("link").addEventListener("click",view);
check your points
in the so-called
it worked for me
is it possible to create a button that automatically loads the form instead of loading it from the menu bar?
How can I add the sort option for table.
It shows problem with form responses sheets. working perfectly with other sheets that are non-form responses. How can i solve this sir?
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.
Can you add print option in this
Sir, in this whole series you also didn't talk about upload item, Please make it in coming video
use webApp
you teach awesome can you provide me online class for it
MVP
Sir Thanks for the video , but if we have to use Date then all goes Haywire , We can only add Dates but cannot edit Them or search them , can you help
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.