The EMPTY() function allows you to check if a value is empty or null in a column or field. It is commonly used in databases to test whether a cell contain"s data or not. If the value is empty, the function returns "true"; otherwise, it returns "false".
➡️ Display Name:
➡️ Syntax :
Value: This is the data or value you want to check.
➡️ Example:
➡️ Result:
The function will return "true" if the Name column is empty, otherwise it will return "false".
Make the Distinction
- EMPTY() is mostly used to check individual fields or values in a database or spreadsheet.
- IS_EMPTY() is better suited to check if more complex data structures, like lists or arrays, are empty.
-
📊 Direct Comparison:
Function Usage Tested On Result EMPTY() Check if a field is empty Field, simple column true/false depending on if the field is empty IS_EMPTY() Check if an object or list is empty Lists, datasets, objects true/false depending on if the object is empty
Depending on the nature of your data (simple field or dataset), you will use one or the other to ensure that your empty value tests are accurate.
📝 Tip: For visibility in the form of a check box ☑️ of the result of your condition, choose the “Boolean” output format in the “option” menu of the column
1 = will return check ☑️
0 = will return unchecked ☐
Before Starting
To Start with Formulas
New formulas in Timetonic allow you to transform, calculate, and manipulate the information stored in your columns by combining multiple functions...
Or Continue With
Glossary View of Formulas
Quickly find the function or operator you are looking for or simply discover and learn how to use them…