Form Formulas

Formulas can be used to automate form features.

Example:

If you want to add Field #1 and Field #2 together and place the result into Field #3, place the following code into theĀ “Additional Info” line on Field #3

Field #1 (ID:3456) Contains the Daytime Arrests

Field #2 (ID:4456) Contains the Nightime Arrests

Field #3 (ID:4501) Will contain the total of Field #1 + Field #2

Then you would put the following into the “Additional Info” line on Field #3 in the Form Editor

=SUM(3456,4456)

There is no need to put anything into the “Additional Info” line for Field #1 or Field #2.

 

The Field ID code for each of your fields is located in the top right hand corner of each field in the Forms Editor.

 

 

 

Formula Usage Description
=SUM(Field #1 ID Code, Field #2 ID Code, Field #3 ID Code) Add The Values From Two Or More Numerical Fields Together
eg 20 + 10 + 5 = 25
=DIFF(Field #1 ID Code, Field #2 ID Code, Field #3 ID Code) Subtract The Values From Two Or More Numerical Fields Together
eg 20 – 10 – 5 = 5
=TIMEDIFFH(Field #1 ID Code, Field #2 ID Code) The Difference Between Two Times And Return The Result In Hours
eg 19:00 – 19:30 = 0.5 (Hours)
=TIMEDIFFM(Field #1 ID Code, Field #2 ID Code) The Difference Between Two Times And Return The Result In Minutes
eg 19:00 – 19:30 = 30 (Minutes)
=SUMTOHOURS(Field #1 ID Code, Field #2 ID Code, Field #3 ID Code) Sum Multiple Minutes Fields And Return The Result In Hours.
This Automatically Rounds The Values
0-6 Minutes = 0.1 Hours
7-12 Minutes = 0.2 Hours
13-18 Minutes = 0.3 Hours
19-24 Minutes = 0.4 Hours
25-30 Minutes = 0.5 Hours
31-36 Minutes = 0.6 Hours
37-42 Minutes = 0.7 Hours
43-48 Minutes = 0.8 Hours
49-54 Minutes = 0.9 Hours
55-60 Minutes = 1.0 Hours

eg 20 (Min) + 30 (Min) = 0.9 (Hours)

 

Post navigation