Form – Formulas and functions

There are embedded features that you can utilize to capture and control the flow of data flow inside forms.

 

forms

 

Commands must be entered on the Additional Information line of the form field using the Form Editor.

Only one command can be used per form field, however multiple formulas and functions can affect a particular field.

Commands will typically placed in the field where you want the result of the formula or function to be placed.

You will need the field ID code from the left hand side of each field / row on the form editor.

All fields will be validated against

  1. Field Not Blank
  2. Is A Valid Numerical Number
  3. Missing leading 0 on decimal values (ie .9 instead of 0.9)

 

Commands:

  • =ONBLUR – Sets/Copies this form field value into another form field value.
    • Usage:  =ONBLUR(Field #1 ID)
    • Example: =ONBLUR(210370)
    • Parameters: 1 Only
  • =SUMAdds the total of one or more fields up and places the final value into this form field value formatted to the number of significant decimal places
    • Usage: =SUM(Field #1 ID,Field #2 ID, Field #3 ID)
    • Example: =SUM(210370,210371,210372)
    • Parameters: 2 Or More
  • =DIFFSubtracts the value of Field #2 from Field #1, and places the final value into this form field value formatted to the number of significant decimal places
    • Usage: =DIFF(Field #1 ID,Field #2 ID, Field #3 ID)
    • =DIFF(210370,210371,210372)
    • Parameters: 2 Or More
  • =TIMEDIFFH – Subtracts the time of Field #2 from Field #1, and places the difference in HOURS value into this form field value formatted to 1 decimal place
    • Usage: =TIMEDIFFH (Field #1 ID,Field #2 ID)
    • =TIMEDIFFH (210370,210371)
    • Parameters: 2 Only
  • =TIMEDIFFM – Subtracts the time of Field #2 from Field #1, and places the difference in MINUTES value into this form field value formatted to 1 decimal place
    • Usage: =TIMEDIFFM(Field #1 ID,Field #2 ID)
    • =TIMEDIFFM(210370,210371)
    • Parameters: 2 Only
  • =SUMTOHOURS Adds the time in minutes for one or more fields together, rounds minutes (See Below) and places the total in HOURS value into this form field value formatted to 1 decimal place
    • Usage: =SUMTOHOURS(Field #1 ID,Field #2 ID,Field #3 ID)
    • =TIMEDIFFM(210370,210371)
    • Parameters: 2 Or More
    • Rounding Schedule
      • 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
  • =MULTIPLY0 – Multiplies the value of Field #1 to Field #2, and places the result value into this form field value formatted to 0 decimal place (Integer)
    • Usage: =MULTIPLY0(Field #1 ID,Field #2 ID)
    • =MULTIPLY0(210370,210371)
    • Parameters: 2 Or More
  • =MULTIPLY1 – Multiplies the value of Field #1 to Field #2, and places the result value into this form field value formatted to 1 decimal place
    • Usage: =MULTIPLY1 (Field #1 ID,Field #2 ID)
    • =MULTIPLY1 (210370,210371)
    • Parameters: 2 Or More
  • =MULTIPLY2 – Multiplies the value of Field #1 to Field #2, and places the result value into this form field value formatted to 2 decimal places
    • Usage: =MULTIPLY2 (Field #1 ID,Field #2 ID)
    • =MULTIPLY2 (210370,210371)
    • Parameters: 2 Or More