EMPTY() : return an empty value

The EMPTY() function inserts a null value in a TimeTonic formula, exactly like "" in a spreadsheet.

Syntax

EMPTY( value )
EMPTY()

Parameters

# Parameter Description

1 value (optional) Field or expression to test in the “test for empty” usage. Without an argument, EMPTY() directly imposes a null value as the result.

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()

Function	Usage
EMPTY()	used to insert an empty value.
IS_EMPTY()	used to test whether a field's content is empty.

Go further

IS_EMPTY()

The function to test whether a field's content is empty, whatever its type.

Read more →

Or continue with

Formula glossary

All available operators and functions, sorted by category.