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

แชร์
ฝัง
  • เผยแพร่เมื่อ 10 ก.พ. 2025
  • Script Given in Comment

ความคิดเห็น • 33

  • @theprofessor9871
    @theprofessor9871  3 ปีที่แล้ว +2

    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 ปีที่แล้ว +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 3 ปีที่แล้ว +1

      delete all space before first letter on row 19 until end

    • @agungalrizkyandreawan3212
      @agungalrizkyandreawan3212 2 ปีที่แล้ว

      Can Halp me error on line 19

    • @mishracard
      @mishracard หลายเดือนก่อน

      Sir plz reply,,
      text file and how to work rename file ,,,

  • @jorgegomezbedoya2785
    @jorgegomezbedoya2785 3 ปีที่แล้ว

    Thank you very much!!! I really appreciate it!

  • @sshallu6232
    @sshallu6232 3 ปีที่แล้ว +1

    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

      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 ปีที่แล้ว +1

      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

  • @hfrogie9556
    @hfrogie9556 2 ปีที่แล้ว +2

    If we have more than one file(multiple files) to rename.? Can i know the code?

  • @rajeshveeramallu2186
    @rajeshveeramallu2186 3 ปีที่แล้ว +1

    👌👌👌 sir

  • @kurry74
    @kurry74 3 ปีที่แล้ว +1

    Sir, thanx for such great tool, that I was looking for, but can you explain it in English or Hindi.

  • @torukmakto0
    @torukmakto0 3 ปีที่แล้ว

    Thank you, its working but, multiple file upload, its not working. Can we fix that problem on code?

  • @TheSimojamal
    @TheSimojamal ปีที่แล้ว

    Thanks boss

  • @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 3 ปีที่แล้ว

    How to change new rename on script?

  • @John-ee9tj
    @John-ee9tj 2 ปีที่แล้ว +1

    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...

  • @raajdhaniengineeringcolleg9103
    @raajdhaniengineeringcolleg9103 2 ปีที่แล้ว +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 ปีที่แล้ว +1

      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.