If then

Hello @rphrus,

Thank you very much for using our plugin.

Your equation can be implemented as follows:

IF(50<fieldname1+30, 20-fieldname1, fieldname1+30)

Note you said subtract the calculated value from 50. So, the second parameters is 20-fieldname1 because:

50 – (fieldname1+30) = 50 – fieldname1 – 30 = 20 – fieldname1

If you want to subtract 50 from the calculated value, the equation would be:

IF(50<fieldname1+30, fieldname1-20, fieldname1+30)

In this case, the second parameter is: (fieldname1+30)-50 = fieldname1-20

Best regards.

Hi,

How can I prevent the calculation from displaying the result when I have not entered a number on fieldname1 yet?

Thank you

• This reply was modified 12 months ago by rphrus.

Hello @rphrus

Assuming you have the mathematical operation fieldname1+fieldname2 and want to evaluate the mathematical operation when the user has filled in both fields. By default, the plugin preprocesses the fields’ values to use them in mathematical operations. When the fields’ values are empty, the equation result will be zero.

So, you can edit the equation as follows:

IF(AND(fieldname1|r != '', fieldname2 != ''), fieldname1+fieldname2, '')

Note I checked the fields’ values with the |r modifier. I’m telling the plugin:

If the raw values (without preprocessing) of fields fieldname1 and fieldname2 are different from the empty text, evaluate the mathematical operation or return empty text otherwise.

Best regards.

Thank you for taking the time to answer my question. My fieldname1 is an input number and fieldname2 is a calculated value field. So, how would this work?

Hello @rphrus,

The process is just the same as described previously. You should check the raw fields’ values and evaluate the mathematical operations if the condition is satisfied.

Best regards.

Thank you!

• This reply was modified 12 months ago by rphrus.