# Calculation Field

• 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.