While configuring your Trigger 'Done String Formula', you may encounter some errors within the string syntax. This will prevent the Trigger from behaving the way you intended it to. This page will help you diagnose various errors within your string.
To get started, you will need to view the All Event Records Listbox, and select the Event that you are interested in.
Once you have the Event Record Form open, you can analyze the 'Formula Debugger' section to see any possible issues.
For an extensive reference of Syntax information please read Trigger Syntax.
Formula Debugger
Variable Results
This window displays the results, or lack of results, of all the variables that were defined in the Trigger.
Date Formula
Displays information regarding the Triggers Date Formula
Date Formula Error
Displays any error information regarding the Date Formula
Due Date Formula
Displays information regarding the Triggers Due Date Formula
Due Date Formula Error
Displays any error information regarding the Due Date Formula
Formula
Displays information regarding the Triggers Formula
Formula Error
Displays any error information regarding the Formula
Due Formula
Displays information regarding the Triggers Due Formula
Due Formula Error
Displays any error information regarding the Due Formula
Possible Formula Syntax Errors
Bad Variable Name
You will see this message in the 'Formula Error' box: Bad variable name !
This could be the result of misspelling or mistyping the variable name in the formula. It can also be a variable that doesnt exist. Keep in mind, all variable names will be converted to UPPERCASE no mater what you put as the variable name.
Variable will be converted to VARIABLE
It is good practice to highlight and copy the variable name from the Variable(s) box, then paste the variable name into your Done String Formula. This can prevent many typos and future headaches in your Trigger Done String Formula.
Bad Function
In the event you misspell a function name, i.e. IFF / IIF, you will get a Formula Error: Bad function iff. This can also be the result of using a function that is not supported by the application.
You should also note that the variable results should still display if your syntax is correct.
Bad Operand Type
The image below is bad syntax due to the '!' being placed after the '='. The correct syntax would be '!=', not the reverse order.
Stack Is Empty
The image below is bad syntax due to the '>' being placed after the '='. The correct syntax would be '>=', not the reverse order.