What Happens to Uploaded Files When You Cancel Google Drive Folder Upload

WORKING Lawmaking HERE: https://jsfiddle.internet/nateomardavis/e0317gb6/

ORIGINAL QUESTION Beneath

How do I remove a course-submitted file from Drive itself?

I'm having trouble sorting out why a google form is submitting files to both my drive (not in a binder) just also into an auto-generated submission folder.

I've been able to move the renamed file to a new binder and delete the re-create in the auto-generated submission folder. I cannot figure out how to remove the copy that'due south just listed in "Bulldoze", not in any binder.

THE PROCESS (EDIT)

Allow me endeavor to explain the process more. I have a form that collects files. Google automatically makes a folder and sub-folders. I have successfully renamed the submitted files, moved them to a new binder, and deleted them from the Google-generated folder. Notwithstanding, a re-create of the original, unchanged file is going to Google Drive, the root binder. Steps ane-3 (below) work as expected. Step iv is where I'thou running into problems.

1. The original file being uploaded to a form. Notation the file proper name.

2. The Google-generated folder. The file is submitted this binder.

3. The renamed file in a new folder. The original file is deleted from the folder above.

4. The original file is now showing upwardly in Bulldoze, not in a folder but there. The name of this file is the same as the originally uploaded one. The 1 which went to the "passes" folder and was and then deleted from that binder.

SNIPPET

          //RENAME PASSES if (itemResponses[f].getItem().getTitle() == "PASSES") {  var files = itemResponses[f].getResponse(); //Logger.log(files.length); if (files.length > 0) {   for (var n in files) {     var dFile = DriveApp.getFileById(files[n]);     dFile.setName("LSS - " + yr + " - " + teamName + " - " + "PASSES - " + today );     teamFolder.addFile(dFile);   //MOVE SUBMITTED DOCUMENTS TO THAT Binder     passesFolder.removeFile(dFile); //REMOVE FROM SUBMISSION FOLDER     DriveApp.getRootFolder().removeFile(dFile) // (DOES Not WORK) REMOVE FROM DRIVE FOLDER     DriveApp.removeFile(dFile) // (DOES NOT Work) REMOVE FROM Bulldoze FOLDER   } }                  

FULL Lawmaking

          office getLastResponse() {    var form = FormApp.openById('ID');    var today = Utilities.formatDate(new Date(), Session.getScriptTimeZone(), "MM/dd/yyyy hh:mm a");   var year = Utilities.formatDate(new Date(), Session.getScriptTimeZone(), "YYYY");   Logger.log(today);    var formResponses = form.getResponses();   //Logger.log(formResponses.length);   var formResponse = formResponses[formResponses.length-one];   var respondentEmail = formResponse.getRespondentEmail()   var itemResponses = formResponse.getItemResponses();   Logger.log(itemResponses.length);   var teamName = itemResponses[2].getResponse();   //Logger.log("team name: " + teamName);     //CHECK FOLDERS    var dropbox = "Lititz Summer Showcase Team Check In (File responses)";     var binder, folders = DriveApp.getFoldersByName(dropbox);      var teamBox = teamName;     var teamFolder, teamFolders = DriveApp.getFoldersByName(teamBox);      var passesFolder = DriveApp.getFolderById('ID');     var rosterFolder = DriveApp.getFolderById('ID');     var teamInfoFolder = DriveApp.getFolderById('ID');     var permissionToTravelFolder = DriveApp.getFolderById('ID');      if (folders.hasNext()) { //CHECK IF DRIVE HAS FOLDER FOR FORM       folder = folders.next();     } else { //IF Not CREATE Binder       folder = DriveApp.createFolder(dropbox);     }      if (teamFolders.hasNext()) {  //Bank check IF FOLDER FOR TEAM EXISTS        teamFolder = teamFolders.next();     } else { //IF Non CREATE Binder       teamFolder = folder.createFolder(teamBox);       teamFolder.setSharing(DriveApp.Access.ANYONE_WITH_LINK, DriveApp.Permission.COMMENT);     }  for (var f = 0; f < itemResponses.length; f++) {     Logger.log(itemResponses[f].getItem().getType());     Logger.log(itemResponses[f].getItem().getTitle());   if (itemResponses[f].getItem().getType() == "FILE_UPLOAD") {     Logger.log("In that location IS A FILE UPLOAD");      //RENAME PASSES     if (itemResponses[f].getItem().getTitle() == "PASSES") {      var files = itemResponses[f].getResponse();     //Logger.log(files.length);     if (files.length > 0) {       for (var n in files) {         var dFile = DriveApp.getFileById(files[n]);         dFile.setName("LSS - " + year + " - " + teamName + " - " + "PASSES - " + today );         teamFolder.addFile(dFile);   //Movement SUBMITTED DOCUMENTS TO THAT Binder         passesFolder.removeFile(dFile); //REMOVE FROM SUBMISSION Folder         DriveApp.removeFile(dFile); // REMOVE FROM DRIVE Folder       }     }     //RENAME ROSTER     } else if (itemResponses[f].getItem().getTitle() == "ROSTER") {       var files = itemResponses[f].getResponse();     //Logger.log(files.length);     if (files.length > 0) {       for (var due north in files) {         var dFile = DriveApp.getFileById(files[n]);         dFile.setName("LSS - " + year + " - " + teamName + " - " + "ROSTER - " + today );         teamFolder.addFile(dFile);        }     }    //RENAME Team INFO Sail    } else if (itemResponses[f].getItem().getTitle() == "TEAM INFO Canvass") {       var files = itemResponses[f].getResponse();     //Logger.log(files.length);     if (files.length > 0) {       for (var n in files) {         var dFile = DriveApp.getFileById(files[northward]);         dFile.setName("LSS - " + twelvemonth + " - " + teamName + " - " + "TEAM INFO Sheet - " + today );         teamFolder.addFile(dFile);       }     }    //RENAME PERMISSION TO TRAVEL   } else if (itemResponses[f].getItem().getTitle() == "PERMISSION TO TRAVEL") {       var files = itemResponses[f].getResponse();     //Logger.log(files.length);     if (files.length > 0) {       for (var n in files) {         var dFile = DriveApp.getFileById(files[n]);         Logger.log(ownerEmail);         dFile.setName("LSS - " + year + " - " + teamName + " - " + "PERMISSION TO TRAVEL - " + today );         teamFolder.addFile(dFile);       }     }     } }//Cease 'IF FILE UPLOAD' }//Finish FOR LOOP   }//Stop FUNCTION                  

baisleycoonly.blogspot.com

Source: https://stackoverflow.com/questions/56171896/remove-google-form-submitted-file

Share this post