Calculation Field

Tap Forms – Organizer Database App for Mac, iPhone, and iPad › Forums › Using Tap Forms › Calculation Field

Viewing 1 reply thread
  • Author
    Posts
  • November 24, 2009 at 7:46 AM #3030

    Brendan
    Keymaster

    Hey everyone,

    I’m finally getting around to thinking more about a calculation field for a Tap Forms update. I wanted to get your ideas on what you’d like to see. I’ve had everything from basic operators such as * / + – to a full blown language for doing more complex operations. I’d prefer something more simple. One of the things I strive for Tap Forms is to make it easy and fun to use. Having a full-blown language for doing mathematical operations won’t be fun for anyone :-) Plus, the simpler it is, the faster it will be for me to build it.

    But I still wanted to get your opinions. If you could give me some specific examples of how you would use a calculation field in Tap Forms, that will give me a better idea of how it should be implemented.

    Thanks!

    Brendan

    November 26, 2009 at 5:06 AM #3836

    UWS_CIA
    Participant

    Example :

    Supervisory Ah = 0.315 Ah

    0.315 Ah x 24 hrs = 7.56 Ah

    Alarm Ah = 4.6 Ah

    4.6 Ah x 0.5 = 1.52 Ah

    Total = 9.08 Ah

    9.08 Ah * 1.2 = 10.896 Ah

    Round Up = 11 Ah Requirement

    Solution : #1 Separate Fields Per…

    “Field layout”

    Field #1 = Text “Supervisory Ah”

    Field #2 = Num “0.315”

    Field #3 = Text “Supervisory Hrs”

    Field #4 = Num “24”

    Field #5 = Calu “Fields 2 & #4 and return value” calu = X

    Filed #6 = Text “Alarm Ah”

    Field #7 = Num “4.6”

    Filed #8 = Text “Alarm Hrs”

    Field #9 = Num “0.5”

    Field #10 = Calu “Fields #7 & #9 and return value” calu = X

    Field #11 = Text “Total Ah”

    Field #12 = Calu “Fields #5 & #10 and return value” calu = +

    Field #13 = Text “Saftey Margin”

    Field #14 = Num “1.2”

    Field #15 = Calu “Fields #12 & #14 and return value” calu = X & round up

    Solution : #2 Integrated Fields

    “Field layout”

    Calu Field #1 = “Title” = “Supervisory Ah”

    Calu Field #1 = “Value” = “0.315”

    Calu Field #2 = “Title” = “Supervisory Hrs”

    Calu Field #2 = “Value” = “24”

    Calu Field #3 = “Title” = “Supervisory Ahrs”

    Calu Filed #3 = “Value” = Field #1 Value & Field #2 Value

    Ect…

    “EDIT FIELD”

    Field Title “Supervisory Ah”

    Suffix “Ah” displays this right after the Value, “Pick list or Typed in”.

    Formula Pick List “X or – or + or / or ^ or % or none”

    Round “Up or Down or none”

    Round Decimal Place “0 or 1 or 2 or none” Ect.

    Fields 1 “” Pick list or Typed in Field IDs

    Fields 2 “” Pick list or Typed in Field IDs

    Not 100%, but an idea at least.

  • Author
    Posts
Viewing 1 reply thread

You must be logged in to reply to this topic.