The HasValue()
function checks whether a value is not empty, and returns true
if value is not empty.
Syntax
HasValue(value)
Returns
A boolean value that indicicating if a value is not empty.
Note: The IsEmpty() function checks the opposite of this function.
Parameters
value
– any value
If the value is a list, then the IsEmpty
function checks if the list has at least 1 row.
Examples
HasValue("The world's greatest") /* true */
HasValue("") /* false */
HasValue(UnknownText) /* false */
HasValue(3) /* true */
HasValue([List]) /* true is the list has rows and false if the list has 0 rows */
HasValue([Name] of [Products]) /* true is the list has rows and false if the list has 0 rows */