title: Testing a range for X in GAS
body: <p>I have a form where I'm taking reservations for a range of speaking events held over multiple days.  I am trying to get it to email me when one of the days in this range reaches room capacity.  I'm measuring capacity in a cell which is FALSE until it reaches capacity then goes TRUE.</p>
  
  <p>My variable on the capacity test is </p>
  
  <pre><code>var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("counts");
  var currentValue = sheet.getRange("D2:D13").getValues();
  Logger.log('currentValue = '+currentValue)
  </code></pre>
  
  <p>This returns in the log, currentValue = false,false,false,false,false,false,false,false,false,false,false,false</p>
  
  <p>I have a line in my script which is supposed to trigger an email that says.</p>
  
  <pre><code>if (currentValue = "true")
  </code></pre>
  
  <p>I've tried all kinds of combinations in this line.  Currently as is, it emails everytime someone submits a reservation.  :)</p>
  
  <p>What should my "if" syntax be so it only emails when there is a "true" somewhere in the currentValue range?</p>
  
  <p>Thanks for any help you can lend me.  Dave</p>