function RenameResponses() { var form = FormApp.openById('1lF9l1zlaWXzIP_mH_NjLDYGKHv3JRkdZnRdCi32OI9o'); //Copy_and_paste_your_FormId_here var formResponses = form.getResponses(); var baseString = 'drive.google.com/file/d/'; var endString = '/view?usp=drivesdk'; var folder = DriveApp.getFolderById('0B430GTfdIcKmfjJtY29pZGlMWlV5NVZPTXZfRGlYaEpfQmlxNXdRaEtKeEV0YlB5NHNKWUE'); //Copy_and_paste_your_DriveId_here var files = folder.getFiles(); while (files.hasNext()) { var file = files.next(); for (var i = 0; i < formResponses.length; i++) { var formResponse = formResponses[i]; var itemResponses = formResponse.getItemResponses(); var itemResponseFirst = itemResponses[2]; var itemResponseSecond = itemResponses[3]; var itemResponseThird = itemResponses[1]; var itemResponsePhoto = itemResponses[8]; var photoID = itemResponsePhoto.getResponse(); var newName = itemResponseFirst.getResponse() + " " + itemResponseSecond.getResponse() + " - " + itemResponseThird.getResponse(); var url = baseString + photoID + endString; var urlCheck = file.getUrl(); if ( url == urlCheck) { var modName = newName + ".jpg"; file.setName(modName); } } }
@KelseyWaltersS3 жыл бұрын
This is a great tool and exactly what I was looking for , however I continue to get an error on line 19 "code.gs" :(
@rajeshveeramallu21863 жыл бұрын
@@KelseyWaltersS same problem madam
@tjhris2 жыл бұрын
delete all space before first letter on row 19 until end
@agungalrizkyandreawan32122 жыл бұрын
Can Halp me error on line 19
@jorgegomezbedoya27852 жыл бұрын
Thank you very much!!! I really appreciate it!
@hfrogie95562 жыл бұрын
If we have more than one file(multiple files) to rename.? Can i know the code?
@kurry742 жыл бұрын
Sir, thanx for such great tool, that I was looking for, but can you explain it in English or Hindi.
@rajeshveeramallu21863 жыл бұрын
👌👌👌 sir
@rajeshveeramallu21863 жыл бұрын
Can u provide contact details sir
@sshallu62323 жыл бұрын
Sir ennakku oru santhegam.....? 1st Ethu responses vathuthukku appuram thaan panna mudiumaa..? Neega XL sheet la pannathu Google forms script la panna mudiymaa sir And ennakku students name mattum athavathu 1st response mattum image la rename aagannum... Aana Naa rendu image vaaguna remdum rename aaga enna Pannannum.. Plz sir ennakku solluga romba useful aa irukkum... Thank you 😊
@theprofessor98713 жыл бұрын
1. Responses vanthathuku apparam than Namma itha panna mudiyum 2. Form la intha mathiri script ah run Panna mudiyathu .... Google sheets la than panna mudiyum 3. Two photos upload panni erunthangana two photos um rename aagidum ... Hope this will be useful for u 🙂🙂🙂.... Take care
@sshallu62323 жыл бұрын
Thak you sir
@sshallu62323 жыл бұрын
Appuram rendu photosum drive la oru folderkku Ulla split panni Tamil and English folder la irukkum appo rename aagumaa na etha mention panna maearutten sir ....
@sshallu62323 жыл бұрын
Finally one question sir Google sheets la redipannum pothu intha script aa set panna athukku appuram vara response rename aagumaa sir.... Appuram drive la folder ulla split panna vera Vera folreds kku rename aaguma... Plz konjam solluga sir.... Vera ethavathu santhegaththukku video ketta upload pannuvanga la..?
@theprofessor98713 жыл бұрын
@@sshallu6232 two folders eruntha folder path ah change panni neenga code ah two times run pannanum
@TheSimojamal Жыл бұрын
Thanks boss
@torukmakto02 жыл бұрын
Thank you, its working but, multiple file upload, its not working. Can we fix that problem on code?
@John-ee9tj2 жыл бұрын
I have only one small problem..the loop...everytime i run the function it keeps on starting from the first one..how do i set a if loop to skip the file if it has been renamed? thanks
@akashmishra50812 жыл бұрын
were u able to eliminate the syntax error that came with newName code of line. can u pls help
@John-ee9tj2 жыл бұрын
@@akashmishra5081 No idea what you meant here...lol...the code works perfectly well...except the loop...
@ktthecomputerclasses74563 жыл бұрын
Hi sir Is it possible multiple documents rename without find text
@minesdept73402 жыл бұрын
Line number 19 me error batata hai plz resolve it
@ktthecomputerclasses74563 жыл бұрын
Hi sir , Is it possible create a separate folder. For everyone person after submit from.
@davoodjani45582 жыл бұрын
u can do it with form with form director
@putraf62632 жыл бұрын
How to change new rename on script?
@raajdhaniengineeringcolleg91032 жыл бұрын
line 19 var photoID = itemResponsePhoto.getResponse(); error
@davoodjani45582 жыл бұрын
same, for me too, can u plz let us know the reason plz
@shukriabduljalil37122 жыл бұрын
function renamefile() { var form = FormApp.openById('code here'); //DDD var formResponses = form.getResponses(); var baseString = 'drive.google.com/file/d/'; var endString = '/view?usp=drivesdk'; var folder = DriveApp.getFolderById('code here'); var files = folder.getFiles(); while (files.hasNext()) { var file = files.next(); for (var i = 0; i < formResponses.length; i++) { var formResponse = formResponses[i]; var itemResponses = formResponse.getItemResponses(); var itemResponseFname = itemResponses[0]; var itemResponseLname = itemResponses[2]; var itemResponsePhoto = itemResponses[14]; var photoID = itemResponsePhoto.getResponse(); var newName = itemResponseFname.getResponse() + " - " + itemResponseLname.getResponse() ; var url = baseString + photoID + endString; var urlCheck = file.getUrl(); if ( url == urlCheck) { var modName = newName + " - " + ".jpg" ; file.setName(modName); } } } }
@amaltjoseph93332 жыл бұрын
Hi I m getting error after runninng this code which shows as "TypeError: Cannot read property 'getResponse' of undefined renamefile" pls help me with this.