calculated fields if calculated field…

Hi,

If you configure a calculated field as hidden, it will be represented with an input tag whose “type” attribute will have the value “hidden”, but the input tags with type=”hidden” cannot be set as visible with dependencies.

Please, untick the checkbox that makes the second calculated field as hidden, and assign to it the special class: hide, through the attribute: “Add Css Layout Keywords”, in this case the dependency rule will show or hide the field if the first calculated field satisfies the condition or not respectively.

Best regards.

is it possible to append value of that calculated field if calculated field satisfies condition?

Hi,

In this case you should use a conditional statement in the equation. For example, suppose your current equation is fieldname1+fieldname2, and you want add to the result the number 30, but only if the value of the fieldname3 is bigger than 100, in this case the equation may be any of following variants:

(function(){
var r = fieldname1+fieldname2;
if(fieldname3 > 100) r += 30;
return r;
})()

Second variant:

fieldname1+fieldname2+((fieldname3>100)?30:0)

Third variant:

fieldname1+fieldname2+IF(fieldname3>100,30,0)

The previous case is hypothetical but you can use a similar logic in your equation.

Best regards.

Hi, to better understand what i need, i have code:

fieldname20 = fieldname2 * 10;

fieldname4 = (fieldname6 * 1)+(fieldname7 * 1)+(fieldname8 * 1)+(fieldname9 * 0,5)+(fieldname10 * 1,5)+(fieldname11 * 1)+(fieldname12 * 10)+(fieldname13 * 3)+(fieldname14 * 3)+(fieldname15 * 1,5);

        if(fieldname4 > 39)
        { fieldname4 = fieldname20 + fieldname4;}
        if(fieldname4 <= 39 && fieldname4 != 0)
        { fieldname4 = fieldname20 + 39;}
        if(fieldname4 > 0 && fieldname4 <= 0)
        { fieldname4= fieldname20 + 29;}
        if(fieldname4 = 0)
        { fieldname4 = 0;}

can i do all these statments in fieldname4 equation?

Hi,

Not really, you cannot assign values to other fields using its field names (fieldname#) because the plugin replaces all texts with the structure fieldname# by the corresponding values before evaluate the equations.

Furthermore in javascript the symbol to represent decimal numbers is the dot (.), not the comma (,), the symbol for equality is “==” because the symbol “=” is used for assignment, and the condition below is incorrect because a number cannot be less and bigger than zero at the same time:

if(fieldname4 > 0 && fieldname4 <= 0)

I guess the fieldname20 is a calculated field, so, its equation is simply:

fieldname2*10

and I guess that fieldname4 is another calculated field, and its equation would be (you cannot use the same field you are evaluating in its equation):

(function(){
var r = fieldname6+fieldname7+fieldname8+fieldname9*0.5+fieldname10*1.5+fieldname11+fieldname12*10+fieldname13*3+fieldname14*3+fieldname15*1.5;

if(39 < r) return r+fieldname20;
if(r <= 39 && r != 0) return fieldname20+39;
if(r == 0) return 0;
})()

I’m sorry, but the support service does not includes the implementation of the users equations, if you are needing additional help, please, do not hesitate in request a custom coding service through my personal website:

https://cff.dwbooster.com/customization

Best regards.

Yes. Thanks for all the help and effort to solve my problem:-) it really works!