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;
}
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
edited Nov 16 '18 at 19:22
TheMaster
10.7k3937
asked Nov 16 '18 at 18:35
Ashley HigginsAshley Higgins
61
add a comment |
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
edited Nov 16 '18 at 19:22
TheMaster
10.7k3937
asked Nov 16 '18 at 18:35
Ashley HigginsAshley Higgins
61
add a comment |
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
edited Nov 16 '18 at 19:22
TheMaster
10.7k3937
asked Nov 16 '18 at 18:35
Ashley HigginsAshley Higgins
61
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
google-apps-script google-form
edited Nov 16 '18 at 19:22
TheMaster
10.7k3937
asked Nov 16 '18 at 18:35
Ashley HigginsAshley Higgins
61
edited Nov 16 '18 at 19:22
TheMaster
10.7k3937
asked Nov 16 '18 at 18:35
Ashley HigginsAshley Higgins
61
edited Nov 16 '18 at 19:22
TheMaster
10.7k3937
edited Nov 16 '18 at 19:22
TheMaster
10.7k3937
edited Nov 16 '18 at 19:22
TheMaster
10.7k3937
10.7k3937
asked Nov 16 '18 at 18:35
Ashley HigginsAshley Higgins
61
asked Nov 16 '18 at 18:35
Ashley HigginsAshley Higgins
61
asked Nov 16 '18 at 18:35
Ashley HigginsAshley Higgins
61
61
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
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
answered Nov 16 '18 at 19:31
TheMasterTheMaster
10.7k3937
add a comment |
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);
}
}
answered Nov 17 '18 at 14:28
Amit AgarwalAmit Agarwal
5,62711326
add a comment |
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
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
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
answered Nov 16 '18 at 19:31
TheMasterTheMaster
10.7k3937
add a comment |
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
answered Nov 16 '18 at 19:31
TheMasterTheMaster
10.7k3937
add a comment |
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
answered Nov 16 '18 at 19:31
TheMasterTheMaster
10.7k3937
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
answered Nov 16 '18 at 19:31
TheMasterTheMaster
10.7k3937
answered Nov 16 '18 at 19:31
TheMasterTheMaster
10.7k3937
answered Nov 16 '18 at 19:31
TheMasterTheMaster
10.7k3937
answered Nov 16 '18 at 19:31
TheMasterTheMaster
10.7k3937
10.7k3937
add a comment |
add a comment |
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);
}
}
answered Nov 17 '18 at 14:28
Amit AgarwalAmit Agarwal
5,62711326
add a comment |
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);
}
}
answered Nov 17 '18 at 14:28
Amit AgarwalAmit Agarwal
5,62711326
add a comment |
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);
}
}
answered Nov 17 '18 at 14:28
Amit AgarwalAmit Agarwal
5,62711326
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);
}
}
answered Nov 17 '18 at 14:28
Amit AgarwalAmit Agarwal
5,62711326
answered Nov 17 '18 at 14:28
Amit AgarwalAmit Agarwal
5,62711326
answered Nov 17 '18 at 14:28
Amit AgarwalAmit Agarwal
5,62711326
answered Nov 17 '18 at 14:28
Amit AgarwalAmit Agarwal
5,62711326
5,62711326
add a comment |
add a comment |
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.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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
