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.