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

Se mere: oscommerce error access denied user, commerce access denied user error, wss fba error access denied, access denied error web parsing javascript, error connect microsoft sql server dbnetlib connection opensql server exist access denied , error access denied user, script error access 2010, connect phonebook entry error access denied, vpn connect phonebook entry error access denied, windows vpn connect phonebook entry error access denied, master password update error: access denied, unity script template access denied, server error access denied roundcube cpanel, webmail server error access denied, database creation error: access denied odoo 12, mysql2::error: access denied for user 'root'@'localhost' (using password: yes)

Om arbejdsgiveren:
( 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