Watch Full Web App Series th-cam.com/play/PLv9Pf9aNgemt82hBENyneRyHnD-zORB3l.html Google Sheets Userform Wep App Level 2 th-cam.com/play/PLv9Pf9aNgemuzTNWeHd8HziGVNzSlWACh.html CRUD Web App Series th-cam.com/play/PLv9Pf9aNgemvM36efLpaHxbkZTGp2pfhx.html
I have written code in the same way as mentioned in the video but the sheet is not updating and the fields are not clearing after I hit submit. I can share my code if you want. Please suggest me a solution.
@@nihaalaekka8509 I had same thing. until I see Thinh Nguyen below, solved it. "If you follow the instruction until 19:12 and get nothing in the Log, just go to the menu Run and choose Disable new App Script runtime powered by Chrome V8, then everything will work. " Chrome V8 Probably wasn't a feature when this video was created. On top of that, Google is going to change the APP script Editor interface which will be more confusing. Like Google wants to copy 1990-2010 Microsoft of rolling out new Windows every few years to confuse everyone. also addEventListener didn't work for me, not sure why. I got around it by adding onclick code.
Almost started to give up on AppScript and then I discovered your channel... THANK YOU! Your way of explaining makes so much more sense than reading through Google's online help. If at all possible, could you do some examples of using Google Forms with AppScript and Google Sheets? Things like populating drop downs, button actions etc.
As usual fantastic tutorial, I am learning so much from your channel. Thanks. Ref. 9:48 Just in case someone is having trouble passing multiple values with the same parameter, the way to pass different categories is like this: category=6&category=44&category=2. If you just separate the values with commas you end up with one category having the string value "6,44,2".
I also discovered this anomaly (in 2024). I guess your comment being 3 years old and the tutorial 5 years old, maybe Goolge had changed something under the hood.
If you follow the instruction until 19:12 and get nothing in the Log, just go to the menu Run and choose Disable new App Script runtime powered by Chrome V8, then everything will work.
If you run into trouble trying to Log the (e) or event click on the "Apps Script Dashboard" link at the bottom of the log window, this will show you the log output that matches the video.
@@erickk716 They must have updated Apps Script. On the pop up page with "null" click on the text link at the bottom "Apps Script Dashboard" and if you click on each log it will show you what's referenced in the video.
I just started making one myself (total newbie on this) Apparently this is not the only thing that has been slightly changed, the part where function 'userClicked' is now considered TypeError & cannot get the log for "Someone Clicked the Button". Any idea how to fix this?
Dude!!! I've been watching you for years. You should put a couple of classes together so we can get a certification from your content. Thank you so much for all the help. Have a great day!! 😁
This tutorial is best of the best of the best That I have seen last 12 years. Simple frontend backend database web app in 30 minutes. Thank you for your time.
Going back to this tutorial, I realized it would be awesome if there is a way to fill out a fillable PDF from information provided in the web app. As always, I appreciate your tutorial bro. Keep them coming.
It is, all you need to to is integrate the form data with Google Docs or Google Slides, for example SlidesApp has the function replace all text which you can run along with DriveApp to create a temporary copy and replace your info, then you can save the blob as PDF and export it, save it in your Google Drive our use MailApp to email it
This is such an amazing video. You really have a great teaching style, everything is so clear and you explain everything so good! thank you so much for helping out
I have not found any video material on web, regarding this, better than yours. Salute and Respect for your detailing and convincing method of conveying rather teaching
WOwowow wowo man! This tutorial did just opened my eyes. And all this come free with google if you can program little bit :) Thankyou so much for this tutorial man, loved it. Its mind blowing
Hi. I am beginner and your video is so helpful. btw, I just ran doGet(e) function and it says 'TypeError: Cannot read property 'parameter' of undefined (line 2, file "Code")'. i wrote down exactly as same as you wrote. what could be the problem?
Thank you Learn Google Spreadsheets! Your videos really helped me out when I was beginning to learn to program. Now, I'm a small TH-camr producing tutorials on Apps Script and Google Cloud myself. But how did you get over 100K+ subscribers? I really hope to build a channel like yours someday! :)
Keep producing videos. you have good content! When you first get going it will be slow but then by year two you'll see 5K subs and year three 25K. You just gained one more sub from me!
Well, he got so many subscribers is because he is very good at what he does. His teaching style and structure fits most people from beginning to seasoned programmers who want to get into google script. You will get there if you keep working on your craft.
Very nice tutorial. I am writing standalone scripts for myself, not using html interaction. Need arised to share with my colleagues. WebApp deployment is found appropriate, for which this tutorial is apt. Thanks.
Genious in teaching! Yes please make an html video explaining these options (output, evaluate etc.), explaining scriptlets and what's the difference in using them with using , when and why. How to properly use a script inside an html file, interaction between them. So appreciate your efforts!!!
Very clear and precise. Way better than all the blogs and videos I've seen in the past 48 hours. Big thanks. Question: I have already have an HTML form with more details. Do I need to add a variable for each input type?
This is so great, wonderful tutorial. Thanks for all have you done. I wrote the same code like you but I got an error in HTML button, it doesn't work when I do click but when I run the function works perfectly, could you help me, thanks again bro!
@@ExcelGoogleSheets I wrote the same code like you but I got an error in HTML button, it doesn't work when I do click but when I run the function works perfectly, could you help me, thanks again bro! is there any problem with google.script.run.myFunc() ?
**SOLVED: So I followed the tutorial (two times) and ended up copying basically everything - word by word - to conclude that some things changed for sure. 1. The log changed in the way it shows the data - can't show parameters (error when you try) 2. google.script.run.userClicked(); does not work anymore. At least not for me (oktober 9 2021). - I checked typing errors etc. Everything was exactly as shown in the video. What is the workaround for the second problem? I really want the page.html to call/use the functions of the gs. code. Amazing tutorial videos btw. Liked as well! And I know things change from time to time, so I don't blame the content at all - Love these videos!
Parameters still work, you just have to check the logs under Executions instead of View->Logs. The only way google.script.run wouldn't work is if you have some sort of security plugin on your browser that prevents it from working OR you have multiple Google accounts and Google isn't able to recognize the right account when you run the script. The solution for the latter is to log out of all your accounts and login with the right account.
Amazing videos sir, good job, the videos are easy to follow with proper explanation. I was working on your example and keep getting this eror - Typeerror property cannot be read" get active sheet" is undefined Please help with error
Thank you for making this. I love the tutorials. Any chance you can share the code from the lesson? I am copying what you are doing but for some reason it is not working.
Hey thanks for the great series! I am knew to app script and coding and was hoping if you could help out with a small issue i am facing. The variable declared in the HTML JS to be called within the App Script code is not getting identified as a variable. thanks
Another very nice tutorial. anyway How To Install It on Spreadsheet ? i mean, when editor open the spreadsheet link, they will face with that app first to log in.
Excelente tu aporte. Soy de Colombia y estoy sencillamente encantado con la claridad con que explicas. Por cierto, no hablo muy bien Inglés; no obstante comprendo tus videos. Gracias por tu colaboración y dedicación.
Hi, Great material! I wonder if you think it'd be possible - and legal at all - to create a google web app and rent out the solution by granting access to a 3rd party without them having the possibility to duplicate the app and start using on their own. If yes, I also wonder if it's possible to create pdfs with a press of a button within the app, to which the user would have access via a shared folder and get it somehow email it to their customer by a couple of clicks. Thanks in advance for your answer!
Amazing work man, I'm learning so much! What I'm struggling to do is to pre-fill a text input using a parameter from the URL, in future lesson you teach about tmp.name (example) before evaluate so you can use the "name" in HTML, like in the Title thing you tested, but I need to use inside the part, so doesn't work... document.getElementById("name").value = name; also doesn't work, the text field becomes: [object HTMLInputElement] Any help in this matter?
Good morning, first of all, excellent tutorial. I followed it but it can't read the data I insert into the textbox..... It tells me it can't read the parameters of e.
Hello- I'm having trouble seeing the names getting 'undefined' instead of 'joe' or 'ana'...and then I moved on to the spreadsheet and 'commenting' out the other logger.log function, and am having the same issue there too, the error message reads: TypeError: Cannot read properties of undefined (reading 'parameter') ....the names are not showing up. in the new spreadsheet
Thank you! I wanted to know, How can I add two buttons and get the data in the same row in the spreadsheet? I want to get log in and log out times which will be clicked at their respective times.
Hello my friend, I really appreciate the videos that on google sheets, I work at a university and I really do a lot of discipline controls and teaching plans using this incredible tool. I prepared a script that helps me with different titles written in Brazilian Portuguese, these titles or names need to have their first letters in uppercase, however in my language there are stopwords that should not be with the first letter in upper case. I decided to search and got a script using a database on a spreadsheet sheet as a reference to disregard the stopwords and thus result in the real upper case of my names and titles. My wish is to create a web application of this sheet that is open to the public of the university I work in, but because it has a script, it ends up needing a login so that friends can use it. So if I can make a web application, it will be useful for all of us I have seen your work on web application, but I haven't seen anything I need for this project of mine. It would exactly return the result of the operation and a script. In this case, the user accesses the web application and there he pastes several lines of titles or names, there he will have a button that he clicks so that the script (which is already ready) returns the result in the web application. It seems to be something really simple, but my knowledge still doesn't help me. I am looking to make this possible so I ask for your help. Strong hug!
Great content, congrats! You see, it gets me nervous watching you typing , ,. Press , man. Auto indent works really fine. You may even select many lines at once and auto indent them all hitting a single ... Peace ✌
Perhaps I know what you mean: I'm Firefox user. On GAS, I have to go to Chrome. Many problems are gone, better interop. You seem to be Safari, I guess. Give Chrome a try, only to handle GAS editor
@@ExcelGoogleSheets - In the 'Google app script' window, there is an indent (toggle) button at the top (below the main menu bar). If it was enabled, pressing on your keyboard wouldn't work. In your video, this indent button was showing as enabled. You have to toggle/disable it for presses to work (meaning auto indent). I had to scratch my head for a minute to figure this out. Hope this helps.
Unfortunately it doesn't work for me. I've created and replicated doGet function as shown. But html page won't appear due to "Script function not found: doGet" error.
Hi, thank you very much to share your knowledges. May i ask you? Do you plan to make a video how to get data from spreadsheet by fill in the input boxes how you did to write the data in the spreadsheet. This would be like a search of data in the spreadsheet and get the result as alert or popup for example? Thank you again, keep going.
Estoy flipando pepinillos, apenas vi que se podía incluir css, js, html, y sigo flipando leyendo la documentación , ya estoy diseñando en el papel la app que voy a armar, muy buenos videos!!! like vitalicio para los videos de este canal
I've found that in the new version of the Apps Script editor, the Logger/console output of these functions DOES NOT appear in the "Execution log" (of the top bar) BUT in "Executions" (in the sidebar) as "Cloud logs". I've always used the new editor and haven't changed any of the default settings of the project. Ideally I'd like to have the output come out in the "Execution log" below the coding but it doesn't seem to be possible?
Hello! I'm having an issue with the names changing whenever it's typed into the box 'joe'/'ana'...it keep showing up as undefined. The new/old apps script editor is throwing me off a bit, can anyone help?
Thanks for the video. It's quite clear to me that you are a Google expert!. Here's my question: Is it possible to use Google Apps Script to create a simple website to delete a row in a google sheet? Let me explain what I am trying to do. I know how to add data to a row in Google Sheet and I also know how to edit the data in a row, what I don't know is how to delete the data (a row) in Google Sheet. Obviously, I am talking about doing it by using code. Is there a way to do it? that is what I need to finish a personal proyect. I really appreciate the help that you can giive me. Thank you very much. Emilio (By the way, sorry for my English, I am an English learner)
@@ExcelGoogleSheets Thanks for answering so quick!...Your code sounds really good, but in my case, I need to find out , so to speak, the row I need to delete by the value that there is in one column. In other words, I need to delete the row in which the a specific and unique text is in one column. I don't know if I am able to explain what I intent clearly. By the way, I am watching your videos about Google Apps Script and at this moment I am watching the fourth .
@@ExcelGoogleSheets WoW! that would be amazing! Meanwhile I'll be watching all your videos related to this topic and I am going to follow your example, following your steps one by one. It's gonna be a kind of course for me. Thanks, I have no words to express how I fell . Thanks a lot.
Watch Full Web App Series th-cam.com/play/PLv9Pf9aNgemt82hBENyneRyHnD-zORB3l.html
Google Sheets Userform Wep App Level 2 th-cam.com/play/PLv9Pf9aNgemuzTNWeHd8HziGVNzSlWACh.html
CRUD Web App Series th-cam.com/play/PLv9Pf9aNgemvM36efLpaHxbkZTGp2pfhx.html
I have written code in the same way as mentioned in the video but the sheet is not updating and the fields are not clearing after I hit submit. I can share my code if you want. Please suggest me a solution.
@@nihaalaekka8509 Same. Refreshing page actually has no effect on the Execution Log; must run functions from the console. Did you crack it?
@@nihaalaekka8509 I had same thing. until I see Thinh Nguyen below, solved it. "If you follow the instruction until 19:12 and get nothing in the Log, just go to the menu Run and choose Disable new App Script runtime powered by Chrome V8, then everything will work. " Chrome V8 Probably wasn't a feature when this video was created. On top of that, Google is going to change the APP script Editor interface which will be more confusing. Like Google wants to copy 1990-2010 Microsoft of rolling out new Windows every few years to confuse everyone. also addEventListener didn't work for me, not sure why. I got around it by adding onclick code.
Thank you
This is so great. You are opening doors to things that seemed unattainable to a novice like me. Thank you.
Almost started to give up on AppScript and then I discovered your channel... THANK YOU! Your way of explaining makes so much more sense than reading through Google's online help.
If at all possible, could you do some examples of using Google Forms with AppScript and Google Sheets? Things like populating drop downs, button actions etc.
As usual fantastic tutorial, I am learning so much from your channel. Thanks.
Ref. 9:48 Just in case someone is having trouble passing multiple values with the same parameter, the way to pass different categories is like this: category=6&category=44&category=2. If you just separate the values with commas you end up with one category having the string value "6,44,2".
I also discovered this anomaly (in 2024). I guess your comment being 3 years old and the tutorial 5 years old, maybe Goolge had changed something under the hood.
If you follow the instruction until 19:12 and get nothing in the Log, just go to the menu Run and choose Disable new App Script runtime powered by Chrome V8, then everything will work.
oh my god thank you, that was bugging me so much.
If you run into trouble trying to Log the (e) or event click on the "Apps Script Dashboard" link at the bottom of the log window, this will show you the log output that matches the video.
may i know why this happen? i mean the null value from the log.
@@erickk716 They must have updated Apps Script. On the pop up page with "null" click on the text link at the bottom "Apps Script Dashboard" and if you click on each log it will show you what's referenced in the video.
i should have came to comments 15 mins earlier😑 thank you btw😂
I just started making one myself (total newbie on this)
Apparently this is not the only thing that has been slightly changed, the part where function 'userClicked' is now considered TypeError & cannot get the log for "Someone Clicked the Button".
Any idea how to fix this?
Inhabilitar el nuevo tiempo de ejecución de Apps Script con tecnología de Chrome V8
clearest ever tutorial on appscript
🙂
World's Best Teacher
Best Quality
Learn Easy and Understand
I Love And Like All Video
Dude!!! I've been watching you for years. You should put a couple of classes together so we can get a certification from your content. Thank you so much for all the help. Have a great day!! 😁
I have created a valuable online application after watching your videos, thank you very much👍
You are so clear! I practically do not speak english, but with your videos I learn both. Thank you for your time..
This tutorial is best of the best of the best That I have seen last 12 years. Simple frontend backend database web app in 30 minutes.
Thank you for your time.
Going back to this tutorial, I realized it would be awesome if there is a way to fill out a fillable PDF from information provided in the web app. As always, I appreciate your tutorial bro. Keep them coming.
It is, all you need to to is integrate the form data with Google Docs or Google Slides, for example SlidesApp has the function replace all text which you can run along with DriveApp to create a temporary copy and replace your info, then you can save the blob as PDF and export it, save it in your Google Drive our use MailApp to email it
This is such an amazing video. You really have a great teaching style, everything is so clear and you explain everything so good! thank you so much for helping out
you are the best teacher ever
I really enjoyed watching this video! Perfect quality, sound, compact teaching, just perfect! Thank you SO MUCH and wish you all the best.
I have not found any video material on web, regarding this, better than yours. Salute and Respect for your detailing and convincing method of conveying rather teaching
Super step to make webpage easy way. I can apply these step for small business. Thank you so much and very much. :))
developing in the cloud ! OMG... I'm from the old school of the 90's AMAZING ! thanks
This is great! I've been using Google App scripts for a while;but, haven't done any UI expect with the Google Apps. This is a great jump start.
WOwowow wowo man! This tutorial did just opened my eyes. And all this come free with google if you can program little bit :) Thankyou so much for this tutorial man, loved it. Its mind blowing
I think your great at doing all these videos. you teaching is clear an concise. Love it.
You´re a genius. Amazing video. Here again.
This is really a great video. I think this would change my methods with the registration in my educational spreadsheets.
You are doing a very noble work, thank you so much.
Thank you for these information. They helps a lot. You teach step by step and easy to understand. It helps me to be better at my work.
Great to hear!
Fantastic. This is your best video until now.
Bruno Valadares )
Great training for novices.
Hi. I am beginner and your video is so helpful. btw, I just ran doGet(e) function and it says 'TypeError: Cannot read property 'parameter' of undefined (line 2, file "Code")'. i wrote down exactly as same as you wrote. what could be the problem?
Thank you Learn Google Spreadsheets! Your videos really helped me out when I was beginning to learn to program. Now, I'm a small TH-camr producing tutorials on Apps Script and Google Cloud myself. But how did you get over 100K+ subscribers? I really hope to build a channel like yours someday! :)
Keep producing videos. you have good content! When you first get going it will be slow but then by year two you'll see 5K subs and year three 25K. You just gained one more sub from me!
Well, he got so many subscribers is because he is very good at what he does. His teaching style and structure fits most people from beginning to seasoned programmers who want to get into google script. You will get there if you keep working on your craft.
So VERY glad somebody walked me thru this processes!! Thanks for making this video.
Very nice tutorial. I am writing standalone scripts for myself, not using html interaction. Need arised to share with my colleagues. WebApp deployment is found appropriate, for which this tutorial is apt. Thanks.
I really enjoyed this video. This is what I have been looking for. I would like to know more on HTML Thanks
I love this. It's so easy to follow you and understand. Thanks for sharing.
👍
Genious in teaching! Yes please make an html video explaining these options (output, evaluate etc.), explaining scriptlets and what's the difference in using them with using , when and why. How to properly use a script inside an html file, interaction between them. So appreciate your efforts!!!
Thanks Brother . i am writing 1st time in J.S
Keep it up
Great tutorial... Finally found solution how to make google script app using html service after ui service deprecated warning here. Thanks you!!!
Please Add more vids on app script..
Awesome content as always..
Very clear and precise. Way better than all the blogs and videos I've seen in the past 48 hours. Big thanks. Question: I have already have an HTML form with more details. Do I need to add a variable for each input type?
very fun first go, thank you for the tutorial, in programing it is always gratifyingly to get results quickly
Excellent tutorial as usual
Excellent video, as others people say don't stop, we are waiting for more, thanks a lot. You are a teacher by nature
Sir, Logger.log(e) or Console.log(e) both gives "undefined" on Log!
Inhabilitar el nuevo tiempo de ejecución de Apps Script con tecnología de Chrome V8
This is so great, wonderful tutorial. Thanks for all have you done. I wrote the same code like you but I got an error in HTML button, it doesn't work when I do click but when I run the function works perfectly, could you help me, thanks again bro!
I got this error: Uncaught TypeError: document.getElementById(...).addEvenListener is not a function
it's not Even it's Event
@@ExcelGoogleSheets I wrote the same code like you but I got an error in HTML button, it doesn't work when I do click but when I run the function works perfectly, could you help me, thanks again bro! is there any problem with google.script.run.myFunc() ?
THIS IS GOOD STUFF
I MEAN, REALLY GOOD STUFF
YOU'RE THE MAN !!
google.script.run.userclicked() does not work, please explain why
You are a life saver. Great Job!
Thanks a lot for those tutorials. They are really helpful, so well organized and much detailed!
Keep up the good work!
Bools eye. No bullshitting , just pure knowledge. awesome style.
First 10 seconds and I was like this is what I am searching for years😋🐒
Very nice teaching! Thanks for adding new contents.
Thank you so much!
This is the kind of video that changes the world : )
**SOLVED:
So I followed the tutorial (two times) and ended up copying basically everything - word by word - to conclude that some things changed for sure.
1. The log changed in the way it shows the data - can't show parameters (error when you try)
2. google.script.run.userClicked(); does not work anymore. At least not for me (oktober 9 2021). - I checked typing errors etc. Everything was exactly as shown in the video.
What is the workaround for the second problem? I really want the page.html to call/use the functions of the gs. code.
Amazing tutorial videos btw. Liked as well! And I know things change from time to time, so I don't blame the content at all - Love these videos!
Parameters still work, you just have to check the logs under Executions instead of View->Logs.
The only way google.script.run wouldn't work is if you have some sort of security plugin on your browser that prevents it from working OR you have multiple Google accounts and Google isn't able to recognize the right account when you run the script. The solution for the latter is to log out of all your accounts and login with the right account.
@@ExcelGoogleSheets Wow! Thanks for your. help. Fixed it now. 🔥🔥🔥
@@ExcelGoogleSheets And thank you for taking your time to answer. I've spend countless of hours following your videos. Big fan!
@@OccasionalRunner What did you do to fix it. I'm having the same problem
It's just amazing ! I'm from France and your tutorial is just fantastic for learn. Don't stop yeah, thank you !
Amazing videos sir, good job, the videos are easy to follow with proper explanation.
I was working on your example and keep getting this eror -
Typeerror property cannot be read" get active sheet" is undefined
Please help with error
Your tuts have been helping me so much. You're amazing! Thank you very much!
thanks for a great vid, i reference this vid mabye 10 times over the years LOL
loov u
Remember That You May Have An Error While Adding The string , To Fix That Add Your Text
Great. Thank you 👍👍👍 you're the best
Thank you for making this. I love the tutorials. Any chance you can share the code from the lesson? I am copying what you are doing but for some reason it is not working.
Nice, Helpful video,saya 😘
Great video,. The best tutorial about how to use GAS for newbie.
Awesome. well done for the good job.
Really appreciate these, has helped me so much. Please don't stop!!!
Thank you for creating a very helpful and easy to follow video! Great job!!!
Thanks a lot! It's a long awaited video. Please, give us more about google web scripts
Hey thanks for the great series! I am knew to app script and coding and was hoping if you could help out with a small issue i am facing. The variable declared in the HTML JS to be called within the App Script code is not getting identified as a variable. thanks
Great video by Google thanks for sharing this valuable video.
Another very nice tutorial. anyway How To Install It on Spreadsheet ? i mean, when editor open the spreadsheet link, they will face with that app first to log in.
Excelente tu aporte. Soy de Colombia y estoy sencillamente encantado con la claridad con que explicas. Por cierto, no hablo muy bien Inglés; no obstante comprendo tus videos. Gracias por tu colaboración y dedicación.
You are Awsome as usual
Every tutorial is a killer
Only two words : Great, Thanks !
Hi,
Great material!
I wonder if you think it'd be possible - and legal at all - to create a google web app and rent out the solution by granting access to a 3rd party without them having the possibility to duplicate the app and start using on their own.
If yes, I also wonder if it's possible to create pdfs with a press of a button within the app, to which the user would have access via a shared folder and get it somehow email it to their customer by a couple of clicks. Thanks in advance for your answer!
Excellent tutorial. Very well explained, the logic is clear. Great job ! Thanks a lot
Great video. Can we search and print data from spreadsheet in same manner. Means by clicking a button. Please help.
Amazing work man, I'm learning so much!
What I'm struggling to do is to pre-fill a text input using a parameter from the URL, in future lesson you teach about tmp.name (example) before evaluate so you can use the "name" in HTML, like in the Title thing you tested, but I need to use inside the part, so doesn't work...
document.getElementById("name").value = name; also doesn't work, the text field becomes: [object HTMLInputElement]
Any help in this matter?
developers.google.com/apps-script/guides/html/reference/url
Very useful video for me, it help me understand work on freelance. Thank you!
Good morning, first of all, excellent tutorial. I followed it but it can't read the data I insert into the textbox..... It tells me it can't read the parameters of e.
very usefull even in 2021
excellent!
This is an awesome video! Helped me to understand the way html page connects to functions in Apps Script. Thank you!
Glad it was helpful!
@@ExcelGoogleSheets Helped me write a nice script for my boss. It was accepted today ;) Thanks again!
Thank you so much mate!
Your videos are so informative.
Great job.
Great to hear.
Very Nice Tutorials.. Please keep on making such useful stuff
want to ask
at 7:25
why my log is "nul"
and if i reload the web app, the log doesn't change
and if i "run" manually, the log change
thank
i have the same problme did u solve this?
Hello- I'm having trouble seeing the names getting 'undefined' instead of 'joe' or 'ana'...and then I moved on to the spreadsheet and 'commenting' out the other logger.log function, and am having the same issue there too, the error message reads: TypeError: Cannot read properties of undefined (reading 'parameter') ....the names are not showing up. in the new spreadsheet
Thank you! I wanted to know, How can I add two buttons and get the data in the same row in the spreadsheet? I want to get log in and log out times which will be clicked at their respective times.
write the button code twice for both different names
Can you teach us more webapp related topics like this, probably make it more dynamic from start to finish if that's ok? Would love that :)
Hello my friend, I really appreciate the videos that on google sheets, I work at a university and I really do a lot of discipline controls and teaching plans using this incredible tool.
I prepared a script that helps me with different titles written in Brazilian Portuguese, these titles or names need to have their first letters in uppercase, however in my language there are stopwords that should not be with the first letter in upper case. I decided to search and got a script using a database on a spreadsheet sheet as a reference to disregard the stopwords and thus result in the real upper case of my names and titles.
My wish is to create a web application of this sheet that is open to the public of the university I work in, but because it has a script, it ends up needing a login so that friends can use it.
So if I can make a web application, it will be useful for all of us
I have seen your work on web application, but I haven't seen anything I need for this project of mine. It would exactly return the result of the operation and a script.
In this case, the user accesses the web application and there he pastes several lines of titles or names, there he will have a button that he clicks so that the script (which is already ready) returns the result in the web application.
It seems to be something really simple, but my knowledge still doesn't help me. I am looking to make this possible so I ask for your help.
Strong hug!
Great content, congrats!
You see, it gets me nervous watching you typing , ,. Press , man. Auto indent works really fine. You may even select many lines at once and auto indent them all hitting a single ...
Peace ✌
I wish it did. It works sometimes, then it doesn't work other times. I hate their editor, I wish there was a way to integrate in Visual Studio Code.
Perhaps I know what you mean: I'm Firefox user. On GAS, I have to go to Chrome. Many problems are gone, better interop.
You seem to be Safari, I guess. Give Chrome a try, only to handle GAS editor
I use Firefox in this video. Too many privacy issues with Chrome, but yea, it would probably work better in it.
@@ExcelGoogleSheets - In the 'Google app script' window, there is an indent (toggle) button at the top (below the main menu bar). If it was enabled, pressing on your keyboard wouldn't work.
In your video, this indent button was showing as enabled. You have to toggle/disable it for presses to work (meaning auto indent). I had to scratch my head for a minute to figure this out. Hope this helps.
Please brother, some html video will be nice, great videos, you helped me a lot
Thank you for this Video, man
Unfortunately it doesn't work for me. I've created and replicated doGet function as shown. But html page won't appear due to "Script function not found: doGet" error.
Looks like you didn't save & deploy the app.
Here's everything I need.
Hi, thank you very much to share your knowledges. May i ask you? Do you plan to make a video how to get data from spreadsheet by fill in the input boxes how you did to write the data in the spreadsheet. This would be like a search of data in the spreadsheet and get the result as alert or popup for example? Thank you again, keep going.
Yes, so needed! To place dynamic data from sheet to a sidebar with checkboxes and then get back.
Spassiba@@julia.vasilieva
Great Tutorial. Thank you for sharing.
Estoy flipando pepinillos, apenas vi que se podía incluir css, js, html, y sigo flipando leyendo la documentación , ya estoy diseñando en el papel la app que voy a armar, muy buenos videos!!! like vitalicio para los videos de este canal
I've found that in the new version of the Apps Script editor, the Logger/console output of these functions DOES NOT appear in the "Execution log" (of the top bar) BUT in "Executions" (in the sidebar) as "Cloud logs". I've always used the new editor and haven't changed any of the default settings of the project. Ideally I'd like to have the output come out in the "Execution log" below the coding but it doesn't seem to be possible?
Runs triggered by events will not appear in "Execution log".
Thanks for mentioning this. I was scratching my head for a little while trying to find the parameter outputs...
Hello! I'm having an issue with the names changing whenever it's typed into the box 'joe'/'ana'...it keep showing up as undefined. The new/old apps script editor is throwing me off a bit, can anyone help?
Nice! Very useful
Cảm ơn bạn, bài viết rất hữu ích, đã giúp mình rất nhiều.
Thanks for the video. It's quite clear to me that you are a Google expert!. Here's my question: Is it possible to use Google Apps Script to create a simple website to delete a row in a google sheet? Let me explain what I am trying to do.
I know how to add data to a row in Google Sheet and I also know how to edit the data in a row, what I don't know is how to delete the data (a row) in Google Sheet. Obviously, I am talking about doing it by using code.
Is there a way to do it? that is what I need to finish a personal proyect. I really appreciate the help that you can giive me.
Thank you very much.
Emilio
(By the way, sorry for my English, I am an English learner)
var ss = SpreadsheetApp.getActiveSpreadsheet();
var ws = ss.getSheetByName("Sheet1");
// this deletes the 3rd row
ws.deleteRow(3);
@@ExcelGoogleSheets Thanks for answering so quick!...Your code sounds really good, but in my case, I need to find out , so to speak, the row I need to delete by the value that there is in one column.
In other words, I need to delete the row in which the a specific and unique text is in one column.
I don't know if I am able to explain what I intent clearly. By the way, I am watching your videos about Google Apps Script and at this moment I am watching the fourth .
There are a lot of steps. I will have an example of this uploaded next month.
@@ExcelGoogleSheets WoW! that would be amazing! Meanwhile I'll be watching all your videos related to this topic and I am going to follow your example, following your steps one by one. It's gonna be a kind of course for me. Thanks, I have no words to express how I fell . Thanks a lot.
Really Great much helpful great information like the door to door hit it, may be possible some more Tutorial about creating an application:) Thankyou.
Very useful. Thank you for sharing.