Moving google apps script to v8 file upload stopped working from sidebar

by

How about this answer? Please think of this as just one of several possible answers.

Issue and workaround:

I could confirm about the same situation of your issue (this was reported on Google’s Issue Tracker). In this case, I think that when V8 is enabled, the form object might not be able to be parsed when the object is sent to Google Apps Script side with google.script.run. Although I think that this might be modified in the future update, as the current workaround, I would like to propose to send the uploaded file to GAS side as the byte array.

When your script is modified, it becomes as follows.

Modified script:

HTML&Javascript side: ContractUpload.html

Please modify uploadthis as follows.

function uploadthis(fileForm){
  const file = fileForm.myFile.files[0];
  const fr = new FileReader();
  fr.onload = function(e) {
    const obj = {
      // filename: file.name,  // In your script, the filename is given at GAS side. So I removed this.
      mimeType: file.type,
      bytes: [...new Int8Array(e.target.result)]
    };
    google.script.run.withSuccessHandler((e) => console.log(e)).uploadFiles(obj);
  };
  fr.readAsArrayBuffer(file);
}

Google Apps Script side: Code.gs

Please modify uploadFiles as follows.

function uploadFiles(data){
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sStamdata = ss.getSheetByName('Stamdata_New');
  var contractFolderId = sStamdata.getRange('D60').getValue(); 
  var idag = Utilities.formatDate(new Date(), "GMT+1", "yyyyMMdd");
  var title = sStamdata.getRange('D52').getValue();
  
  var file = Utilities.newBlob(data.bytes, data.mimeType, idag+" - KONTRAKT - "+title);  // Modified
  var folder = DriveApp.getFolderById(contractFolderId);
  var createFile = folder.createFile(file);
  return createFile.getId();  // Added
}

Note:

  • At above modification, when the file is uploaded, the file is converted to the byte array and send it to GAS side. Then, the file is created from the byte array. And the file ID is returned. You can see it at the console.

References:

If I misunderstood your question and this was not the direction you want, I apologize.

More Related Contents:

  1. UiApp has been deprecated. Please use HtmlService instead
  2. How do I communicate a page(modal dialog) with its sibling (sidebar)?
  3. How can I be getting multiple unwanted event blocks from the same onFormSubmit Trigger?
  4. Is it possible to ‘prefill’ a google form using data from a google spreadsheet?
  5. Is there a way to evaluate a formula that is stored in a cell?
  6. Detect user inserting row or column in a google spreadsheet and reacting in a script
  7. How to auto select range from a filter without having to manually enter it?
  8. Is there a custom function or script that returns gid of a specific sheet in Google Sheets?
  9. Script to Change Row Color when a cell changes text
  10. Sheet.getRange(1,1,1,12) what does the numbers in bracket specify?
  11. How to get onFormSubmit to trigger automatically?
  12. Copying a spreadsheet copies all linked files as well
  13. “SpreadsheetApp.getUi() cannot be called from this context”
  14. copy data from one sheet to another in google app script and append a row, one small issue
  15. Using built-in spreadsheet functions in a script
  16. Google App Scripts cannot be given Authorization or Permission
  17. How to get the correct range to set the value to a cell?
  18. Refresh data retrieved by a custom function in Google Sheet
  19. How to extract the link from a cell now that links are not reflected as HYPERLINK?
  20. Dynamically creating spreadsheet menu items
  21. Increment Cell value by one by clicking
  22. Is there any limit on number of concurrent hits or simultaneous executions on Google App Script Web App
  23. email notification if cell is changed
  24. Dynamic selection options in Google Apps Script for forms
  25. Determine current user in Apps Script
  26. How to ignore empty cell values for getRange().getValues()
  27. Use script in all spreadsheets
  28. Stopping the error “Authorisation is required to perform that action” in Google Apps Script
  29. We’re sorry, a server error occurred while reading from storage. Error code PERMISSION_DENIED
  30. e.range.getA1Notation() unable to track changes caused by formula update

Leave a Comment