[March 25, 2014] Reformat formulas that use "null" and user input control component

The release planned for Thursday, March 27 will correct an issue which may have an impact on formulas that are currently using a work around. If you've built a formula to compare for "null" as related to a Drop-Down List or Text Field in the user input control component, you will need to change your formulas to compare to an empty string.

For example, previously, leaving the user input control blank would be sending "null" and would not display any results as if you were looking for a literal string "null" in a dataset. In the next release, if left blank, the input control will send "".

Some additional examples from the following images.

Currently, the CONTAINS function will evaluate to "false" when the text input field that sets the variable "abc" is set to "null" and no data from column D will be displayed in the Klip. In the next release, the CONTAINS function will evaluate to TRUE when the text input field that sets the variable "abc" is set to "" and all the data in column D will be displayed in the Klip.

Currently, to check for an empty value in a variable set from a user input control, you must compare "null" as in the example formula.

In the next release, the formula needs to be changed so that "null" is changed to ""

Feedback and Knowledge Base