NEIT+2017+-+Open+Space+3H

NEIT 2017 - Open Space 3H =Hack Your LMS= Sean Dagony-Clark, Riverdale Country School Morgan Dunn, Riverdale Country School

combining CSVs via a script

Interesting Google Sheet and Form Add-ons used data flow:
 * [|Form Values] - Store in a Google Sheet and use selections for multiple choice, list and checkbox questions. No need to manually type them in!
 * [|copyDown] - copyDown adds functionality to Form-fed Google Sheets -- the ability to have row 2 formulas auto-copied into form submission rows
 * [|AutoCrat] - Document merge tool that creates PDF or shared Documents from spreadsheet data. aka Mail Merge for Google Drive.

Custom script that copies a range of data from one tab to another tabs: 

Using Script Editor in spreadsheet. Time-driven trigger every minute. NEIT 2017 - Open Space 3H =Hack Your LMS= Sean Dagony-Clark, Riverdale Country School Morgan Dunn, Riverdale Country School

Interesting Google Sheet and Form Add-ons used data flow:
 * [|Form Values] - Store in a Google Sheet and use selections for multiple choice, list and checkbox questions. No need to manually type them in!
 * [|copyDown] - copyDown adds functionality to Form-fed Google Sheets -- the ability to have row 2 formulas auto-copied into form submission rows
 * [|AutoCrat] - Document merge tool that creates PDF or shared Documents from spreadsheet data. aka Mail Merge for Google Drive.

Here's the link to our sheet. Make a copy before doing anything so you don't mess up something that someone else might use! @https://docs.google.com/spreadsheets/d/1fADkiNUk6iUrqBjtjspcEsmh8RCVdkvXpDApUI8GPPc/copy

Custom script that copies a range of data from one tab to another tabs: function Copy { var sss = SpreadsheetApp.openById('1ZHokJQtPTb2mZXp-U4Qcea5kLAELkyR2mA7uG-hth9I'); //replace with source ID// //var ss = sss.getSheetByName('Form Responses 1');// replace with source Sheet tab name var range = ss.getRange('E3:I1000'); //assign the range you want to copy//

//var data = range.getValues;// //var tss = SpreadsheetApp.openById('1ZHokJQtPTb2mZXp-U4Qcea5kLAELkyR2mA7uG-hth9I');// replace with destination ID var ts = tss.getSheetByName('export to CSV'); //replace with destination Sheet tab name// //ts.getRange(1, 1, data.length, data[0].length).setValues(data);// you will need to define the size of the copied data see getRange }

Using Script Editor in spreadsheet. Time-driven trigger every minute.

Jonathan King has something that exports the first tab of a Google Sheet to CSV. Ask him if you need a hint or just Google for answers.

Once you get the data out, here's instructions on __combining CSVs via a script__

Hope this makes your life better!