Operators

Arithmetic Operators

• (+) ADD
  • Example: 5+5
• (-) SUBTRACT
  • Example: ControlID(1)-ControlID(2)
• (*) MULTIPLICATION
  • Example: 10*FORMPARAM(1)
• (/) DIVISION
  • Example: 10/5
• (^) EXPONENTIATION
  • Example: 1+(10^2)

Arithmetic Operator Usage

Logical Operators

• (<) LESS THAN
  • Example: IF(5<5,TRUE,FALSE)
• (>) GREATER THAN
  • Example: IF(ControlID(1)>ControlID(2),TRUE,FALSE)
• (=) EQUAL TO
  • Example: IF(10=FORMPARAM(1),TRUE,FALSE)
• (<=) LESS THAN OR EQUAL TO
  • Example: IF(15<=15,TRUE,FALSE)
• (>=) GREATER THAN OR EQUAL TO
  • Example: IF((10+5)>=16,TRUE,FALSE)
• (<>) NOT EQUAL TO
  • Example: IF(5<>controlID(3),TRUE,FALSE)

Text Operators

• (&) CONCATENATION
  • Example: "string1"&"string2"
  • Example: ControlId(1)%"teststring"

Text Operator Usage

Functions

Branch Functions

• IF()
  • Usage: IF(Check, True Branch, False Branch)
  • Returns: Whatever was in the branch selected based on the Check

Boolean Functions

• AND()
  • Usage: AND(param1, param2, param3, ...)
  • Returns: Boolean (true / false)
• EXACT()
  • Usage: EXACT(String, Sub String)
  • Returns: Boolean (true / false)
• ISBLANK()
  • Usage: ISBLANK(InputQuestion)
  • Returns: Boolean (true / false)
• OR()
  • Usage: OR(param1, param2, param3, ...)
  • Returns: Boolean (true / false)

Float Functions

• AVERAGE()
  • Usage: AVERAGE(number1, number2, number3, ...)
  • Returns: Float (number with decimal places)
• MAX()
  • Usage: MAX(NumberInput1, NumberInput2, NumberInput3, ...)
  • Returns: Number (float or integer based on the inputs)
• MIN()
  • Usage: MIN(NumberInput1, NumberInput2, NumberInput3, ...)
  • Returns: Number (float or integer based on the inputs)
• POWER()
  • Usage: POWER(Base, Exponent)
  • Returns: Number (integer or float based on input)
• MROUND()
  • Usage: MROUND(NumberInput, DecimalPlaces)
  • Returns: Number (integer or float based on input)
• SUM()
  • Usage: SUM(NumberInput1, NumberInput2, NumberInput3, ...)
  • Returns: Number (integer or float based on input)
• NUMBERVALUE()
  • Usage: TO_ NUMBERVALUE(TextQuestion)
  • Returns: Number (integer or float based on input)

Integer Functions

• CEILING()
  • Usage: CEILING(NumberInput)
  • Returns: Integer (whole number)
• FLOOR()
  • Usage: FLOOR(NumberInput)
  • Returns: Rounds a number down, toward zero
• LEN()
  • Usage: LEN(TextInput)
  • Returns: Integer (whole number)
• MOD()
  • Usage: MOD(Dividend, Divisor)
  • Returns: Integer (whole number)

String Functions

• CONCATENATE()
  • Usage: CONCATENATE(TextQuestion1, TextQuestion2, TextQuestion3, ...)
  • Returns: String (some text)
• LOWER()
  • Usage: LOWER(TextInput)
  • Returns: Converts all characters in a supplied text string to lower case
• MID()
  • Usage: MID(TextInput, Position, Length)
  • Returns: Text
• UPPER()
  • Usage: UPPER(TextQuestion)
  • Returns: Converts all characters in a supplied text string to upper case

Date/Time Functions

• YEAR()
  • Usage: YEAR(DateField)
  • Returns: Integer
• MONTH()
  • Usage: MONTH(DateField)
  • Returns: Integer
• DAY()
  • Usage: DAY(DateField)
  • Returns: Integer
• HOUR()
  • Usage: HOUR(TimeField)
  • Returns: Integer
• MINUTE()
  • Usage: MINUTE(TimeField)
  • Returns: Integer
• SECOND()
  • Usage: SECOND(TimeField)
  • Returns: Integer
• NOW()
  • Usage: NOW()
  • Returns: DateTime Object

Special Functions

• FORMPARAM()
  • Usage: FORMPARAM(1)
  • Returns: Value of specified Form Parameter
• ControlID()
  • Usage: ControlID(1)
  • Returns: Value of specified Control