Support » Plugin: Calculated Fields Form » Having problems with function

  • Resolved nonconformistdoc

    (@nonconformistdoc)


    (function(){
    if(fieldname3 < 1 && fieldname3 >= 0){
    return 0;
    }else if(fieldname3 >= 1 && fieldname3 < 50){
    return 1;
    }
    }else if(fieldname3 >= 50 && fieldname3 < 76){
    return 2;
    }
    }else if(fieldname3 >= 76 && fieldname3 < 90){
    return 3;
    }
    }else if(fieldname3 > 90){
    return 4;
    }
    })()

    tried to run this code for fieldform cSBP but im not able to get back any output

    I ran a similar function on another calculated form fieldname cAGE and it ran no problem
    (function(){
    if(fieldname2 < 55 && fieldname2 >= 0){
    return 0;
    }else if(fieldname2 >= 55){
    return 1;
    }
    })()

    can you help me with this please?
    any typing error?

    fieldname2 = Age
    fieldname3 = Systolic Blood Pressure

Viewing 9 replies - 1 through 9 (of 9 total)
  • i also used the switch function for fieldform cSBP but no return as well

    sorry new to coding here.

    Also another question, why does the fieldform cAGE has 0 pre-filled. I want to remove that because that field will be used as input for another calculation and I dont want wrong calculation to happen because of that

    Plugin Author codepeople

    (@codepeople)

    Hi,

    You’ve included many additional “}” symbols, the correct would be:

    (function(){
    if(fieldname3 < 1 && fieldname3 >= 0){
    return 0;
    }else if(fieldname3 >= 1 && fieldname3 < 50){
    return 1;
    }else if(fieldname3 >= 50 && fieldname3 < 76){
    return 2;
    }else if(fieldname3 >= 76 && fieldname3 < 90){
    return 3;
    }else if(fieldname3 > 90){
    return 4;
    }
    })()

    About your second question, the calculated fields are pre-filled with zero, because the equations are evaluated by default. You can deactivate the dynamic evaluation of the equations through the “Form Settings” tab, and then, insert a button field in the form, with “Calculate” as the button’s type.

    Another solution is to use a conditional statement in the equation for checking if the initial conditions are valids, for example, suppose you have the equation: fieldname1/fieldname2, and you want evaluate the equation if the values of fieldname1 and fieldname2 are different to zero. You simply should modify the equation as follows:

    IF( AND(fieldname1,fieldname2), fieldname1/fieldname2, '' )

    Best regards.

    Hi thanks for your fast response. Sorted the 1st problem

    zero is a possible entry.
    I just dont want the default value to be zero.
    Can null and zero be different, not the same value?

    i tried to put in if formfieldx is null, return “Please fill in” but didnt work

    if i turn off the dynamic evaluation it still doesnt solve the problem of
    null =/= 0

    i have an “x” field that is not necessary, but feeds into a formula as an addition. Without the “x” field the formula is void, but mathematically it is not because it is just an addition

    Plugin Author codepeople

    (@codepeople)

    Hi,

    The fields without values are considered as zero to prevent javascript errors, a solution would be assigning class names to the fields, and check them by their class names (the class names are assigned to the fields through the attribute: “Add Css Layout Keywords”).

    For example, returning to the previous example, I assign the class name: firstclass to the fieldname1, and secondclass to the fieldname2, and modify the equation as follows:

    IF(AND(jQuery('.firstname input').val() != "", jQuery('.secondname input').val() != ""), fieldname1/fieldname2, '')

    and that’s all.

    Hi, sorry I still cant figure it out,

    my fieldform that is calculated is this:
    fieldname21=


    (function(){
    if(fieldname19 == 1){
    return 1/(1+exp(-((-0.4499)+(0.8085*fieldname20)-(0.0835*fieldname6)-(1.743*fieldname1))));
    }else if(fieldname19 == 2){
    return 1/(1+exp(-((-2.5355)+(0.9934*fieldname20)-(0.0651*fieldname6)-(1.136*fieldname1))));
    }
    })()

    the fieldform that should if blank, fieldform21 is void, is fieldname6

    i tried modifying your equation of
    IF( AND(fieldname1,fieldname2), fieldname1/fieldname2, ” )

    but because i already have an if,if else condition of
    if(fieldname19 == 1){
    return 1/(1+exp(-((-0.4499)+(0.8085*fieldname20)-(0.0835*fieldname6)-(1.743*fieldname1))));
    }else if(fieldname19 == 2){
    return 1/(1+exp(-((-2.5355)+(0.9934*fieldname20)-(0.0651*fieldname6)-(1.136*fieldname1))));
    }

    sorry very new

    Plugin Author codepeople

    (@codepeople)

    Hi,

    To be sure that the fieldname6 field is not blank, follows the steps below:

    1. Assign a class name to the fieldname6 field, for example: myclass,
    2. Now, modifies the equation as follows:

    (function(){
    if(jQuery('.myclass input').val() == '') return '';
    
    if(fieldname19 == 1){
    return 1/(1+exp(-((-0.4499)+(0.8085*fieldname20)-(0.0835*fieldname6)-(1.743*fieldname1))));
    }else if(fieldname19 == 2){
    return 1/(1+exp(-((-2.5355)+(0.9934*fieldname20)-(0.0651*fieldname6)-(1.136*fieldname1))));
    }
    })()

    and that’s all.
    The first line into the equation, checks if fieldname6 is empty, in whose case returns an empty text too.

    Best regards.

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Having problems with function’ is closed to new replies.