Boolean Formula Question: response contains specific words

A Boolean formula generates either a 1 or a 0 value. If the filter statement evaluates to True, the value of this question is 1. If the filter statement evaluates to False, then the value is 0. 

In the following example, a parent question asks for a text response using an Open-End Text question. Next, a Formula question is created to determine whether the words 'like,' 'good,' or 'great' (lower case only) appear in the response to the parent question. If so, the Boolean Question evaluates to true. Finally, a follow-up question is created and is displayed based on whether the respondent entered the selected words in response to the parent question.

Create the Parent Question

1. Click Select a Question Type>Standard Question>Open End Text from the Question menu.
2. Save the Question Options screen.
3. Click Set Question Page Text>Question Text to enter the text for this question.
4. Save the parent question.

Create Boolean Formula Question

1. Click Select a Question Type>Formula> Add a Formula Type Question>Boolean Value.
2. Click Build Filter.
3. Select the parent question, for example Q45a.

4. Enter the comparison operator [ ], which means containing.
5. Enter 'like' as the value.
6. Click Add.
7. Select OR as the conditional operator.
8. Repeat steps 3 through 7 for the remaining values, 'good' and 'great.'
9. Save the question.

Create Follow-Up Question

The example below is a single choice radio button question asking for a yes or no response. This question contains a pre-question filter and is only displayed if the respondent entered the words 'like,' 'good,' or 'great' in the parent question above.  

1. Click Select A Question Type>Standard Questions>Single Choice Radio Button from the Question menu.
2. On the Question Options screen, click Build Pre-Question Filter.

3. Use the Filter Wizard to complete the filter statement.

• Select the previous formula question, for example, Q45b.

• Enter = as your comparison operator.

• Enter 1 as the value for the question.

4. Save the Question Option screen.

5. Create your question text and response option labels using Set Question Text and Set Answer Options.
6. Save your question.