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); } } }
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 😊
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
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 ....
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..?
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
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); } } } }
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.
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);
}
}
}
This is a great tool and exactly what I was looking for , however I continue to get an error on line 19 "code.gs" :(
@@KelseyWaltersS same problem madam
delete all space before first letter on row 19 until end
Can Halp me error on line 19
Sir plz reply,,
text file and how to work rename file ,,,
Thank you very much!!! I really appreciate it!
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 😊
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
Thak you sir
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 ....
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..?
@@sshallu6232 two folders eruntha folder path ah change panni neenga code ah two times run pannanum
If we have more than one file(multiple files) to rename.? Can i know the code?
👌👌👌 sir
Can u provide contact details sir
Sir, thanx for such great tool, that I was looking for, but can you explain it in English or Hindi.
Thank you, its working but, multiple file upload, its not working. Can we fix that problem on code?
Thanks boss
Hi sir
Is it possible multiple documents rename without find text
Line number 19 me error batata hai plz resolve it
Hi sir ,
Is it possible create a separate folder. For everyone person after submit from.
u can do it with form with form director
How to change new rename on script?
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
were u able to eliminate the syntax error that came with newName code of line. can u pls help
@@akashmishra5081 No idea what you meant here...lol...the code works perfectly well...except the loop...
line 19 var photoID = itemResponsePhoto.getResponse(); error
same, for me too, can u plz let us know the reason plz
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);
}
}
}
}
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.