{!IsNull(value)}
Returns True if the value is null, else False.
Ex. {!IsNull("Name")} Returns True if the Name field is empty, else False.
{!HasValue(value)}
Returns True if the value is not null, else False.
Ex. {!HasValue("PhoneNumber")} Returns True if the Phone Number field has a value, else False.
{!NullValue(expression,substitute)}
Returns the item if the item is not blank otherwise it will return the substitute.
Ex. {!NullValue("Name","Anonymous")} Returns the value of the Name field, or returns Anonymous if Name field is empty.
{!IsInRole("role")}
Returns True if the current user is assigned the security role specified in the string role, else False.
Ex. {!IsInRole("Administrator")} Returns True if the current user is assigned the Administrator, else False.
{!Equal(value1,value2)}
Returns True if value1 and value2 are equal, else False.
Ex. {!Equal(ProductPrice,50)} Returns True if the Product Price field has a value equal to 50, else False.
{!NotEqual(value1,value2)}
Returns True if value1 and value2 are not equal, else False.
Ex. {!NotEqual(ProductPrice,50)} Returns True if the Product Price field does not have a value equal to 50, else False.
{!LessThan(value1,value2)}
Returns True if value1 is less than value2, else False.
Ex. {!LessThan(ProductPrice,50)} Returns True if the Product Price field has a value less than 50, else False.
{!LessThanOrEqual(value1,value2)}
Returns True if value1 is less than or equal to value2, else False.
Ex. {!LessThanOrEqual(ProductPrice,50)} Returns True if the Product Price field has a value less than or equal to 50, else False.
{!MoreThan(value1,value2)}
Returns True if value1 is more than value2, else False.
Ex. {!MoreThan{ProductPrice,50)} Returns True if the Product Price field has a value greater than 50, else False.
{!MoreThanOrEqual(value1,value2)}
Returns True if value1 is more than or equal to value2, else False.
Ex. {!MoreThanOrEqual(ProductPrice,50)} Returns True if the Product Price field has a value greater than or equal to 50, else False.
{!If(expression,trueValue,falseValue)}
Returns trueValue if expression returns True, else falseValue.
Ex. {!If(Equal(Active,"true"),"Complete","Incomplete"))} Returns Complete if the Active checkbox is checked and returns Incomplete if the Active checkbox is not checked.
{!OR(value1,value2,…,valueX)}
Performs an OR operation on the boolean values; returns True if any value is True, else False.
Ex. {!OR(Equal(Active,"true"),Equal(Status,"open"))} Returns True if either the Active checkbox is checked or the Status is open, else False.
{!AND(value1,value2,…,valueX)}
Performs an AND operation on the boolean values; returns True if all values are True, else False.
Ex. {!AND(Equal(Active,"true"),Equal(Status,"open"))} Returns True if the Active checkbox is checked and the Status is open, else False.
{!Not(value)}
Returns the opposite boolean of value (i.e. True if value returns False, else False).
Ex. {!Not(Equal{Active,"true"))} Returns True if the Active checkbox is not checked, else False.
Date and time functions
{!ToUserTime(datetime)}
Converts DateTime value to the user's configured timezone
{!Today()}
Returns today's date as a DateTime value
{!$today}
Returns today's date (UTC), 12:00am
{!$now}
Returns the current UTC date/time
{!AddDays(date,days)}
Adds the value of days to the DateTime value date
{!AddDateTimePart(datetime,"part",value)}
Adds value to the specified DateTime part of the DateTime value datetime; returns the result
Part accepts: years, months, days, hours, minutes, seconds and ticks as values
Ex. {!AddDateTimePart(CreatedOn, "days", 5)} Returns the Created On date plus 5 more days.