Google Sheets - Script - Condition if a range is empty

Question

I would like to put a condition if a range of cells is empty. All the cells must be strictly empty. So I tried this :

if ( bottomcolumn.getValues() == '') {

(upcolumn is a variable range i created)

It does'nt work. I think i didn't well understand the google user guide... Any ideas ?

Thank you for reading...

Answer 1

try do see what bottomcolumn.getValues() actually returns and then work from there, I assume it may be null or undefined.

So do this to understand what it outputs:

console.log( bottomcolumn.getValues() ) 

and then for your condition just check if it is a falsy value, such as 0, null, undefined, empty string, etc…:

if( !bottomcolumn ){
  // do something
}