How to set multiple equations in form

  • Resolved Hemantl7707

    (@hemantl7707)


    7 years, 11 months ago

    Hello,

    I want to set multiple equations on single form?

    Below equations I want to execute –

    fieldname2*fieldname3*fieldname5;
    fieldname11*fieldname5

Viewing 1 replies (of 1 total)
  • Plugin Author codepeople

    (@codepeople)

    Hello,

    If you need apply an equation or other depending of a condition, then, you would not inserting two equations (it is not possible to include two separated equations because it is not possible to know when to apply each of them), you are defining only one equation but evaluating an operation or the other.

    Ok, I will try to explain the process with an example, I will assume do you want evaluate the operation: fieldname2*fieldname3*fieldname5 only if fieldname2 and fieldname3 are different to zero, and evaluate the operation: fieldname11*fieldname5 in other cases.

    In this case the equation can be implemented as any of alternatives below:

    – Using the ternary operator of javascript:

    (AND(fieldname2,fieldname3)) ? fieldname2*fieldname3*fieldname5 : fieldname11*fieldname5

    – Using the “IF” operation included by the plugin:

    IF(AND(fieldname2,fieldname3), fieldname2*fieldname3*fieldname5, fieldname11*fieldname5)

    – With the conditional statement “if” of javascript:

    (function(){
if(AND(fieldname2,fieldname3)) return fieldname2*fieldname3*fieldname5;
return fieldname11*fieldname5;
})()

    Best regards.

Viewing 1 replies (of 1 total)
  • The topic ‘How to set multiple equations in form’ is closed to new replies.