Skip to content

Instantly share code, notes, and snippets.

@phillypb
Created December 14, 2018 14:07
Show Gist options
  • Save phillypb/0a2b21e07877641b244ac5e10bc6267f to your computer and use it in GitHub Desktop.
Save phillypb/0a2b21e07877641b244ac5e10bc6267f to your computer and use it in GitHub Desktop.
function specificDataRookie() {
// get active spreadsheet
var ss = SpreadsheetApp.getActiveSpreadsheet();
// get active sheet
var sheet = ss.getActiveSheet();
// get active cell
var activeCell = sheet.getActiveCell();
// find current row for active cell
var currentRow = activeCell.getRow();
// GET 'Students' DATA ...
// get current row data, getRange(startRow, startColumn, numRows, numColumns)
var dataName = sheet.getRange(currentRow, 3, 1, 1).getValue();
Logger.log(dataName);
// get current row of data, getRange(startRow, startColumn, numRows, numColumns)
var dataPostcode = sheet.getRange(currentRow, 4, 1, 1).getValue();
Logger.log(dataPostcode);
// get current row of data, getRange(startRow, startColumn, numRows, numColumns)
var dataGender = sheet.getRange(currentRow, 5, 1, 1).getValue();
Logger.log(dataGender);
// get current row of data, getRange(startRow, startColumn, numRows, numColumns)
var dataShoe = sheet.getRange(currentRow, 7, 1, 1).getValue();
Logger.log(dataShoe);
// SET 'justOne' VALUES ...
// set justOne sheet value from collected dataName
SpreadsheetApp.getActiveSpreadsheet().getSheetByName('justOne').getRange('B3').setValue(dataName);
// set justOne sheet value from collected dataEmail
SpreadsheetApp.getActiveSpreadsheet().getSheetByName('justOne').getRange('B4').setValue(dataPostcode);
// set justOne sheet value from collected dataDOB
SpreadsheetApp.getActiveSpreadsheet().getSheetByName('justOne').getRange('B5').setValue(dataGender);
// set justOne sheet value from collected dataCollege
SpreadsheetApp.getActiveSpreadsheet().getSheetByName('justOne').getRange('B6').setValue(dataShoe);
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment