Good video! If anyone need the timestamps, here they are: Part1: Variables 1:41 Part2: Strings 5:20 Part3: Numbers 8:39 Part4: functions 10:50 Part5: Arrays 17:20 Conclusion: Where to go next? 24:30
@@JordanRhea Good afternoon, I was coding the confirmation email and did the same thing as the guy did in this video: Google Forms Email Notification Script Send Confirmation Emails To Users by Learn Google SpreadSheets. I was wondering if you know a way where I can input a code that can allow the user's response in the email so they can see their responses? I was also wondering if there was a way that the Google Sheets that I linked can only show what the respondent answered so it won't show all the questions that they didn't answer? Thank you.
Jordan, you made my day, very apt explanation, I have understood Apps Script as covered in this video. I wish to learn more. Show mw the way. Do you have videos in this context. Do let me know. Thanks again.
Sounds like you should be on an episode of Mad Men typing up a memo while sipping on your glass of Scotch....lol... that keyboard is so loud... love the video!
Fantastic Video's Jordan. I caught on to several key concepts that you didn't really talk about but I recognised what was happening immediately. Very helpful and really good showing some of the other resources to access in the Where to from here section.
Thank you for this tutorial. You certainly ahve given me a very quick over view of where I need to start with the project I am working on. Thank you again!
Great video! I'm a little confused about the indexing for the array of the function argument. In my testing it seems like the indexing changes depending on how many cells you select. If you select more than one row and column, it seems to be [row][column][character] but if you only select one cell, that no longer seems to be true. I need to know what the contents of the array will be when I pass different cells into the function. Thanks!
thx for the video, still idk if anyone noticed but variable randomKey goes from 1 to 8 which it shouldnt, the normal range for words array should've been from 0 to 7. Just a minor note
Nice Job, Jordan! Question: can you make the final code example available in text form? That would make it a very nice sample example to start from for beginners? Just a suggestion.
great video, well videos (only found your channel the other day), very helpful. would like to see you do some more on add ons and turning scripts / sheets into web apps.. or just more on app scripts 😬 again great stuff that I've watched so far, learnt quite abit
Thanks +Mike! Can you be more specific about what you would like to see? I would love to do more videos about deploying scripts as web apps, and the more useful I can make them the better!
Loved the side bar example, and freecodecamp referral. Can you do more on sidebar using say check boxes to show hide columns/rows in the sheet? similar to VSTO in docx
great job - prob could use more clarification on how the contents of the "names" array are populated... took me a minute to figure out it was being populated by the spreadsheet itself. Cool stuff!
Just a small advice to you; You need to plan the presentation of facts and contents in a orderly manner than being so so.... and that will help you to retain the view and stay on with interest. Focus on a specific area with meaningful objectives. Hope this will not hurt your feelings.
create a button in spreadsheet: go to insert menu, choose image, and insert fuction name in that image. Btw I am a new learner on google sheets and apps script, I try to documenting my simple learning result in this channel ruclips.net/channel/UCuCFRM4818jYd2WdqX4QXDQ
Very good intro to scripting with google sheets. (Maybe less doubts where better !) If you want the functions appears when you write it down in spreadsheet, the thing to do is before the function definition: /** Your comment @customfunction */ This should do the trick ;)
Hello Jordan. I have found your video tutorials excellent and well explained. Could you do one of how to pass data from Add on to the document or spreadsheet ?. I have searched but I have not found any. I would really appreciate it and thank you for what you do.
Hi , i like your video !! i have a question How to deploy the script [make the information captured from google sheet Go Directly to google Doc automated ] Thank You very much for your help
Hi. I have an array of dates. I wish to find the difference of days from a particular date with the dates in the array and store it in another array. Please tell me how to do?
Hi Jordan, first of all, thank you very much for give us a bit of your knowledge. I am having an error on my trying: When I try this> function emails(names) { return names [0][0][0] + names[0][0][1]; } and call the function on my sheets My result is this: Fernanda Breston Fundefined
This is great! Or you have a paper notes by your side while u lecture. This may be more smoothly presented and the readers have more confident on u. Go ahead n have more. 😀😄🌿🌹🍃😊
Thanks so much. I definitely had an outline of what I wanted. The difficult thing for me is talking to a computer screen and not a classroom. If you want do a deeper dive into Javascript, the resources at freecodecamp.com are incredible.
Is there any way to have it so that when a person logs on to a google doc, that they make a suggestion, and then right after have it delete that suggestion, just so that I can see if they logged into the doc, even if they don't type anything.
I have a sheet with a list of names and when I follow your steps it doesn't pull from my sheet: function EMAILWRITER (names) { return names [0][1] } WHY?
When i type "getra" for example, it didn't appears all the functions i can use, as "GetRange...". How to activate these function that i think it's called by autocomplete?
hii sir i have a one query in Gmail in compose mail addon. Click the compose mail addon to redirect another page. How do i can these opration to click addon to redirect anther page.......????
Thanks Jordan! Much Appreciated, really looking forward to learn JavaScript for the only purpose of using Google Apps Script. Any other Resources you would recommend besides freecodecamp.com? Did you start from scratch at freecodecamp?
I had a little bit of experience with Python and PHP, but FCC was where I really sat down and focused on one language. Bookmark stackoverflow.com and feel free to reach out to me for anything you can't figure out on Google. Cheers!
Thanks! Will focus in FCC and thanks for offering to help out! I remember spending a few weeks some months back, managed to do the little project I had with the help of stackoverflow but I struggled to really understand the structure of the documentation @ developers.google.com.- Surprisingly there are plenty of JavaScript online courses but nothing really for Google Apps Script except a few videos here and there, nothing too formal. Thanks again!
14:39 - I'm getting: Jim, Joes undefined Bill, Nothing undefined. Here's my code: function EMAILWRITER(names) { return names[0,0] + ' ' + names[0,1]; } By the way, I don't get what names[0,0] is or how it works. I've understood the arrays concept you mentioned where you can put multiple items in an array or an "Array of items" in a variable and the part where you mention var ExampleString[1] = First character of string But how exactly does names[0,0] work? What does it do? I don't get it. I want to get it. Please tell me! :D
The only problem with your code is that you need to access the array like: return names[0][0] + ' ' + names[0][1] Since the names variable comes in as a multidimensional array, you need to access first the 0 index and then the 0 and 1 index to get the names. There are much more detailed explanations of multidimensional arrays on youtube. Here is one that uses a similar example: ruclips.net/video/Cta5s1QBD8E/видео.html
Thanks so much for the compliment. I would publish your add-on as 'unlisted' on the webstore and then share the link with whoever you wanted to use it. If you publish publicly there a bunch of webstore requirements that you need to meet that can prove challenging. Good luck!
GO easy on the non-words like 'uh--', 'ah-', 'um-' as it is difficult to continue listening to videos where this is so excessive, unless you really want to finish it. I trained people for many years in ICT and peoplewould prefer pauses than non-words.
You typed very fast and you taught me how to use google apps script! Thank you so much!
For more beginner reference ruclips.net/video/Z5n-q2W_5QM/видео.html
Good video!
If anyone need the timestamps, here they are:
Part1: Variables 1:41
Part2: Strings 5:20
Part3: Numbers 8:39
Part4: functions 10:50
Part5: Arrays 17:20
Conclusion: Where to go next? 24:30
1:39 variables
5:17 strings
8:37 numbers
10:51 functions
24:29 conclusion
It's about time I learn how to code, thanks so much!
I have been JavaScript in my spare time. I did not know what it would come handy writing scripts in Google. Thanks !
At 1.5 speed this is perfect. Thank you so much.
+lhmissio thanks! The ability to speed up videos is a great feature. Especially with my ramble level being so high
x2 is best if you dont want to bored
🙏 thank you
yeah tutorial videos inevitably work best sped up a bit, lol
What you did at 2:28 is what I was looking for for the past hour. I love you now.
+Dutch Ban Republic Glad it helped!
@@JordanRhea Good afternoon, I was coding the confirmation email and did the same thing as the guy did in this video: Google Forms Email Notification Script Send Confirmation Emails To Users by Learn Google SpreadSheets. I was wondering if you know a way where I can input a code that can allow the user's response in the email so they can see their responses? I was also wondering if there was a way that the Google Sheets that I linked can only show what the respondent answered so it won't show all the questions that they didn't answer? Thank you.
Jordan, you made my day, very apt explanation, I have understood Apps Script as covered in this video. I wish to learn more. Show mw the way.
Do you have videos in this context. Do let me know.
Thanks again.
Glad it was helpful! I am going to start posting more videos, I will definitely be looking for positive feedback.
Great intro to JavaScript and Google App Script - very helpful.
Thanks a ton +MJ Aldred! Your compliments are motivating
Great intro, thanks for this! Would be great to see another dealing with how to write scripts dealing with handling dates...that's been throwing me.
I caught onto many concepts in this that I was unable to in other places
Great video Jordan. Thanks so much for creating it. It definitely gave me some motivation to learn more about Google Scripts.
Good, clear description. I have been searching for something like this for some time now, thx!
Very useful for an absolute beginner, thank you for your work!
Sounds like you should be on an episode of Mad Men typing up a memo while sipping on your glass of Scotch....lol... that keyboard is so loud... love the video!
Fantastic Video's Jordan. I caught on to several key concepts that you didn't really talk about but I recognised what was happening immediately. Very helpful and really good showing some of the other resources to access in the Where to from here section.
Thanks Nigel! There are definitely concepts that I don't cover in depth. Glad you figured it out and enjoyed the other resources!
i guess I am kind of randomly asking but does anyone know of a good site to stream new movies online ?
@Nixon Elian i would suggest Flixzone. Just google for it :)
@Jaylen Shiloh yea, been using FlixZone for months myself =)
@Jaylen Shiloh thank you, I went there and it seems to work =) I really appreciate it!
Thank you for this tutorial. You certainly ahve given me a very quick over view of where I need to start with the project I am working on. Thank you again!
+CerebralAudio thanks for watching!
Great video! I'm a little confused about the indexing for the array of the function argument. In my testing it seems like the indexing changes depending on how many cells you select. If you select more than one row and column, it seems to be [row][column][character] but if you only select one cell, that no longer seems to be true. I need to know what the contents of the array will be when I pass different cells into the function. Thanks!
Thank you so much for this video!! It was easy to understand, not at all repetitive, and gave me a good start!
Thanks Jacob!
thx for the video, still idk if anyone noticed but variable randomKey goes from 1 to 8 which it shouldnt, the normal range for words array should've been from 0 to 7. Just a minor note
Very good examples. Thanks!
Fantastic video. Very helpful. Thank you!
Nice Job, Jordan! Question: can you make the final code example available in text form? That would make it a very nice sample example to start from for beginners? Just a suggestion.
Excellent cours quoique un peu rapide, merci beaucoup...
great video, well videos (only found your channel the other day), very helpful.
would like to see you do some more on add ons and turning scripts / sheets into web apps.. or just more on app scripts 😬 again great stuff that I've watched so far, learnt quite abit
Thanks +Mike! Can you be more specific about what you would like to see? I would love to do more videos about deploying scripts as web apps, and the more useful I can make them the better!
Clear as mud! Certainly not for beginners.
Loved the side bar example, and freecodecamp referral. Can you do more on sidebar using say check boxes to show hide columns/rows in the sheet? similar to VSTO in docx
it is helpful for me. Thank you...
Nice Video
great job - prob could use more clarification on how the contents of the "names" array are populated... took me a minute to figure out it was being populated by the spreadsheet itself. Cool stuff!
Just a small advice to you; You need to plan the presentation of facts and contents in a orderly manner than being so so.... and that will help you to retain the view and stay on with interest. Focus on a specific area with meaningful objectives. Hope this will not hurt your feelings.
Perfect. I want a button in google site that run a script function on click it. How is it possible? Please help.
create a button in spreadsheet: go to insert menu, choose image, and insert fuction name in that image.
Btw I am a new learner on google sheets and apps script, I try to documenting my simple learning result in this channel
ruclips.net/channel/UCuCFRM4818jYd2WdqX4QXDQ
Very good intro to scripting with google sheets. (Maybe less doubts where better !)
If you want the functions appears when you write it down in spreadsheet, the thing to do is before the function definition:
/**
Your comment
@customfunction
*/
This should do the trick ;)
Hello Jordan. I have found your video tutorials excellent and well explained. Could you do one of how to pass data from Add on to the document or spreadsheet ?. I have searched but I have not found any. I would really appreciate it and thank you for what you do.
excelente mi amigo
Thanks, +Juan Pablo!
Hi , i like your video !! i have a question How to deploy the script [make the information captured from google sheet Go Directly to google Doc automated ] Thank You very much for your help
Hi. I have an array of dates. I wish to find the difference of days from a particular date with the dates in the array and store it in another array. Please tell me how to do?
randomKey function shouldn't have +1 at the end because it starts from 0
I believe that is correct. Putting the 1 in guarantees that pencil will never be in the password.
Hi Jordan, first of all, thank you very much for give us a bit of your knowledge. I am having an error on my trying: When I try this> function emails(names) {
return names [0][0][0] + names[0][0][1];
}
and call the function on my sheets My result is this: Fernanda Breston Fundefined
This is great! Or you have a paper notes by your side while u lecture. This may be more smoothly presented and the readers have more confident on u. Go ahead n have more. 😀😄🌿🌹🍃😊
Thanks so much. I definitely had an outline of what I wanted. The difficult thing for me is talking to a computer screen and not a classroom. If you want do a deeper dive into Javascript, the resources at freecodecamp.com are incredible.
Great content. Thanks!
Thank you! I was just trying to give a broad look at what is possible with Google scripts.
Is there any way to have it so that when a person logs on to a google doc, that they make a suggestion, and then right after have it delete that suggestion, just so that I can see if they logged into the doc, even if they don't type anything.
I have a sheet with a list of names and when I follow your steps it doesn't pull from my sheet:
function EMAILWRITER (names) {
return names [0][1]
}
WHY?
Very clear. Thank you.
thanks. zoom is little smal. typing at the top a small peace of the monitor
Maybe it has been long enough that I should make a new version...
management websites with Blogger API , or maybe Google Apps Script to parse text from google drive docs issues .
Thanks, it’s very useful
When i type "getra" for example, it didn't appears all the functions i can use, as "GetRange...". How to activate these function that i think it's called by autocomplete?
hii sir i have a one query in Gmail in compose mail addon. Click the compose mail addon to redirect another page. How do i can these opration to click addon to redirect anther page.......????
Pls also guide me to write vlookup in appScript, dynamically....
I am a beginner started just from 2nd May' 22
What was the thing about Publish..on 29:30 ?
I don't know where to get the link of test grade book.
How can I split date and time using scripts?
Thank you
I like, maybe i can use features later on
Thanks Jordan! Much Appreciated, really looking forward to learn JavaScript for the only purpose of using Google Apps Script. Any other Resources you would recommend besides freecodecamp.com? Did you start from scratch at freecodecamp?
I had a little bit of experience with Python and PHP, but FCC was where I really sat down and focused on one language. Bookmark stackoverflow.com and feel free to reach out to me for anything you can't figure out on Google. Cheers!
Thanks! Will focus in FCC and thanks for offering to help out! I remember spending a few weeks some months back, managed to do the little project I had with the help of stackoverflow but I struggled to really understand the structure of the documentation @ developers.google.com.- Surprisingly there are plenty of JavaScript online courses but nothing really for Google Apps Script except a few videos here and there, nothing too formal. Thanks again!
@@JordanRhea is there anyway I can export my localhost MySQL data to Google sheets? I want to create a customized certificate from Google sheet
14:39 - I'm getting:
Jim, Joes undefined
Bill, Nothing undefined.
Here's my code:
function EMAILWRITER(names) {
return names[0,0] + ' ' + names[0,1];
}
By the way, I don't get what names[0,0] is or how it works.
I've understood the arrays concept you mentioned where you can put multiple items in an array or an "Array of items" in a variable and the part where you mention var ExampleString[1] = First character of string
But how exactly does names[0,0] work? What does it do? I don't get it. I want to get it. Please tell me! :D
The only problem with your code is that you need to access the array like:
return names[0][0] + ' ' + names[0][1]
Since the names variable comes in as a multidimensional array, you need to access first the 0 index and then the 0 and 1 index to get the names. There are much more detailed explanations of multidimensional arrays on youtube. Here is one that uses a similar example: ruclips.net/video/Cta5s1QBD8E/видео.html
im getting a ReferenceError: "logger" is not defined. (line 4, file "Code")Dismiss
...what am i doing wrong ?
how can we use app script to extend gmail?
+Mohit Maharjan there are a number of ways, what are you trying to do?
+Mohit Maharjan Let me know what kinds of things you want gmail to do!
Your the best but tell me how i can send my add-on to someone else if he wanted to use it.
Thanks so much for the compliment. I would publish your add-on as 'unlisted' on the webstore and then share the link with whoever you wanted to use it. If you publish publicly there a bunch of webstore requirements that you need to meet that can prove challenging. Good luck!
Jordan Rhea Thanks for replying can you make a tutorial on this please. That how i can share my add-on or script with people so they can use it.
Who’s watching this at 2x the speed?
+Markus Moore hopefully everyone!
You mean "StackOverflowingWithAholes..."
Can't understand. Can't understand any of the example . Why?
Isn't there a link to a much easier how to; video for starters ?
Paul Owens this is kind of as easy as you get? Maybe you learn a different way? Try messing around with code at your own pace and see how you learn
@@navjotsingh2251 so is this the most basic ? 😱
Paul Owens maybe not "most basic" but its still basic and good for beginners
Is this parody?
GO easy on the non-words like 'uh--', 'ah-', 'um-' as it is difficult to continue listening to videos where this is so excessive, unless you really want to finish it. I trained people for many years in ICT and peoplewould prefer pauses than non-words.
Great tip and definitely something I want to work on. Unfortunately, I doubt I'll ever be great at it. I will keep trying though!