Created
December 14, 2018 14:07
-
-
Save phillypb/0a2b21e07877641b244ac5e10bc6267f to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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