Default Value

  • Resolved mira404

    (@mira404)


    2 years, 4 months ago

    Hi, In this calculator I use this simple formula: fieldname6+2+fieldname7 but it always shows 2 due to formula +2, how to hide this, if put the input value then only show the calculation result.

    Check this: https://prnt.sc/I_AbaXOmMx3x

    Thanks!

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author codepeople

    (@codepeople)

    Hello @mira404

    Thank you very much for using our plugin.

    Your current equation is fieldname6+2+fieldname7

    If the fields fieldname6 and fieldname7 are empty, their values are handled as zero by the equations. So, the initial equation result would be 0+2+0.

    If you want to evaluate the equation only if the fields’ values are not empty, pelase use conditional operations in the equation as follows:

    IF(AND(fieldname6|r != '', fieldname7|r != ''), fieldname6+2+fieldname7, '')

    Best regards.

    Thread Starter mira404

    (@mira404)

    Thanks a lot! It’s working!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Default Value’ is closed to new replies.