Alwin

That worked; thank you very much!

Now I would like to add 2 final things.

First:

If the value/number of fieldname2 or fieldname41 or fieldname43 or fieldname44 is above 50 then a warning should be displayed in the Calculated field (instead of the calculated number).

For this I came up with this code:

IF(AND(50>=fieldname2,50>=fieldname41,50>=fieldname43,
PREC(MAX(10.20,(fieldname6+fieldname42+fieldname43)*0.34+3.40),2), ‘Warning text’)

Is this correct?

Second:
If the value/number of fieldname2 or fieldname41 or fieldname43 or fieldname44 is above 50 then the warning text should be displayed (like above) BUT the calculation should NOT be performend OR the result of the calculation should be 0 (zero).

With calculation I mean this part:
PREC(MAX(10.20,(fieldname6+fieldname42+fieldname43)*0.34+3.40),2)

Is the second thing possible too?

Thank you.

Regards,
Alwin

The link where the form is build is:
https://loeka.optiion.nl/printen/

The problem in this case is: from the 3 fieldnames 6,41 and 43 only one fieldname is actually used at a time.

The other two fieldnames that are not used are set up with Predefined Value of 0 (zero).

So the first thing to do in this form is make a choice in the first Radio Buttons box:
– Liggend (landscape)
– Staand (portrait)
– Vierkant

Now when the first option is selected then fieldname6 is displayed and fieldname41 and fieldname43 are not displayed.

When the second option is selected then fieldname41 is displayed and fieldname6 and fieldname43 are not displayed.

When the third option is selected then fieldname43 is displayed and fieldname6 and fieldname41 are not displayed.

So let’s asume the first option is selected and the value of fieldname6 will be 40, and fieldname41 and 43 are both the Predefined Value of 0.

Then 40+0+0 is 40 right?

Hahaa, thank you ??

Thank you!

With these 2 options there are no price calculatons at all anymore…

I think the best solution for this problem is that ask for Custom Coding Service?

Okay, I think this code is not the solution I am after. Because it hides fieldname16 al the time and fieldname16 is the field that is showing the “total price” at the bottom of my form, so it is very important.

Maybe there is one other solution:

This is the code I am still using now:

IF(AND(100>=fieldname2,200>=fieldname6,200>=fieldname41,100>=fieldname42,100>=fieldname43,100>=fieldname44),
PREC(MAX(3.9,fieldname40*0.60+2.70),2), ‘Maximale maat Polystyreen is 100×200 cm’)

So when one of the fieldnames meets one of the conditions, then the warning text ‘Maximale maat Polystyreen is 100×200 cm’ is displayed, which is good!

But the calculation PREC(MAX(3.9,fieldname40*0.60+2.70),2) is also still performend and the result of this calculation is added up to the “total price” field.

So maybe it is possible that when one of the conditions is activated that the calculation is not performend. Or that the value of the calculated field is just zero?

Is that possible?

Okay, I have added these code in the “Set Equation” field of the Calculated field but now I have one new problem:

This code seems to be working in other (calculated) fields in the form too?

I just want this code to work in one specific calculated field and not in all (calculated) fields in the whole form…

Is that possible?

Thank you,
Alwin

That worked (again)!

Your support is absolutely brilliant!

I just bought the Pro version today, mainly just because I want to pay something.. ??

Alwin

• This reply was modified 6 years, 7 months ago by Alwin.

Something like this:

– If fieldname2 and fieldname6 values are above 0 then CEIL(fieldname2*fieldname6/100)
OR
– if fieldname4 and fieldname8 values are above 0 then
CEIL(fieldname4*fieldname8/100)
OR
– if fieldname9 and fieldname11 values are above 0 then
CEIL(fieldname9*fieldname11/100)

That worked; thanks!

I understand. I will also buy the pro version of the plugin now.

Thank you so far with this topic!

Regards,
Alwin

I want to return the warning if (100<=fieldname2 OR (200<=fieldname6

So not AND but OR

Hope you understandf now ??

Alwin

That works; great!

Now I like to add 1 more thing:

I now have this rule: IF(100<=fieldname2

I also like to add a second one: IF(200<=fieldname6

How can I add this one to the equation?

Thank you very much for your help! However, this is not going to work for me. I think I did not explain very good what I want. I will try again:

I am using a Calculated field with this Equation:
PREC(MAX(3.9,fieldname7*0.60+2.70),2)
In my Form this Calculated field is “fieldname13”.

Then I am using antoher field, called “fieldname2” which is a Number field.

Now when the value in fieldname2 is above 100, then I would like to display a warning in the fieldname13.

In other words: when the value in fieldname2 is above 100 then fieldname13 should display a warning.

Is that possible?

Hello, thank you!

I have added a “HTML content” field with this code but now 200 is the max value for all number fields. That’s not what I am after at.

It is difficult to explain, maybe you can take a look at the form here:
https://loeka.optiion.nl/printen/

Now in the first 2 (number) fields there are max values settings:
– the max for “Verticaal in cm” is 111 cm
– the max for “Horizontaal in cm” is 300 cm

When I higer value is entered a warning is displayed. So far so good…

But then please look at these checkbox fields:

-Polystyreen 1mm (maximaal 100×200 cm)
-Polystyreen 2mm (maximaal 100×200 cm)
-Polystyreen 3mm (maximaal 100×200 cm)

When one of these options is selected in the checkbox then I would like to display a warning when the field “Verticaal in cm” is a higher value then 100 or/and the field
“Horizontaal in cm” is a higher value then 200.

So bisicly the fields “Verticaal in cm” and “Horizontaal in cm” have a max value setting in the field setting itself, but I would like to use other max settings in other places in the form.

I hope you understand my question; thank you very much in advance for your help!

Regards,
Alwin

Thank you very much; that worked fine!

I do have another question but will start a new topic for that one ??