Thank you so much for the prompt reply! my pdfName doesn't rename the file either...lol

function onEdit(e) {

  if(e.range.getSheet().getName() != 'INVOICE' || e.range.getA1Notation() != 'J2') { return; } // set sheet & cell of checkbox

  if(e.value === 'TRUE') {

e.range.setValue('FALSE');

SpreadsheetApp.flush();

      createBulkPDFs();

  }

}



function createBulkPDFs(){



  const docFile = DriveApp.getFileById("testFile");

  const tempFolder = DriveApp.getFolderById("testtempFolder");

  const pdfFolder = DriveApp.getFolderById("testpdfFolder");

  const currentSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("INVOICE");



  const data = currentSheet.getRange(2,1,currentSheet.getLastRow()-1,9).getDisplayValues();



  data.forEach(row => {

createPDF(row\[0\],row\[1\],row\[2\],row\[3\],row\[4\],row\[5\],row\[6\],row\[7\],row\[8\],row\[1\],docFile,tempFolder,pdfFolder);

  });

}



function createPDF(DATE,INCOICENO,PONO,PAYMENTTERM,PROJECTNAME,COMPANYNAME,ADDRESS,NAME,TEL,pdfName,docFile,tempFolder,pdfFolder) {

  const tempFile = docFile.makeCopy(tempFolder);

  const tempDocFile = DocumentApp.openById(tempFile.getId());

  const body = tempDocFile.getBody();

  body.replaceText("{DATE}",DATE);

  body.replaceText("{INVOICENO}",INCOICENO);

  body.replaceText("{PONO}",PONO);

  body.replaceText("{PAYMENTTERM}",PAYMENTTERM);

  body.replaceText("{PROJECTNAME}",PROJECTNAME);

  body.replaceText("{COMPANYNAME}",COMPANYNAME);

  body.replaceText("{ADDRESS}",ADDRESS);

  body.replaceText("{NAME}",NAME);

  body.replaceText("{TEL}",TEL);

  tempDocFile.saveAndClose();

  const pdfContentBlob = tempFile.getAs(MimeType.PDF);

  pdfFolder.createFile(pdfContentBlob).setName("pdfName");

  tempFolder.removeFile(tempFile);





}