Maintaining triggers and fixing errors
The Results app monitors triggers for certain types of errors. Tables with broken triggers have an error icon 
next to the trigger count. The Results app also disables broken triggers so they cannot run on false pretenses. You can fix these issues as they appear.
Why triggers break
Changes over time
As time passes, your company and data change. For example, someone may delete fields used by triggers or change the format of your data. People may also leave your company or move to other departments.
Copying triggers to other places
Triggers often refer to specific people and fields. When you copy a trigger, those resources might not exist in the trigger's destination.
Errors and how to fix them
Broken triggers are marked with a red error icon and are automatically disabled. When you fix the underlying issue, the trigger is automatically re-enabled. The following table explains the types of errors the Results app checks for.
| Error | Type | Details | How to fix this | |
|---|---|---|---|---|
| Trigger references a field that is invalid |
Error |
This means a trigger references a field, but the field does not have the data type the trigger expects. Typically, this happens when a field's data type is changed while importing new data or a trigger is copied to a table where that field has a different data type. |
|
|
| Trigger references a field that does not exist |
Error |
This means a trigger references a field, but the field does not exist in this table. Typically, this happens when a field is deleted from a table or a trigger is copied to a table where that field does not exist. |
|
|
