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…)?

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 🙂

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

Hahaa, thank you 🙂

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?

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 8 years ago by Alwin.

That worked; thanks!