Description
The ISBLANK function checks whether a specified value is blank (i.e., empty or null) and returns TRUE if it is blank; otherwise, it returns FALSE.
Usage
This function is used to determine if a value is blank.
Syntax:ISBLANK(value)
Examples
-
Check if a Date Field is Blank:
ISBLANK(#[Start Date])Checks if the Start Date field is blank. Returns TRUE if the Start Date is empty or null; otherwise, it returns FALSE.
-
Check if an Email Field is Blank in a Linked Record:
ISBLANK(#[Employee].[Email])Checks if the Email field in the linked Employee record is blank. Returns TRUE if the email is empty or null; otherwise, it returns FALSE.
-
Check if a Tracking Number is Blank:
ISBLANK(#[Order].[Tracking Number])Checks if the Tracking Number field in the linked Order record is blank. Returns TRUE if the tracking number is empty or null; otherwise, it returns FALSE.
Inputs
| Argument | Data Type | Description |
|---|---|---|
| value | Date, Email, Number, Text, URL, Document | The value to check for being blank. |
Returns
Type: Boolean
- Produces TRUE if the specified value is blank or null, and FALSE otherwise.