The EMPTY() function inserts a null value in a TimeTonic formula, exactly like "" in a spreadsheet.
Syntax
EMPTY( value )
EMPTY()
Parameters
Examples
Test if a field is empty
EMPTY() checks whether a value is empty and returns true or false.
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.
Invoice_Amount > 1000 ? "Large invoice" , EMPTY()
→ Result: if the invoice amount exceeds 1000, the formula returns the text Large invoice, otherwise the formula field stays empty.
Telling it apart from IS_EMPTY()
Go further
IS_EMPTY()
The function to test whether a field's content is empty, whatever its type.
Or continue with
Formula glossary
All available operators and functions, sorted by category.