LinkedIn
Twitter
@Koichi_Tsuji
"We know to add multiple location per FOLDER levels with Google Drive functionalities, with SHIFT + Z command. However, we are not sure how to add multiple locations per spreadsheet file level. In terms of "multiple locations" for the spreadsheet, what does it exactly mean? while we are not able to add multiple locaoitons per spreadsheet file level? "
^couldn't figure out how to quote only part of a message on this new forum 😞
I agree, this announcement is confusing. I think the control-z command only works on folders.
I wrote an Apps Script to scan your drive for FOLDERs that are stored in multiple locations. It will return the folder names and Id's for all parents of any folder with more than one parent.
function findMultiFolders(){
let searchFolders = DriveApp.searchFolders("'EMAIL_ADDRESS' in owners");
let folderList = [];
while(searchFolders.hasNext()) {
childId = searchFolders.next().getId();
let thisFolderTest = hasMultipleLocations(childId);
if(thisFolderTest){
folderList.push(thisFolderTest)
}
}
return folderList
}
function hasMultipleLocations(folderId) {
locations = DriveApp.getFolderById(folderId).getParents();
let count = 0;
let multiFolders = [];
while (locations.hasNext()) {
let folder = locations.next();
count++;
let log = `${count}: ${folder.getName()} (${folder.getId()})`;
multiFolders.push(log);
if(count > 1){
Logger.log(multiFolders)
};
}
return count > 1 ? multiFolders : false
}
WARNING: This will probably time out on free accounts, and maybe even on paid workspace accounts with enough folders.
You can mess around with the query parameters to break the search into smaller chunks.
https://developers.google.com/drive/api/v2/ref-search-terms?hl=en
