Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var formFile = DriveApp.getFileById(form.getId());
- folder.createFile(formFile.getBlob());
- DriveApp.removeFile(formFile);
- // create the file in the root
- var spreadSheet = SpreadsheetApp.create(title + " (Response)");
- // get a file (not a spreadsheet)
- var ssFile = DriveApp.getFileById(spreadSheet.getId());
- // copy the file into the folder
- folder.createFile(ssFile.getBlob());
- // delete the file from the root folder.
- DriveApp.removeFile(ssFile);
- var folderID = 'myFolderID_Here';
- var fileResource = {
- title: 'myNewFile',
- "parents": [{'id':folderID}], //<--By setting this parent ID to the folder's ID, it creates this file in the correct folder.
- mimeType: 'application/vnd.google-apps.form'
- };
- var newFile = Drive.Files.insert(fileResource);
- var theID = newFile.getId();
- Logger.log('theID: ' + theID);
- function getResponsesOutOfForm() {
- var frm = FormApp.openById('My_Form_ID');
- var allResponses = frm.getResponses();
- var arrayOfData = [], rowArray = [], theResponse, formResponse, itemResponses;
- for (var i = 0; i < allResponses.length; i++) {
- formResponse = allResponses[i];
- itemResponses = formResponse.getItemResponses();
- rowArray = []; //Reset inner array
- for (var j = 0; j < itemResponses.length; j++) {
- theResponse = itemResponses[j].getResponse();
- rowArray.push(theResponse);
- };
- arrayOfData.push(rowArray);
- };
- Logger.log(arrayOfData)
- return arrayOfData;
- };
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement