SUPPORT ME ON PATREON: https://patreon.com/jordanrhea
Ever wonder what that script editor on the toolbar was all about? Here I am trying to explain very basic usage of the script editor for teachers.
RESOURCES:
www.FreeCodeCamp.com to learn more about the web technologies that you can use to develop more complex web tools/apps
www.plnnr.net to find out how to have your project idea developed
www.jordanrhea.com to read more about the projects I am working on in my free time and my classroom
@rheajt to send me a tweet!
Hi Jordon can U help me setting time stamp that will stop when a cell is mark with a letter in a tab and it will stop or show a video how to set them. TQ.
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!
I like, maybe i can use features later on
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!
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 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 wrond, and I cannot see the mistake. Could you help me with this? Once again, thank you very much!
im getting a ReferenceError: "logger" is not defined. (line 4, file "Code")Dismiss
…what am i doing wrong ?
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 ?
What was the thing about Publish..on 29:30 ?
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
randomKey function shouldn't have +1 at the end because it starts from 0
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.
It's <key, value> not <key, pair>…
management websites with Blogger API , or maybe Google Apps Script to parse text from google drive docs issues .
Thank you so much for this video!! It was easy to understand, not at all repetitive, and gave me a good start!
Very good examples. Thanks!
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 😉
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!
At 1.5 speed this is perfect. Thank you so much.
Who’s watching this at 2x the speed?