Multiple conditions

Hello,

In javascript the logical operators that represent the “AND” and “OR”, are the double symbols: “&&” and “||” respectively. So, if you want to return a number, for example: 1234, if the values of fields: fieldname1, and fieldname2 are 2 and 3, respectively, and the number 4321 in other cases, a possible equation would be:

(function(){
if(fieldname1>2 && fieldname3>3) return 1234;
else return 4321;
})()

For simple equations like the previous one, you can use directly the ternary operator of javascript:

(fieldname1>2 && fieldname3>3) ? 1234 : 4321

or the “IF” and “AND” operations distributed with the plugin:

IF(AND(fieldname1>2, fieldname3>3), 1234, 4321)

Note that javascript is a case sensitive language, please, do not confuse the conditional statement “if” in javascript, with the “IF” operation distributed with the plugin.

More information in the following link:

http://cff.dwbooster.com/documentation#conditions-module

Best regards.

Hello @jalexanderphd,

You simply should insert a “Calculated Field” in the form, and enter the equation through the textarea “Set Equation” in its properties (the properties are displayed in the left bar)

Best regards.

Hello @jalexanderphd,

Yes, you are right, enter the equation’s code directly into the “Set Equation” property, but remember, depending on your equation’s structure you might need to implement it with the function structure, using “return” statements:

(function(){
if(fieldname1>2 && fieldname3>3) return 1234;
else return 4321;
})()

or if the equation is simple, use the “IF” operation or the ternary javascript operator directly:

IF(AND(fieldname1>2, fieldname3>3), 1234, 4321)

Best regards.

Hello @jalexanderphd,

Please, check the documentation of the operations (http://cff.dwbooster.com/documentation#conditions-module). The “IF” operation only accepts three parameters, the additional parameters are ignored:

IF(condition, result if condition true, result if condition false)

but you can nesting “IF” operations, as follows:

IF(condition, result if condition true, IF(second condition, result if second condition true, result if second condition false))

Best regards.