Empty Cells and Null Values in Datastores
An empty cell has nothing in it. A null value represents a reference that points, generally intentionally, to a nonexistent or invalid object or address. Following is how Studio deals with empty cells and null values in datastores dependent on the data type.
Data Type |
Description |
---|---|
String |
To enter a null value in the cell, type NULL. If the cell is empty, the value is empty to allow for is empty and is not empty filter conditions. |
Integer Double Date DateTime |
If the cell is empty, its value is treated as null. |
Audio |
If the cell is empty, the value is empty to allow for is empty and is not empty filter conditions. |
Boolean
|
If the cell is empty, its value is treated as false. |