The logical operators
OR have been added to the formulas language. This will allow for writing more readable and expressive formulas:
// old way IF(AND(foo, bar), "foo and bar were true") IF(OR(foo, bar), "either foo or bar were true") // new way IF(foo AND bar, "foo and bar were true") IF(foo OR bar, "either foo or bar were true")
The operators may also be written as
|| for those more used to this style from other languages.
// old way DEFAULT(maybe_null_value, "value if null") // new way maybe_null_value || "value if null"