CODEWITHSUNDEEP
google-apps-scriptgoogle-sheetsgoogle-docs
Kugen
Kugen

Reputation: 39

How to check if the cell is empty, if so skip it

I want to add 1 more line to check if the particular row is empty. If empty I want it to return.

    if (index === 0) return; // this to check header
    if (row[52]) return; // this to check if the row have data. if have it returns.

The full code for this part is below.

function createNewGoogleDocs() {
  //This value should be the id of your document template that we created in the last step
  const googleDocTemplate = DriveApp.getFileById('Google Doc');
  
  //This value should be the id of the folder where you want your completed documents stored
  const destinationFolder = DriveApp.getFolderById('Folder');
  //Here we store the sheet as a variable
  const sheet = SpreadsheetApp
    .getActiveSpreadsheet()
    .getSheetByName('List');
  
  //Now we get all of the values as a 2D array
  const rows = sheet.getDataRange().getValues();
  
  //Start processing each spreadsheet row
  rows.forEach(function(row, index){
    //Here we check if this row is the headers, if so we skip it
    if (index === 0) return;
    //Here we check if a document has already been generated by looking at 'Document Link', if so we skip it
    if (row[52]) return;
    //Using the row data in a template literal, we make a copy of our template document in our destinationFolder
    const copy = googleDocTemplate.makeCopy(`${row[4]} List` , destinationFolder)
    //Once we have the copy, we then open it using the DocumentApp
    const doc = DocumentApp.openById(copy.getId())
    //All of the content lives in the body, so we get that for editing
    const body = doc.getBody();

Upvotes: 0

Views: 3615

Answers (1)

Wicket
Wicket

Reputation: 38131

SpreadsheetApp.Range.getValues() returns an empty string from blank cells, considering this, you might use the following expression:

row[52] === ''

=== is used to compare value and data type. Using == will work too, it only compare value, it relies on JavaScript data type conversion rules. If you aren't familiar with these rules, use ===.

Using just !row[52] as a conditional expression is tricky because when row[52] is equal to '' or equal 0 and when it's undefined this expression returns true.

Related

Upvotes: 2

Related Questions