About Type Conversions
In certain contexts, values from one data type can be converted to another data type, either implicitly or explicitly.
An implicit conversion occurs when the expected type of an expression does not match the actual type.
The text values of true and false (case insensitive) can be used for setting the value of Boolean fields, when enclosed in single or double quotes.
The text values of n (where n represents an integer or decimal value, and can be positive or negative), can be used for setting the value of logical fields, when enclosed in single or double quotes. If n is 0, the corresponding Boolean value is false; otherwise, all other values of n correspond to a Boolean value of true.
The application drops the currency code. Any non-zero number is converted to true and zero is converted to false.
Any non-zero number is converted to true and zero is converted to false.
Text values representing the date only or representing date and time values, can be implicitly converted to the corresponding DateTime value.
Integer values can be implicitly converted to float values, but not vice versa. (If you convert a float value to an integer value, you lose the part after the decimal, which is not a proper conversion.)
The Boolean values of true and false (case insensitive) can be used for setting the value of number fields. Upon evaluation, the true and false values are converted to 1 and 0, respectively.
Boolean values, however, cannot be implicitly converted to number values, when used in arithmetic contexts (for example, adding a number value to true), or in relational contexts (for example, comparing a number value to true).
There is no implicit conversion of text values to number values.
For arithmetic operations, if one operand is a text value, and the other operand is a number value, the number value is converted to a text value, but the text value is not converted to a number value. At this point, only the plus (+) operator (in this context, for text concatenation) works properly; evaluation fails for all other available arithmetic operators (such as multiply [*] and divide [%]).
For example, $("20" + "30") can be either a text value of 2030 if you concatenate the two fields, or it can be a number value of 50 if the fields are converted from text to number. The application tries the concatenation first.
Similarly, for relational comparisons, if one operand is a text value, and the other operand is a number value, the number value is converted to a text value, but the text value is not converted to a number value. At this point, the values are compared lexicographically instead of numerically.
For example, $(30 < "200") can have two interpretations. In one interpretation, the application converts 200 to a number; 30 is less than 200, so it returns true. In the other interpretation, the application converts 200 to a number and compares 200 to 30 lexicographically and returns false because 200 comes before 30 lexicographically.
Boolean, DateTime, number, and currency values can be implicitly converted to text values.
For Boolean values, true and false are converted to the text values "true" and "false", respectively (case insensitive).
Here are examples where the Boolean value is used, in the context of text concatenation (here, TestText1 is a text field, whereas TestBool1 is a Boolean field):
$("Did the user answer all the questions: " + false)
$("Did the user answer all the questions: " + TestBool1)
$(TestText1 + TestBool1)
DateTime values are converted to a text value in the DateTime format of the current locale.
If you need a text value and you pass a number value, the application converts it to a text value.
Here are examples where the number value is used in the context of text concatenation. Here, TestText1 and TestText2 are text fields, whereas TestNumber is a number field.
$("There are >" + 3 + " blind mice")
$("There are " + 3.28 + TestText1 )
$(TestText1 + TestNumber + TestText2)
If you need a text value and you pass a currency value, the application converts it to a text value.
Here is an example where the currency value is used in the context of text concatenation.
$("Julie won" + 200 USD + " in the lottery.")
You can convert a number to a currency value when it is used with a currency value in a binary operator or in another context where a currency value is required. For example, in $(currency_field + number_field), the number_field parameter is treated as a currency value with the same currency as the currency_field parameter. In the example $(100USD + 46) , the application treats 46 as a USD value and the result is 146USD.
When a number field is used when a currency is needed, for example to pass to a currency function, the application treats it as a currency with the default currency value of the tenant. For example, $(Currency(20)) means 20 of the default currency for the tenant.