Lukket

Debug a Google Sheet Script - error: Access denied: DriveApp

I have a script in a Google Sheet where I'm getting an exception error: Access denied: DriveApp.

There is an Archive function were projects in a Master List are updated. However, when I Archive Completed Projects I get an error: Access denied: DriveApp.

I need someone to debug the code and/or otherwise tell me how to fix the issue.

The particular piece of code is:

function archive(){

var spreadsheet = [login to view URL]();

var topSheet = [login to view URL]("Active Projects")

var archiveSheet = [login to view URL]("Completed Projects");

var archiveCurrRow = [login to view URL]()+1;

var topSheetRows = [login to view URL]();

//var sheetFolder = findFolder(targetFolderId,targetFolderName)

var archiveFolder = findFolder(archivedProjectsFolderId,archivedProjectsFolderName)

var values = [login to view URL](2,10,topSheetRows,1).getValues()

var j=2;

for(var i = 0 ; i < [login to view URL] ; i ++){

var value = values[i][0];

if (value == ""){break;}

var rowValueA = [login to view URL](j,1,1,11).getValues();

var rowValue = rowValueA[0]

if(rowValue[5] == "Completed"){

var projectId = getIdFromUrl([login to view URL]("regroupsolutions",""));

[login to view URL](projectId)

var projectFile = null;

try{

projectFile = [login to view URL](projectId);

}catch(e){}

//var projectFile = [login to view URL](projectId)

if(projectFile != null){

[login to view URL](projectFile)

//[login to view URL](projectFile)

var formulas = [login to view URL](j,1,1,9).getFormulasR1C1();

[login to view URL](archiveCurrRow,1,1,9).setFormulasR1C1(formulas);

[login to view URL](archiveCurrRow,10).setValue(rowValue[9])

[login to view URL](j,11).clearContent()

[login to view URL](j,10).clearContent()

archiveCurrRow = archiveCurrRow +1;

}

}

j += 1;

}

[login to view URL](5)

}

Evner: JavaScript, Google Sheets

Om klienten:
( 5 bedømmelser ) Southport, Australia

Projekt ID: #31989188

5 freelancere byder i gennemsnit $38 timen for dette job

rexzetsolutions

Yes I can Debug a Google Sheet Script , message me i am ready to start work from now.

$100 AUD in 2 dage
(40 bedømmelser)
5.9
IgeS

Hi there, Need to have the script google sheet-bound script debug? Please message me if this is any of what you need. I'll be standing by to help. -Ige

$15 AUD på 1 dag
(10 bedømmelser)
3.9
gtnt20905baroli

Hello Sir/Madam start immediately Hope you doing well I am software developer having 10+years experience in web development more then 100+ website I have made. I enjoy being challenged and engaging with projects that r Flere

$25 AUD på 1 dag
(7 bedømmelser)
3.6
punmsharma93

We Are Expertise In: » Theme Customization and Development » HTML, CSS & JQuery, Bootstrap, PHP, Codeignitor, WordPress, Android Mobile Application, Ios Applications, Angular, Ionic, React Native, etc. » Full Responsiv Flere

$22 AUD in 7 dage
(4 bedømmelser)
3.3
jitendrasingh16

Hello, Hope you are doing fine, Thankyou for the job invite, Its a pleasure to meet you and connect with you for your project [Debug a Google Sheet Script - error: Access denied: DriveApp]. Can you please tell me more Flere

$30 AUD in 4 dage
(0 bedømmelser)
0.0