ISBLANK
Use the ISBLANK function check if a value is blank or empty.
Use
ISBLANK( value )
Returns TRUE if the value is blank.
| Parameter | Required | Description |
|---|---|---|
| value | Yes | any type value to test |
| Returns | Logical |
Examples
Mandatory Field Validation
You can use ISBLANK in an Output Validation Formula to ensure that a user does not leave a required field empty before submitting a form. Because ISBLANK returns TRUE when a field is empty, it is commonly paired with the NOT function to create a "Cannot be empty" rule.
- Scenario: A user must provide a "Justification" for a high-value purchase request.
- Formula:
NOT(ISBLANK(this)) - Logic:
this: This keyword refers to the value currently being entered in the "Justification" field.ISBLANK(this): This part returns TRUE if the user has typed nothing.NOT(...): Reverses the result so that the validation formula returns TRUE (Valid) only when the field contains text.
Conditional Form Visibility
In the Form Builder, you can use ISBLANK within Conditional Logic to simplify a form by showing or hiding elements based on whether optional information was provided in a previous step.
- Scenario: A reviewer should only see a "Detailed Instructions" content block if the initial submitter did not provide a "Project Summary" in the trigger form.
- Formula:
ISBLANK(@Trigger.out.ProjectSummary) - Logic:
@Trigger.out.ProjectSummary: This identifies the specific output data captured from the trigger step.Show when: This formula is placed in the "Show when" property of the content block.- Result: If the
ProjectSummaryis empty, the function returns TRUE, and the instructions are displayed to the reviewer to provide extra guidance.