What does null mean in a formula?
What Is null in a Formula?
Purpose of the Article
This article explains what null means when used in a formula while creating automations for legal documents in the Knackly workspace.
After reading this article, readers should understand how null behaves in formulas and when to use it.
Understanding null in Formulas
In Knackly formulas, null represents the absence of a value.
It means:
- No data has been entered
- No result is available
- The value is intentionally empty
null is different from:
- An empty string (
""), which is a value that contains nothing - Zero (
0), which is a numeric value - False (
false), which is a boolean (either true or false no inbetween) value
How null Is Used in Automations
When building legal document automations, null is commonly used to:
- Prevent language from appearing when information is missing
- Control conditional logic (for example, "if this value exists")
- Avoid errors when optional fields are left blank
For example:
- If a party name is
null, related clauses can be hidden - If a date is
null, the document can omit that reference entirely
Key Takeaways
nullmeans "no value exists"- It helps keep documents clean and accurate
- It is especially useful for optional fields and conditional logic
Using null correctly ensures automated legal documents adapt smoothly to the information provided.