The EMPTY() function inserts a null value in a Timetonic formula, exactly like "" in a spreadsheet.
Test if a field is empty
EMPTY() checks whether a value is empty and returns true or false.
Syntax
EMPTY( value )
Example
EMPTY( Name )
→ Returns true if the Name field is empty, false otherwise.
Insert an empty value in a formula
EMPTY() imposes a null value as a conditional result.
Example
Invoice_Amount > 1000 ? "Large invoice" , EMPTY()
→ Result:
If the invoice amount exceeds 1000, the formula returns the text Large invoice, otherwise the formula field is left empty.
Key difference
| Function | Usage |
|---|---|
EMPTY() |
used to insert an empty value. |
IS_EMPTY() |
used to test whether a field's content is empty. |
Tip: checkbox display
In the column options, select the Boolean format to display the result visually:
-
1→ ✅ checked -
0→ ☐ unchecked
Before You Start
Getting Started with Formulas
The new formulas in Timetonic let you transform, calculate, and manipulate the information stored in your columns by combining multiple functions...
Or Continue With
The Formula Glossary view
Quickly find the function or operator you need or simply browse and learn how to use them…