Create a pass/fail summary on your form

Many inspection forms and checklists require responses of Pass/Fail, Yes/No, or some type of score or flag that indicates a failed condition or issue that needs attention.  Rather than scan through an entire form for the exception conditions (a condition other than normal; in this case a response of Fail, No, etc.), you can put a summary into the form that only tracks the exception conditions. This summary can then be used in Custom Reports and is displayed in-app and on standard generated forms.   Example: If 100 Pass/Fail conditions are in an inspection form and the user only wants to review the failed items, the user can:  

1. Add a Calculation field to the form in the Form Builder.

2. Make sure that the Field Keys are named for each Pass/Fail, Yes/No, etc. field.

3. Enter the following script into the Calculated Field:

Note

+ question1 is the Field Key for the question 

+ =='Fail' evaluates an Option Field with 'Fail' as the value; it is checking for. This could be Yes or No in a Yes/No field type.

+ "Question 1 Failed" is the text that will appear in the summary field

+,\n is putting a return in the text so that the summary appears as a list rather than a sentence.  

Script

var issues = '';
if ($question1$ == 'Fail') {
issues += 'Question 1 Failed,\n';
}
if ($question2$ == 'Fail') {
issues += 'Question 2 Failed,\n';
}
return issues;