eojji

// https://m.cafe.naver.com/eojji/303
function sheetAppendFiles_(parentId, data, sheetFolder, sheetFiles) {
  if (!data || data.length < 1) {
    return;
  }
  
  var folderData = [];
  var newDate = new Date();
  // title, id
  // id2, files, fileSize, start, end, file row, parent																	

eojji

// https://m.cafe.naver.com/eojji/302
// unit: msec
function timeCheck(startTime, needTime) {
  var nowDate = new Date();
  //  remain = 6 min - ( now - start )
  var remain = 360000 - (nowDate.getTime() - startTime);
  if (remain < needTime) {
    return false;
  } else {
    return true;

eojji

// Can I open shared file in a group?
function isOpenSharedFileByProp_() {
  // https://developers.google.com/apps-script/reference/properties/properties-service#getScriptProperties()
  var ss, ssIdsharedGfolderCopy;
  ssIdsharedGfolderCopy = PropertiesService.getScriptProperties().getProperty('ssIdsharedGfolderCopy');
  // Logger.log(ssIdsharedGfolderCopy);
  try {
    ss = SpreadsheetApp.openById(ssIdsharedGfolderCopy);
    return ss ? true: false;
  } catch(e) {

eojji

function myFunction() {
  var url = 'https://docs.google.com/spreadsheets/d/...';
  try {
    // https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet-app#openByUrl(String)
    var ss = SpreadsheetApp.openByUrl(url);
    var sheet = ss.getSheets()[0];
    var numRows = sheet.getLastRow();
    var range = sheet.getRange(1, 2, numRows, 1);
    var values = range.getValues();        
    var now = new Date();

eojji

function processTeamForm(formObject) {    
  var name = formObject.name;
  var title = formObject.title;
  var comment  = formObject.comment;
  var emailRecipient = PropertiesService.getScriptProperties().getProperty('email');  
  var url = ScriptApp.getService().getUrl();  
  var msgBody = 'This email was sent via the gFolderCopy App.\n\n' 
  + 'App: \n' + url + '\n\nComment: \n'+ comment
  +'\n\nName: '+ name+' Email: '+ Session.getActiveUser().getEmail();   
  MailApp.sendEmail(emailRecipient, title, msgBody);