How to rename google form file responses (Photos) in Gdrive

  Рет қаралды 6,757

The Professor

The Professor

Күн бұрын

Script Given in Comment

Пікірлер: 32
@theprofessor9871
@theprofessor9871 3 жыл бұрын
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); ​} ​} ​}
@KelseyWaltersS
@KelseyWaltersS 3 жыл бұрын
This is a great tool and exactly what I was looking for , however I continue to get an error on line 19 "code.gs" :(
@rajeshveeramallu2186
@rajeshveeramallu2186 3 жыл бұрын
@@KelseyWaltersS same problem madam
@tjhris
@tjhris 2 жыл бұрын
delete all space before first letter on row 19 until end
@agungalrizkyandreawan3212
@agungalrizkyandreawan3212 2 жыл бұрын
Can Halp me error on line 19
@jorgegomezbedoya2785
@jorgegomezbedoya2785 2 жыл бұрын
Thank you very much!!! I really appreciate it!
@hfrogie9556
@hfrogie9556 2 жыл бұрын
If we have more than one file(multiple files) to rename.? Can i know the code?
@kurry74
@kurry74 2 жыл бұрын
Sir, thanx for such great tool, that I was looking for, but can you explain it in English or Hindi.
@rajeshveeramallu2186
@rajeshveeramallu2186 3 жыл бұрын
👌👌👌 sir
@rajeshveeramallu2186
@rajeshveeramallu2186 3 жыл бұрын
Can u provide contact details sir
@sshallu6232
@sshallu6232 3 жыл бұрын
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 😊
@theprofessor9871
@theprofessor9871 3 жыл бұрын
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
@sshallu6232
@sshallu6232 3 жыл бұрын
Thak you sir
@sshallu6232
@sshallu6232 3 жыл бұрын
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 ....
@sshallu6232
@sshallu6232 3 жыл бұрын
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..?
@theprofessor9871
@theprofessor9871 3 жыл бұрын
@@sshallu6232 two folders eruntha folder path ah change panni neenga code ah two times run pannanum
@TheSimojamal
@TheSimojamal Жыл бұрын
Thanks boss
@torukmakto0
@torukmakto0 2 жыл бұрын
Thank you, its working but, multiple file upload, its not working. Can we fix that problem on code?
@John-ee9tj
@John-ee9tj 2 жыл бұрын
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
@akashmishra5081
@akashmishra5081 2 жыл бұрын
were u able to eliminate the syntax error that came with newName code of line. can u pls help
@John-ee9tj
@John-ee9tj 2 жыл бұрын
@@akashmishra5081 No idea what you meant here...lol...the code works perfectly well...except the loop...
@ktthecomputerclasses7456
@ktthecomputerclasses7456 3 жыл бұрын
Hi sir Is it possible multiple documents rename without find text
@minesdept7340
@minesdept7340 2 жыл бұрын
Line number 19 me error batata hai plz resolve it
@ktthecomputerclasses7456
@ktthecomputerclasses7456 3 жыл бұрын
Hi sir , Is it possible create a separate folder. For everyone person after submit from.
@davoodjani4558
@davoodjani4558 2 жыл бұрын
u can do it with form with form director
@putraf6263
@putraf6263 2 жыл бұрын
How to change new rename on script?
@raajdhaniengineeringcolleg9103
@raajdhaniengineeringcolleg9103 2 жыл бұрын
line 19 ​var photoID = itemResponsePhoto.getResponse(); error
@davoodjani4558
@davoodjani4558 2 жыл бұрын
same, for me too, can u plz let us know the reason plz
@shukriabduljalil3712
@shukriabduljalil3712 2 жыл бұрын
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); } } } }
@amaltjoseph9333
@amaltjoseph9333 2 жыл бұрын
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.
Rename Files Uploaded through Google Forms Automatically
9:33
Digital Inspiration
Рет қаралды 10 М.
Amazing Parenting Hacks! 👶✨ #ParentingTips #LifeHacks
00:18
Snack Chat
Рет қаралды 21 МЛН
Google Apps Script - Google Drive Tutorial, Files, Folders, Copy Files, DriveApp, Iterator - Part 15
29:31
Learn Google Sheets & Excel Spreadsheets
Рет қаралды 131 М.
How to create Google Drive Folder and place files on submission of Google Form?
5:40
Form Director - Jivrus Technologies
Рет қаралды 31 М.
Google Form - Using Apps Script to Populate Google Sheet
11:29
Code With Curt
Рет қаралды 102 М.
Gooogle Form Tips - Rename Uploaded Files
24:55
Tips Teknologi Kantoran
Рет қаралды 3,2 М.
How to create a data entry form in Google Sheets [with multiple databases]
14:52