Modify script to get sheet folder ID-CodePudding

I would like some help to modify this script here: Upload multiple large files to Google Drive using Google Apps Script

The question is the following: this script uploads to a folder within the folder defined in const uploadParentFolderId = "1cOe4ZXjBUZHgPwADg1QRpUzcQqGxON_4"; which is in the forms.html file, the problem is that I intend to call this script within a spreadsheet through an html alert and I would like that the file was uploaded inside a folder of the spreadsheet folder, that is, the script would need to get the ID of the spreadsheet folder.

Javascript is a language that is a little out of my daily life, but I'm trying to learn it on my own...

If anyone can give me a light on this, it will be of great help!

EDIT:

I tried this:

var ssid = SpreadsheetApp.getActiveSpreadsheet().getId();
var AllFolders = DriveApp.getFileById(ssid).getParents();
var ChildFolderTest;
if (AllFolders.hasNext()) {
ChildFolderTest = AllFolders.next();
var FinalFolderID = ChildFolderTest.getId();
          }
    
    
const chunkSize = 5242880;
const uploadParentFolderId = FinalFolderID; // creates a folder inside of this folder

But for some reason it doesn't work, the upload doesn't start.

Any idea how to resolve?

CodePudding user response：

Here is an example of how to get the spreadsheet folder id.

form.html

<!DOCTYPE html>
<html>
  <head>
    <base target="_top">
  </head>
  <body>
    <input id="uploadParentFolderId" type="text">
    <br>
    <input id="getFolderButton" type="button" onclick="getFolderButtonClick()" value="Get Folder">
    <script>
      function getFolderButtonClick() {
        try {
          google.script.run.withSuccessHandler( 
            function(folder) {
              document.getElementById("uploadParentFolderId").value = folder;
            }
          ).getFolder();
        }
        catch(err) {
          alert(err);
        }
      }
    </script>
  </body>
</html>

Code.gs

function getFolder() {
  try {
    let spread = SpreadsheetApp.getActiveSpreadsheet();
    let file = DriveApp.getFileById(spread.getId());
    let folders = file.getParents();
    return folders.next().getId();
  }
  catch(err) {
    throw "Error in test: " err;
  }
}

Reference

google.script.run.withSuccessHandler()

CodePudding user response：

Another way to do this is via a printing scriptlet. You can use HTML templates which will output data from your server functions and print it to the HTML file.

Based on the script you found you can first change the declaration of the folder const on the forms.html file:

const uploadParentFolderId = <?=getParent()?>; // creates a folder inside of this folder

As explained in the docs, the <?= ... ?> tags indicate that the output from the getParent() function will be printed to the HTML file.

Then create getParent() on the Code.gs file to return the ID of the sheet's parent folder:

function getParent(){
  var ss = SpreadsheetApp.getActiveSpreadsheet()
  var id = ss.getId()
  var parent = DriveApp.getFileById(id).getParents().next().getId()
  return parent
}

Finally change the doGet() function on the Code.gs file to use a template instead of just printing the HTML file, this is so the <?=?> tags can be interpreted before outputting the page:

function doGet(e) {
  return HtmlService.createTemplateFromFile('forms.html').evaluate();
}

I just modified this from the script and was able to create the new folder in the same location as the Spreadsheet.

Reference:

HTML Templates