Alwin

Of course ??

Please llok at https://www.fotoloek.nl/test/

The forms called Canvas and Chromaluxe seems to be working okay

The form called Printen is not working okay: please enter some numbers in the fields “Korte zijde foto” and “lange zijde foto” and then choose “Glans?zijdemat in the next checkbox.

Now you see the price for Glans/Zijdemat which is good, but the totalprice (Prijs totaal) is empty.

When you do the same thing on this page: https://www.fotoloek.nl/printen/
you will see that the Total price field is working fine.

I don’t understand because it is the exact same form, using the same page template and of course the same form short-code.

When I delete the forms Canvas and Chromaluxe, then the Print form is working fine. So it seems that all 3 forms running on this 1 page is not possible?

And that worked again!

I hope my rather complex forms (for me) are ready now!

Thank you very much for all your great support so far! I will sure write a great review!!

Regards,
Alwin

That worked great; thank you!

I have one more form with the same issue. I can not simply copy-paste your code in that form because the code of the calculated field is already edited like this:

(function(){
var value = fieldname2*fieldname6/100;
if(5 < value) return CEIL(value);
else return CEIL(value,0.5);
})()

So how can I change this code to do the same trick as with the previous issue?

Thank you!

Regards,
Alwin

That worked! Thank you very much ??

Best regards,
Alwin

Thank you, but something is not working now:

the result of (fieldname2*fieldname6/100) is not displayed anymore in the calculated field where this new equation is active!

Maybe a little thing missing in the code you gavce me?

Thank you, that worked!

However, I have one other equation that need the same rule:

IF(AND(100>=fieldname2,200>=fieldname6),
PREC(MAX(3.9,fieldname40*0.60+2.70),2), ‘Maximale maat 100x200cm’)

So I changend it in:
IF(AND(100>=fieldname2,200>=fieldname6),
PREC(MAX(3.9,fieldname40*0.60+2.70, 0) ,2), ‘Maximale maat 100x200cm’)

But that does not work…

How can i do this?

Thank you,
Alwin

I am sorry, but this is the first time I am doing stuff like this and I find it very difficult…

I appreciate your help very much.. ??

Yoer example: IF(AND(1<=fieldname2,fieldname2<=20), 100, 1000)

When the value is between 1 and 20 I don’t want the result to be 100 but I want to display a warning text

In other cases, when the value is greater then 20, I want to display the result of:
PREC(MAX(27.84,fieldname40*0.46+26.00),2)

Can you help me with that (please…)?

Thank you!

Could it be that I can do it like this:
IF(AND(>1,<20=fieldname2,

to set a “between” number between 1 and 20?

This is where I have a problem with:

IF(AND(20<=fieldname2,20<=fieldname6,20<=fieldname41,20<=fieldname42,
PREC(MAX(27.84,fieldname40*0.46+26.00),2), ‘Warning text’)

So if the number of the fieldname2,fieldname6 or fieldname41 is less then 20 then the warning text should be displayed.

But the problem is that the fields2, 6 and 4 are set up with a Predefined Value of 0 (zero) which has to stay that way.

So to avoid (get around) this Predefined Value of 0 I thought that instead of this:
20<=fieldname2

I would set ip up as “between 1 and 20”.

But something like “1>=fieldname2,20<=fieldname2” is not working. So is there antoher way to do this?

1>OR<20=fieldname2 or something like that?

By the way: I already asked for info about some custom coding too and I will definitely use that service! But it would be great if I could solve this issue too today ??

I will ask for custom coding service this day!

Thank you! ??

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?