Discover ways to transfer uploaded information from Google Types to a particular folder in Google Drive. You can even rename the information based mostly on the shape responses
The File Add function of Google Types helps you to obtain information from kind respondents straight in your Google Drive. It’s possible you’ll add the File Add query in your Google Type to obtain PDF assignments from college students, job purposes, portfolio photos from contestants, and extra.
Whereas the file add function in Google Types is useful, it does have one huge limitation. As an illustration, when a respondent uploads a file by Google Types, the file is saved in a set folder inside the kind proprietor’s Google Drive. All uploaded information are are saved to the identical folder, making it tough to find out which respondent has uploaded which set of information.
Transfer Uploaded Information in Google Types
That is the place Doc Studio may also help you. The add-on may also help you routinely arrange uploaded information in customized folders as quickly as they’re obtained in your Google Drive by Google Types. You’ll be able to transfer uploaded to a different folder, or rename the information based mostly on the respondents’ solutions within the Google Type. Moreover, you’ll be able to arrange the uploaded information into subfolders for handy entry.
Put together Google Type
For this instance, we’ve created a Google Type for gathering job purposes for various positions in our firm. The candidates have to offer their full identify, the place they’re making use of for, after which add their resume in PDF format.
By default, all uploaded information might be added in a brand new father or mother folder that’s created by Google Types in your Google Drive. Nonetheless, you’ll be able to arrange the resume information in subfolders and transfer them to a particular folder based mostly on the place the candidate has utilized for. It will make it easier to simply discover the resumes of candidates who’ve utilized for a particular place.
The uploaded information will also be renamed based mostly on the candidate’s identify or their e mail tackle. It will make it easier to shortly establish the resumes of particular candidates.
Transfer Information to Customized Folders in Google Drive
Set up the Document Studio and open the add-on in your Google Type. Create a brand new workflow and select the File Uploads process from the listing of obtainable duties.
With Doc Studio, you’ll be able to transfer the uploaded information to a different folder, copy the information to a different folder, or rename the information based mostly on the shape responses. For our instance, we’ll transfer and in addition rename the uploaded information based mostly on the place the candidate has utilized for.
Choose the file add query from the listing of obtainable questions. Subsequent, select the father or mother Google Drive folder the place you want to copy or transfer the uploaded information. You may additionally select to avoid wasting the uploaded information in a Shared Drive Folder, one thing that isn’t attainable with the default Google Types file add function.
For the subfolder path enter subject, present the complete path the place you need the uploaded information to be saved. You should use placeholders like {{Nation}} or {{Place}} to dynamically create subfolders based mostly on the shape responses.
Lastly, present a brand new identify for the uploaded information. For our instance, we have now used the {{Identify}} placeholder to rename the uploaded information based mostly on the candidate’s identify offered within the Google Type.
Save the workflow and your automation is prepared. Now, every time a candidate uploads their resume by your Google Type, the uploaded file might be moved to a customized folder in your Google Drive. The file may also be renamed based mostly on the candidate’s identify.
Transfer File Uploads with Google Apps Script
In case you are snug with Google Apps Script, you may as well write a customized script that may transfer the uploaded information to a particular folder in Google Drive. The script will be hooked up to your Google Type and can run routinely every time a brand new kind response is submitted.
To get began, go to your Google Drive and create a brand new folder (or use an current folder). Open the folder and seize the ID of the folder from the browser’s tackle bar as proven within the screenshot.
Subsequent, go to your Google Type that’s accepting File Uploads and select Script Editor from the 3-dot menu. Contained in the script editor, take away all the present code and copy-paste the next snippet. Bear in mind to interchange the Folder Id in line #1 with the Id of the folder that you just’ve created within the earlier step.
const PARENT_FOLDER_ID = '<>' ;
const initialize = () => {
const kind = FormApp.getActiveForm();
ScriptApp.newTrigger('onFormSubmit').forForm(kind).onFormSubmit().create();
};
const onFormSubmit = ({ response } = {}) => {
strive {
const information = response
.getItemResponses()
.filter((itemResponse) => itemResponse.getItem().getType().toString() === 'FILE_UPLOAD')
.map((itemResponse) => itemResponse.getResponse())
.scale back((a, b) => [...a, ...b], []);
if (information.size > 0) {
const subfolderName = response.getId();
const parentFolder = DriveApp.getFolderById(PARENT_FOLDER_ID);
const subfolder = parentFolder.createFolder(subfolderName);
information.forEach((fileId) => {
DriveApp.getFileById(fileId).moveTo(subfolder);
});
}
} catch (f) {
Logger.log(f);
}
};Create OnFormSubmit Set off
Contained in the script editor, choose initialize from the operate drop-down and click on the Run button to create the OnFormSubmit set off in your present Google Type.
It will basically run the Apps Script code every time somebody submits a brand new kind entry and add information to a particular folder in Google Drive.
That’s it. Go to your Google Type and submit a brand new check entry. You must now see all of the uploaded information neatly organized in a customized folder beneath the father or mother folder. The identify of the customized folder is the distinctive Response Id that Google Types routinely assigns to each kind submission.
Additionally see:
