Hide minumum value calculated field

  • Resolved Alwin

    (@wp-opti)


    6 years, 1 month ago

    Please take a look at this page:
    https://www.fotoloek.nl/printen/

    – please click “Dibond 2mm”
    – please click “Ophangstrips”

    Now you see 3 new fields called:
    “Hoogte foto in cm” (fieldname 71)
    “Breedte foto in cm” (fieldname 87)
    “Prijs Ophangstrips” (fieldname 33)

    In the calculated field “Prijs Ophangstrips” there is a price displayed of € 10,20. That is because of this equation:

    IF(AND(50>=fieldname71),
    PREC(MAX(10.20,fieldname87*0.34+3.40),2), ‘Maximaal 50cm hoog’)

    So the minumum price is set at 10,20. Also there is 3,40 that is always added to the calculation.

    What I want is that fieldname 33 is dispalying a text and not the minumum price number. Then when fieldname 87 is filled in with a number the calculated price should be displayed.

    Is that possible?

    Thank you,
    Alwin

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

    (@codepeople)

    Hello @wp-opti,

    Yes of course, the solution would be include too the fieldname87 field into the conditional operation, as follows:

    
IF(AND(fieldname71<=50,fieldname87), PREC(MAX(10.20,fieldname87*0.34+3.40),2), 'Maximaal 50cm hoog')

    That’s simple.
    Best regards.

    Thread Starter Alwin

    (@wp-opti)

    That worked, however still 1 problem left…

    The price calculation from fieldname 33 is done with the value entered in fieldnumber 87.

    However, I want the price to be displayed only when fieldname 87 AND fieldname 71 are both filled in with a value!

    So fieldnames 87 and 71 must be filled in both before the price calculation of fieldname 33 is displayed.

    Is that also possible?

    Thank you,
    Alwin

    Plugin Author codepeople

    (@codepeople)

    Hello @wp-opti,

    If you want leave the field’s value in blank if none of these fields have been entered, and then, after populate these fields, to check the value of the fieldname71 field to evaluate the mathematical operation or return the message, you simply should nesting two IF operations:

    
IF(AND(fieldname71,fieldname87), IF(fieldname71<=50, PREC(MAX(10.20,fieldname87*0.34+3.40),2), 'Maximaal 50cm hoog'), '')

    I’m sorry, but it is impossible for me implement all the users’ projects (forms or formulas) as part of the support service. If you need additional help implementing your form’s equations, I can offer you a custom coding service from my private website:

    https://cff.dwbooster.com/customization

    Best regards.

    Thread Starter Alwin

    (@wp-opti)

    It worked; thank you very much ??

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Hide minumum value calculated field’ is closed to new replies.