ISNOTNULL
Usage
Use this function to check if a value is NOT NULL
| Category | Function | Type | Where to use | Argument statement |
|---|---|---|---|---|
| FUNCTION | SERVER ROW | COMPARISON | .VALUE |
Syntax
1 | |
Arguments
Value
any cell value (#Storage_Name.Field_Name.VALUE or .OLDVALUE), constant, System Variables or function-returned value
Notes
This function is mainly used as argument in SERVER ROW function such as IF, AND, OR. It can be used also in CLIENT FUNCTION function such CELLIF, CELLAND, CELLOR if the .VALUE argument is not depending on record's fields value
Return Value
Boolean (true or false)
Examples
Example 1
Formula
=IF(=ISNOTNULL(#StorageExample.Column.VALUE); 1; 0)
Description
If the cell values of the field Column in the StorageExample is not null, then put 1 in the cell of the field where there's the formula, else 0
Result
0 or 1
Example 2
Formula
=IF(=ISNULL(#StorageExample.Column.METADATA); "green"; "red")
Description
We preformed this formula in the Layout Cell Background Color of a field. So if the cell values of the field Column in the StorageExample is not null, color the cell green, else red
Result
green or red