phillypb

function getActiveCell() {
  
  // get the active spreadsheet and sheet
  var ss = SpreadsheetApp.getActiveSpreadsheet(); // ss contains entire spreadsheet
  var sheet = ss.getActiveSheet(); // sheet contains current active sheet ('Students')
  
  // from sheet, get active cell and store as variable
  var activeCell = sheet.getActiveCell();
  
  // from activeCell, get value and store as variable

phillypb

function specificDataRookie() {
 
  // get active spreadsheet
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  
  // get active sheet
  var sheet = ss.getActiveSheet();
  
  // get active cell
  var activeCell = sheet.getActiveCell();

phillypb

function specificDataImproved() {
 
  // get active spreadsheet
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  
  // get active sheet
  var sheet = ss.getActiveSheet();
  
  // get active cell
  var activeCell = sheet.getActiveCell();

phillypb

function archiveData() {
 
  // get active spreadsheet
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  
  // get source sheet by name
  var sourceSheet = ss.getSheetByName('Students');
  
  // get destination sheet by name
  var destSheet = ss.getSheetByName('archive');

phillypb

function getColByName(name) {
  
  // get column headers as an array to search through
  var headers = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Students').getDataRange().getValues().shift();
  
  // search array looking for specific text to return its position
  var colindex = headers.indexOf(name);
  
  return colindex+1;
  

phillypb

function getAssigneeDetails() {
  
  // get 'Plan' sheet
  var planSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Plan');
  // get 'Plan' sheet data range
  var planDataRange = planSheet.getDataRange();
  // get 'Plan' sheet data values
  var planData = planDataRange.getValues();
  // get number of last row of data in 'Plan' sheet
  var planLastRow = planSheet.getLastRow();

phillypb

function getStartDate() {
  
  // get 'Plan' sheet
  var planSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Plan');
  // get 'Plan' sheet data range
  var planDataRange = planSheet.getDataRange();
  // get 'Plan' sheet data values
  var planData = planDataRange.getValues();
  // get number of last row of data in 'Plan' sheet
  var planLastRow = planSheet.getLastRow();

phillypb

function lookupEmailAddress() {
  
  // get 'Plan' sheet
  var planSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Plan');
  // get 'Plan' sheet data range
  var planDataRange = planSheet.getDataRange();
  // get 'Plan' sheet data values
  var planData = planDataRange.getValues();
  // get number of last row of data in 'Plan' sheet
  var planLastRow = planSheet.getLastRow();

phillypb

function createEventFromSheet() {
  
  // get 'Plan' sheet
  var planSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Plan');
  // get 'Plan' sheet data range
  var planDataRange = planSheet.getDataRange();
  // get 'Plan' sheet data values
  var planData = planDataRange.getValues();
  // get number of last row of data in 'Plan' sheet
  var planLastRow = planSheet.getLastRow();

phillypb

function onFormSubmit(e) {
  
  // get spreadsheet info
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var dataSheet = ss.getSheetByName('Form responses 4');
  
  // get Form data
  var formValues = e.namedValues; // allows row Headers to be specified when looking-up values
  var theRow = e.range.getRow(); // this is the row the Form data is written to
  var name = formValues['Name'];