Google forms file upload by USER not by question





.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}







0















Good morning! Another Google forms question. I'm currently working on a lengthy Google form where each submission could entail the upload of about 7-8 additional documents, which are uploaded to my Google drive. Google automatically sorts the file uploads by question (i.e., all file uploads associated with question 20 go into a folder in my Google drive for question 20). Is there a way to group all uploads by USER into a single folder?



That way, instead of needing to look in 7-8 different folders in my Google drive to find all the uploads, the uploads would all be in one folder for Johnny S. or whomever.










share|improve this question































    0















    Good morning! Another Google forms question. I'm currently working on a lengthy Google form where each submission could entail the upload of about 7-8 additional documents, which are uploaded to my Google drive. Google automatically sorts the file uploads by question (i.e., all file uploads associated with question 20 go into a folder in my Google drive for question 20). Is there a way to group all uploads by USER into a single folder?



    That way, instead of needing to look in 7-8 different folders in my Google drive to find all the uploads, the uploads would all be in one folder for Johnny S. or whomever.










    share|improve this question



























      0












      0








      0








      Good morning! Another Google forms question. I'm currently working on a lengthy Google form where each submission could entail the upload of about 7-8 additional documents, which are uploaded to my Google drive. Google automatically sorts the file uploads by question (i.e., all file uploads associated with question 20 go into a folder in my Google drive for question 20). Is there a way to group all uploads by USER into a single folder?



      That way, instead of needing to look in 7-8 different folders in my Google drive to find all the uploads, the uploads would all be in one folder for Johnny S. or whomever.










      share|improve this question
















      Good morning! Another Google forms question. I'm currently working on a lengthy Google form where each submission could entail the upload of about 7-8 additional documents, which are uploaded to my Google drive. Google automatically sorts the file uploads by question (i.e., all file uploads associated with question 20 go into a folder in my Google drive for question 20). Is there a way to group all uploads by USER into a single folder?



      That way, instead of needing to look in 7-8 different folders in my Google drive to find all the uploads, the uploads would all be in one folder for Johnny S. or whomever.







      google-apps-script google-form






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Nov 16 '18 at 19:22









      TheMaster

      10.7k3937




      10.7k3937










      asked Nov 16 '18 at 18:35









      Ashley HigginsAshley Higgins

      61




      61
























          2 Answers
          2






          active

          oldest

          votes


















          0














          It is possible.



          Strategy:




          • Create a bound function in form to trigger on Form Submit

          • Get Form response from the event object

          • Get all item responses and their titles from the form response

          • Item response should be the file ID for upload type items

          • Use the file ID to copy/move the file to their respective folders using DriveApp


          References:





          • Form submit Trigger Event Object

          • DriveApp






          share|improve this answer































            0














            You can write an onFormSubmit trigger that uses the DriveApp service to get a list of all files under the form's folder / subfolder and moves them to another folder. The script should also remove the files from the original folder since, in Google Drive, it is possible to have the same file in multiple folders.



            Here's a snippet to move files between folders.



            function moveFiles(source, target) {      
            var files = source.getFiles();
            // this will get the files in subfolders as well
            while (files.hasNext()) {
            var file = files.next();
            target.addFile(file);
            source.removeFile(file);
            }
            }





            share|improve this answer
























              Your Answer






              StackExchange.ifUsing("editor", function () {
              StackExchange.using("externalEditor", function () {
              StackExchange.using("snippets", function () {
              StackExchange.snippets.init();
              });
              });
              }, "code-snippets");

              StackExchange.ready(function() {
              var channelOptions = {
              tags: "".split(" "),
              id: "1"
              };
              initTagRenderer("".split(" "), "".split(" "), channelOptions);

              StackExchange.using("externalEditor", function() {
              // Have to fire editor after snippets, if snippets enabled
              if (StackExchange.settings.snippets.snippetsEnabled) {
              StackExchange.using("snippets", function() {
              createEditor();
              });
              }
              else {
              createEditor();
              }
              });

              function createEditor() {
              StackExchange.prepareEditor({
              heartbeatType: 'answer',
              autoActivateHeartbeat: false,
              convertImagesToLinks: true,
              noModals: true,
              showLowRepImageUploadWarning: true,
              reputationToPostImages: 10,
              bindNavPrevention: true,
              postfix: "",
              imageUploader: {
              brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
              contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
              allowUrls: true
              },
              onDemand: true,
              discardSelector: ".discard-answer"
              ,immediatelyShowMarkdownHelp:true
              });


              }
              });














              draft saved

              draft discarded


















              StackExchange.ready(
              function () {
              StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53343559%2fgoogle-forms-file-upload-by-user-not-by-question%23new-answer', 'question_page');
              }
              );

              Post as a guest















              Required, but never shown

























              2 Answers
              2






              active

              oldest

              votes








              2 Answers
              2






              active

              oldest

              votes









              active

              oldest

              votes






              active

              oldest

              votes









              0














              It is possible.



              Strategy:




              • Create a bound function in form to trigger on Form Submit

              • Get Form response from the event object

              • Get all item responses and their titles from the form response

              • Item response should be the file ID for upload type items

              • Use the file ID to copy/move the file to their respective folders using DriveApp


              References:





              • Form submit Trigger Event Object

              • DriveApp






              share|improve this answer




























                0














                It is possible.



                Strategy:




                • Create a bound function in form to trigger on Form Submit

                • Get Form response from the event object

                • Get all item responses and their titles from the form response

                • Item response should be the file ID for upload type items

                • Use the file ID to copy/move the file to their respective folders using DriveApp


                References:





                • Form submit Trigger Event Object

                • DriveApp






                share|improve this answer


























                  0












                  0








                  0







                  It is possible.



                  Strategy:




                  • Create a bound function in form to trigger on Form Submit

                  • Get Form response from the event object

                  • Get all item responses and their titles from the form response

                  • Item response should be the file ID for upload type items

                  • Use the file ID to copy/move the file to their respective folders using DriveApp


                  References:





                  • Form submit Trigger Event Object

                  • DriveApp






                  share|improve this answer













                  It is possible.



                  Strategy:




                  • Create a bound function in form to trigger on Form Submit

                  • Get Form response from the event object

                  • Get all item responses and their titles from the form response

                  • Item response should be the file ID for upload type items

                  • Use the file ID to copy/move the file to their respective folders using DriveApp


                  References:





                  • Form submit Trigger Event Object

                  • DriveApp







                  share|improve this answer












                  share|improve this answer



                  share|improve this answer










                  answered Nov 16 '18 at 19:31









                  TheMasterTheMaster

                  10.7k3937




                  10.7k3937

























                      0














                      You can write an onFormSubmit trigger that uses the DriveApp service to get a list of all files under the form's folder / subfolder and moves them to another folder. The script should also remove the files from the original folder since, in Google Drive, it is possible to have the same file in multiple folders.



                      Here's a snippet to move files between folders.



                      function moveFiles(source, target) {      
                      var files = source.getFiles();
                      // this will get the files in subfolders as well
                      while (files.hasNext()) {
                      var file = files.next();
                      target.addFile(file);
                      source.removeFile(file);
                      }
                      }





                      share|improve this answer




























                        0














                        You can write an onFormSubmit trigger that uses the DriveApp service to get a list of all files under the form's folder / subfolder and moves them to another folder. The script should also remove the files from the original folder since, in Google Drive, it is possible to have the same file in multiple folders.



                        Here's a snippet to move files between folders.



                        function moveFiles(source, target) {      
                        var files = source.getFiles();
                        // this will get the files in subfolders as well
                        while (files.hasNext()) {
                        var file = files.next();
                        target.addFile(file);
                        source.removeFile(file);
                        }
                        }





                        share|improve this answer


























                          0












                          0








                          0







                          You can write an onFormSubmit trigger that uses the DriveApp service to get a list of all files under the form's folder / subfolder and moves them to another folder. The script should also remove the files from the original folder since, in Google Drive, it is possible to have the same file in multiple folders.



                          Here's a snippet to move files between folders.



                          function moveFiles(source, target) {      
                          var files = source.getFiles();
                          // this will get the files in subfolders as well
                          while (files.hasNext()) {
                          var file = files.next();
                          target.addFile(file);
                          source.removeFile(file);
                          }
                          }





                          share|improve this answer













                          You can write an onFormSubmit trigger that uses the DriveApp service to get a list of all files under the form's folder / subfolder and moves them to another folder. The script should also remove the files from the original folder since, in Google Drive, it is possible to have the same file in multiple folders.



                          Here's a snippet to move files between folders.



                          function moveFiles(source, target) {      
                          var files = source.getFiles();
                          // this will get the files in subfolders as well
                          while (files.hasNext()) {
                          var file = files.next();
                          target.addFile(file);
                          source.removeFile(file);
                          }
                          }






                          share|improve this answer












                          share|improve this answer



                          share|improve this answer










                          answered Nov 17 '18 at 14:28









                          Amit AgarwalAmit Agarwal

                          5,62711326




                          5,62711326






























                              draft saved

                              draft discarded




















































                              Thanks for contributing an answer to Stack Overflow!


                              • Please be sure to answer the question. Provide details and share your research!

                              But avoid



                              • Asking for help, clarification, or responding to other answers.

                              • Making statements based on opinion; back them up with references or personal experience.


                              To learn more, see our tips on writing great answers.




                              draft saved


                              draft discarded














                              StackExchange.ready(
                              function () {
                              StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53343559%2fgoogle-forms-file-upload-by-user-not-by-question%23new-answer', 'question_page');
                              }
                              );

                              Post as a guest















                              Required, but never shown





















































                              Required, but never shown














                              Required, but never shown












                              Required, but never shown







                              Required, but never shown

































                              Required, but never shown














                              Required, but never shown












                              Required, but never shown







                              Required, but never shown







                              Popular posts from this blog

                              Florida Star v. B. J. F.

                              Danny Elfman

                              Retrieve a Users Dashboard in Tumblr with R and TumblR. Oauth Issues