Skip to content

Instantly share code, notes, and snippets.

@eojji
Created August 29, 2018 08:01
Show Gist options
  • Save eojji/99fb51d5a6f02c1671133cc44b17f8ce to your computer and use it in GitHub Desktop.
Save eojji/99fb51d5a6f02c1671133cc44b17f8ce to your computer and use it in GitHub Desktop.
Spreadsheet files were shared to G folder copy group members. https://cafe.naver.com/eojji/176
function isOpenSharedFileByProp_() {
var domain = Session.getEffectiveUser().getEmail().split('@')[1];
var myDomain = ['gfolder.net', 'eojji.net', 'eojji.kr', 'eojji.com'];
if (myDomain.indexOf(domain) > -1) {
console.log('True My Domain: %s', domain);
return true;
} else {
console.log('False My Domain: %s', domain);
}
var ss, ssIdsharedGfolderCopy;
ssIdsharedGfolderCopy = PropertiesService.getScriptProperties().getProperty('ssIdsharedGfolderCopy');
try {
ss = SpreadsheetApp.openById(ssIdsharedGfolderCopy);
if (ss && ss.getId() == ssIdsharedGfolderCopy) {
return true;
} else {
return false;
}
} catch(e) {
console.error('Catch: %s, %s, SpreadsheetApp.openById: %s', e.name, e.message, ssIdsharedGfolderCopy);
return false;
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment