andrewroberts / bblog Goto Github PK

// snippet
/********************************************************************************
 * Private Methods
 *****************/

/**
 * Allows logging to a Google spreadsheet. Sets the log sheet, creating 
 * one if it doesn't exist
 *
 * @param {string} key The spreadsheet key [OPTIONAL, DEFAULT: active spreadsheet]
 * @param {string} sheetName The name of the sheet 
 * @param {boolean} hideLog
 */
 
BBLog_.prototype._useSpreadsheet = function(key, sheetName, hideLog) {

  var spreadsheet;

  if (typeof key !== 'undefined' && key !== '') {  
    spreadsheet = SpreadsheetApp.openById(key);  // 👈 this line over here
  } else {
    spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  }
// snippet

  var log = BBLog.getLog({
    level: BBLog.Level.ALL,  
    sheetName: 'Log',
    displayUserId: BBLog.DisplayUserId.EMAIL_FULL,
    sheetId: '15oZPWqurBBJYHaTLxNkmKCcDf8se9vyXXXXXXXXXX',
    lock: LockService.getScriptLock()
  });

function myFunction() {
  var lock = LockService.getScriptLock();
  var log = BBLog.getLog({
    level: BBLog.Level.ALL,  
    sheetName: 'Log',
    displayFunctionNames: BBLog.DisplayFunctionNames.YES,
    displayUserId: BBLog.DisplayUserId.EMAIL_FULL,
    lock: lock
  });
  log.info('Test log to GSheet at INFO level');
}

function myFunction() {
  var lock = LockService.getScriptLock();
  var log = getLog({
    level: Level.ALL,  
    sheetName: 'Log',
    displayFunctionNames: DisplayFunctionNames.YES,
    displayUserId: DisplayUserId.EMAIL_FULL,
    lock: lock
  });
  log.info('Test log to GSheet at INFO level');
}