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.
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!
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!
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.
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.
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!
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
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.
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!
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
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.
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.
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 ;)
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.
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 ua-cam.com/channels/uCFRM4818jYd2WdqX4QXDQ.html
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?
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 , 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 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
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: ua-cam.com/video/Cta5s1QBD8E/v-deo.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 ua-cam.com/video/Z5n-q2W_5QM/v-deo.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
It's about time I learn how to code, thanks so much!
I caught onto many concepts in this that I was unable to in other places
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
1:39 variables
5:17 strings
8:37 numbers
10:51 functions
24:29 conclusion
I have been JavaScript in my spare time. I did not know what it would come handy writing scripts in Google. Thanks !
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.
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.
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!
Very useful for an absolute beginner, thank you for your work!
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!
Great intro to JavaScript and Google App Script - very helpful.
Thanks a ton +MJ Aldred! Your compliments are motivating
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!
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.
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!
Fantastic video. Very helpful. Thank you!
Very good examples. 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!
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!
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
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.
Very clear. Thank you.
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
Nice Video
it is helpful for me. Thank you...
Clear as mud! Certainly not for beginners.
Great content. Thanks!
Thank you! I was just trying to give a broad look at what is possible with Google scripts.
Thanks, it’s very useful
excelente mi amigo
Thanks, +Juan Pablo!
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
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.
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.
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 ;)
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.
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...
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
ua-cam.com/channels/uCFRM4818jYd2WdqX4QXDQ.html
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.
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?
I like, maybe i can use features later on
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?
management websites with Blogger API , or maybe Google Apps Script to parse text from google drive docs issues .
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 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
I am a beginner started just from 2nd May' 22
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?
How can I split date and time using scripts?
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.......????
im getting a ReferenceError: "logger" is not defined. (line 4, file "Code")Dismiss
...what am i doing wrong ?
What was the thing about Publish..on 29:30 ?
I don't know where to get the link of test grade book.
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
Pls also guide me to write vlookup in appScript, dynamically....
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: ua-cam.com/video/Cta5s1QBD8E/v-deo.html
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.
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
Who’s watching this at 2x the speed?
+Markus Moore hopefully everyone!
You mean "StackOverflowingWithAholes..."
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!