YOU CAN CODE! This will significantly increase your productivity. Also the fist pumps are big! GET STARTED with coding Google Apps Script
YouTube
Canva Slides
Transcript
00:01:17.908,00:01:20.908
Alice Keeler: https://www.canva.com/design/DAFD9F0UcE8/qLcUPGtY9YW9IlrU5ucKQQ/view?utm_content=DAFD9F0UcE8&utm_campaign=designshare&utm_medium=link&utm_source=publishsharelink
00:14:25.275,00:14:28.275
Anna Hartranft: 😉
00:16:15.512,00:16:18.512
Alice Keeler: https://script.google.com/home
00:18:46.920,00:18:49.920
Anna Hartranft: I'm having so much fun!
00:25:23.925,00:25:26.925
Alice Keeler: STRING
00:28:43.249,00:28:46.249
Vicky Rankin: yes
00:29:20.265,00:29:23.265
Anna Hartranft: Almost
00:29:26.475,00:29:29.475
Anna Hartranft: I was tweeting lol
00:29:29.534,00:29:32.534
Tasha Froelich: yes
00:29:33.391,00:29:36.391
Alice Keeler: function create(){
var doc = DocumentApp.create('Alice coded this');
}//End of create function
00:29:56.604,00:29:59.604
Anna Hartranft: yes it worked!
00:30:07.356,00:30:10.356
Mary-Ann Lafosse: Yes, It worked! 🙂
00:33:58.962,00:34:01.962
Alice Keeler: function create(){
var doc = DocumentApp.create('Alice coded this');
}//End of create function
00:34:12.113,00:34:15.113
Anna Hartranft: the slides are beautiful
00:40:54.995,00:40:57.995
Alice Keeler: for(var i=0;i<10;i++)
00:41:03.060,00:41:06.060
Alice Keeler: http://keep.new
00:59:35.796,00:59:38.796
Alice Keeler: function onOpen(){
}//end menu
function roster(){
var doc = DocumentApp.getActiveDocument();
}//ends the roster function
01:02:26.413,01:02:29.413
Alice Keeler: *
01:02:26.999,01:02:29.999
Alice Keeler: *
01:02:27.557,01:02:30.557
Alice Keeler: *
01:02:28.278,01:02:31.278
Alice Keeler: *
01:02:29.213,01:02:32.213
Alice Keeler: function onOpen(){
DocumentApp.getUi()
.createMenu('Alice Menu')
.addItem('Put my roster here','roster')
.addToUi();
}//end menu
01:06:25.165,01:06:28.165
Alice Keeler: function roster(){
var doc = DocumentApp.getActiveDocument();
var body = doc.getBody();
}//ends the roster function
01:09:20.087,01:09:23.087
Anna Hartranft: What's at the top of the code?
01:15:21.427,01:15:24.427
Kathy Ramirez: I got my time messed up. Can I get the slides? ty
01:15:32.889,01:15:35.889
Alice Keeler: https://www.canva.com/design/DAFD9F0UcE8/qLcUPGtY9YW9IlrU5ucKQQ/view?utm_content=DAFD9F0UcE8&utm_campaign=designshare&utm_medium=link&utm_source=publishsharelink#29
01:20:19.903,01:20:22.903
Alice Keeler: in your keep note http:://keep.new
01:20:20.435,01:20:23.435
Alice Keeler: var data = sheet.getDataRange().getValues();
01:23:33.063,01:23:36.063
Alice Keeler: *
01:23:33.642,01:23:36.642
Alice Keeler: *
01:23:34.168,01:23:37.168
Alice Keeler: *
01:23:34.724,01:23:37.724
Alice Keeler: 8
01:23:36.545,01:23:39.545
Alice Keeler: function toADoc(){
const ss = SpreadsheetApp.getActiveSpreadsheet();
const sheets = ss.getSheets();
const sheet = sheets[0];//the FIRST sheet;
var data = sheet.getDataRange().getValues();
var len = data.length;//number of items in my array list
var doc = DocumentApp.create('My roster');
var body = doc.getBody();
for(var i=0; i<len; i++){
}//end loop
}
01:29:16.133,01:29:19.133
Alice Keeler: *
01:29:16.858,01:29:19.858
Alice Keeler: *
01:29:17.384,01:29:20.384
Alice Keeler: *
01:29:17.811,01:29:20.811
Alice Keeler: *
01:29:22.112,01:29:25.112
Alice Keeler: Put this in http://keep.new
01:29:24.401,01:29:27.401
Alice Keeler: *
01:29:24.915,01:29:27.915
Alice Keeler: *
01:29:25.421,01:29:28.421
Alice Keeler: *
01:29:25.885,01:29:28.885
Alice Keeler: *
01:29:27.324,01:29:30.324
Alice Keeler: function toADoc(){
const ss = SpreadsheetApp.getActiveSpreadsheet();
const sheets = ss.getSheets();
const sheet = sheets[0];//the FIRST sheet;
var data = sheet.getDataRange().getValues();
var len = data.length;//number of items in my array list
var doc = DocumentApp.create('My roster');
var body = doc.getBody();
for(var i=0; i<len; i++){
var name = data[i][0];
body.appendParagraph(name);
}//end loop
var url = doc.getUrl();
MailApp.sendEmail('ss34@fresnoteach.org','This is the roster','Th
01:29:36.636,01:29:39.636
Alice Keeler: MailApp.sendEmail('ss34@fresnoteach.org','This is the roster','This is the URL '+url);
}
01:30:12.845,01:30:15.845
Vicky Rankin: can we get a copy of this video presentation?
01:32:16.416,01:32:19.416
Alice Keeler: http://alicekeeler.com/codedbyalice
01:34:22.854,01:34:25.854
Alice Keeler: http://alicekeeler.com/pdfmyfolder
01:36:11.314,01:36:14.314
Mary-Ann Lafosse: Thank you so much Alice! I need to practice coding
01:38:08.424,01:38:11.424
Anna Hartranft: Thank you Alice!! This was a great tutorial