Advertisement
Guest User

Untitled

a guest
Jun 25th, 2019
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.44 KB | None | 0 0
  1. var formFile = DriveApp.getFileById(form.getId());
  2. folder.createFile(formFile.getBlob());
  3. DriveApp.removeFile(formFile);
  4.  
  5. // create the file in the root
  6. var spreadSheet = SpreadsheetApp.create(title + " (Response)");
  7.  
  8. // get a file (not a spreadsheet)
  9. var ssFile = DriveApp.getFileById(spreadSheet.getId());
  10.  
  11. // copy the file into the folder
  12. folder.createFile(ssFile.getBlob());
  13.  
  14. // delete the file from the root folder.
  15. DriveApp.removeFile(ssFile);
  16.  
  17. var folderID = 'myFolderID_Here';
  18.  
  19. var fileResource = {
  20. title: 'myNewFile',
  21. "parents": [{'id':folderID}], //<--By setting this parent ID to the folder's ID, it creates this file in the correct folder.
  22. mimeType: 'application/vnd.google-apps.form'
  23. };
  24.  
  25. var newFile = Drive.Files.insert(fileResource);
  26.  
  27. var theID = newFile.getId();
  28. Logger.log('theID: ' + theID);
  29.  
  30. function getResponsesOutOfForm() {
  31. var frm = FormApp.openById('My_Form_ID');
  32. var allResponses = frm.getResponses();
  33. var arrayOfData = [], rowArray = [], theResponse, formResponse, itemResponses;
  34.  
  35. for (var i = 0; i < allResponses.length; i++) {
  36. formResponse = allResponses[i];
  37. itemResponses = formResponse.getItemResponses();
  38.  
  39. rowArray = []; //Reset inner array
  40.  
  41. for (var j = 0; j < itemResponses.length; j++) {
  42. theResponse = itemResponses[j].getResponse();
  43. rowArray.push(theResponse);
  44. };
  45.  
  46. arrayOfData.push(rowArray);
  47. };
  48.  
  49. Logger.log(arrayOfData)
  50. return arrayOfData;
  51. };
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement