Calculations Tutorial

[andy bush]

Could anyone point me to a comprehensive tutorial on how to use the calculations field? I’m loving Tap Forms but I couldn’t find any “how to’s” on using functions like conditionals and the like.

[Brendan]

Hi Andy,

There is a video that shows the basic usage of the Formula Editor here:

It’s at 5:45 in the above video.

The description of all the functions available are here:

https://www.tapforms.com/help-mac/5.3/en/topic/calculation

There are four conditional functions. There’s IF(), IFEMPTY(), IFNOTEMPTY() and the IFEQUAL().

They all are based on the concept of logic such that if something happens, then do this, otherwise do that.

For example:

IF(Price < 0; 0; Price)

What this means is that if the value of the Price field was less than 0 (negative), then make it 0. Otherwise, just return the Price if it’s 0 or greater than 0.

The other ones work on the same principal.

IFEMPTY(Price; 0; Price)

If the Price value is empty, then return a 0, otherwise return whatever the Price value is.

The IFNOTEMPTY() function is just the opposite:

IFNOTEMPTY(Price; Price; 0)

The IFEQUAL() function is only a little different as it takes 4 parameters and is used for comparing strings rather than numeric values like the basic IF() function.

IFEQUAL(Field A; Field B; "Equal"; "Not Equal")

So in the above, if the value in Field A is equal to the value in Field B, return the text “Equal”, otherwise if they’re not equal, return the text “Not Equal”.

And that’s all there is to it.

Hope that helps!

• This reply was modified 2 years ago by Brendan.

[andy bush]

Exactly what I Was looking for. Thanks!

[Author]

Posts