Find Jobs
Hire Freelancers

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

$10-30 AUD

Lukket
Slået op over 2 å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) }
Projekt-ID: 31989188

Om projektet

5 forslag
Projekt på afstand
Aktiv 2 år siden

Leder du efter muligheder for at tjene penge?

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
Brug Avatar.
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
5,9
Brug Avatar.
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
3,9
Brug Avatar.
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
3,6
Brug Avatar.
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
3,3
Brug Avatar.
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
0,0 (0 anmeldelser)
0,0
0,0

Om klienten

Flag for AUSTRALIA
Southport, Australia
4,7
5
Betalingsmetode verificeret
Medlem siden sep. 7, 2018

Klientverificering

Tak! Vi har sendt dig en e-mail med et link, så du kan modtage din kredit.
Noget gik galt, da vi forsøgte at sende din mail. Prøv venligst igen.
Registrerede brugere Oprettede jobs i alt
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Indlæser forhåndsvisning
Geolokalisering er tilladt.
Din session er udløbet, og du er blevet logget ud. Log venligst ind igen.