In all of the demos in the docs, cells that need to use validation functions like IsNumber, Len, etc. are done on a cell-by-cell manor like this:
{
dataType:
"custom"
,
from:
"AND(ISNUMBER(G2),LEN(G2)<6)"
,
type:
"warning"
,
allowNulls:
true
,
titleTemplate:
"Invalid Item"
,
messageTemplate:
"Value must be a number and 5 characters or less"
}
Is there any way to do this type of thing for a range of cells? I'm looking for something similar to this by replacing "CurrentCell" with something:
var
range = spreadsheet.activeSheet().range(
"G2:G100"
);
range.validation({
dataType:
"custom"
,
from:
"AND(ISNUMBER(CurrentCell),LEN(CurrentCell)<6)"
,
type:
"warning"
,
allowNulls:
true
,
titleTemplate:
"Invalid Item"
,
messageTemplate:
"Value must be a number and 5 characters or less"
});