{{link to current DMPR}} - populating with file that should be populating {{link to next OPERA tag up}}

// Helper Function: Get the link of the DMPR file corresponding to a given month
function getDMPRLink(folderId, currentDate) {
  var folder = DriveApp.getFolderById(folderId);
  var files = folder.getFiles();
  var dmprFile = null;
  var dmprFileMonth = currentDate.substring(0, 7);

  while (files.hasNext()) {
    var file = files.next();
    var fileName = file.getName();
    if (fileName.startsWith(dmprFileMonth) && !fileName.includes("Template")) {
      dmprFile = file;
      break;
    }
  }
  return dmprFile ? dmprFile.getUrl() : '';
}

CherrelleTucker / snwg-automation

{{link to current DMPR}} - populating with file that should be populating {{link to next OPERA tag up}} #25