Hello, I have had this function working on my google sheets for a number of years. I recently started using google sheets again and this code no longer works.
Here is my problem, I have a shared folder which houses a google sheets document that is a template for other users to copy.
Once the user copies this code would automatically set me as the owner. Unfortunately this no longer works and I am looking for another way.
Here are two examples of this code that should/would work.
function setOwner() {
// The Code Below Will Set Document Ownership
var ss = SpreadsheetApp.getActiveSpreadsheet();
var s = SpreadsheetApp.getActiveSheet();
var files = DriveApp.getFilesByName(ss.getName());
while (files.hasNext()) {
var file = files.next();
}
var smain = SpreadsheetApp.setActiveSheet(ss.getSheetByName('Sheet1'));
smain.showSheet();
s.hideSheet();
}
function transfer() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var s = SpreadsheetApp.getActiveSheet();
var user = Session.getActiveUser().getEmail(); // Modified
var folder = DriveApp.getFolderById('Folder ID');
var files = folder.getFilesByName(ss.getName());
while (files.hasNext()) {
var file = files.next();
if (file.getOwner().getEmail() == user) file.setOwner('
123...@gmail.com'); // Modified
}
}