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

$10-30 AUD

Lukket

Slået op cirka 4 år siden

$10-30 AUD

Betales ved levering

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) }

JavaScript

Google Sheets

Projekt-ID: 31989188

Om projektet

5 forslag

Projekt på afstand

Aktiv 4 år siden

Leder du efter muligheder for at tjene penge?

E-mailadresse

Fordele ved budafgivning på Freelancer

Fastsæt dit budget og din tidsramme

Bliv betalt for dit arbejde

Oprids dit forslag

Det er gratis at skrive sig op og byde på jobs

5 freelancere byder i gennemsnit $38 AUD på dette job

@rexzetsolutions

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

$100 AUD på 2 dage

4,6

(40 anmeldelser)

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

5,0

(10 anmeldelser)

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 require me to work outside my comfort and knowledge set, as continuing to learn new languages and development techniques are important to me and the success of your organization. If you are looking outsources please let me know I will always ready to work with you. My skill set are PHP, Wordpress, JavaScript, Python, Django, Laravel, Codeigniter and many more . I have a small team of developers and designers .

$25 AUD på 1 dag

5,0

(7 anmeldelser)

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 Responsive Website design and development, Customizable software development, Custom cross-platform mobile applications Thank you Punm sharma

$22 AUD på 7 dage

5,0

(4 anmeldelser)

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 about the project in chat. I would like to inform you that I will be providing the best quality work for the project with the help of my experience in the designing field. I have 6 + years experience in designing and development and I have successfully completed 500 + projects for the clients and satisfied them with the end result. Kindly drop me a message so we can share the details of the project and start it ASAP. Looking forward to work with you. Best Regards, Jitendra Singh

$30 AUD på 4 dage