Calculations Tutorial

Viewing 2 reply threads
  • Author
    Posts
  • December 6, 2020 at 9:18 PM #42801

    andy bush
    Participant

    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.

    December 7, 2020 at 2:09 AM #42803

    Brendan
    Keymaster

    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 1 year, 3 months ago by Brendan.
    December 7, 2020 at 3:27 AM #42804

    andy bush
    Participant

    Exactly what I Was looking for. Thanks!

Viewing 2 reply threads

You must be logged in to reply to this topic.