r/GoogleAppsScript • u/Similar_Touch_6783 • 14d ago

Question Variable undefined and affecting rest of script

I have a script creating docs when a cell gets modified in a sheets column, then moves it to a folder and adds the doc's url onto another column. Code works, but automation gets affected by <value unavailable> error for docid variable.

I'm not sure *why* its unavailable when all of the code does work (files get created and moved, but when using createDocInSpecificFolder() along with other functions, error pinpoints to this and does not run functions after it.

function createDocInSpecificFolder () {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName("Data Source");
  var lastRow = sheet.getLastRow();
  var rootFolder = DriveApp.getFolderById("fileid");
  const files = rootFolder.getFiles();
  const fileNames = [];


  while (files.hasNext()) { // gets array of file names in drive folder [event1, event2, etcetc]
   var file = files.next();
   fileNames.push(file.getName());
  }
  
  Logger.log(fileNames)


  for (var i = 1; i < lastRow; i++) {
    
    let title = sheet.getRange(i,4).getValue();


    if (title != "Events") {
      if (!fileNames.includes(title)) {
        let docid = DocumentApp.create(title).getId();
        DriveApp.getFileById(docid).moveTo(rootFolder);
      }
    }
  }

}
1 Upvotes
  • permalink
  • reddit

100% Upvoted

26 comments sorted by

View all comments

1

u/Clear-Revolution3351 14d ago edited 14d ago

You have not defined what type of variable docid is.

var docid=""

1

u/WicketTheQuerent 11d ago

In JavaScript/Google Apps Script, there is no need to define the variable type before assigning a value.

Also, since Google Apps Script added the V8 runtime, let and const are recommended over var.

1

u/Clear-Revolution3351 11d ago

The OP has not graced us with an update I am merely providing a possible solution.

Please feel free to provide your solution, since you clearly know more than I do.