Selection Option Expressions
What is an Option Expression?
Set logical expressions for selection options to auto-select answers based on preset conditions (e.g., keyword matching).
Use Cases
• Brand research: Auto-select options based on previous answers.
• Assessment surveys: Auto-select results based on scores.
How to Use
1. Edit Multiple Choice/Checkboxes questions → Click "Calculation Formula"
2. Input expressions in the option fields.
Common Expressions
Example 1
If q1 contains "cola" or "sprite", auto-select Option 1 of q2:
OR(FIND("cola",[q1])>0, FIND("sprite",[q1])>0)
Example 2
If q1 exactly matches "wine", auto-select Option 1 of q2:
[q1]=="wine"
Example 3
If q1 or q2 contains "cola", auto-select Option 1 of q3:
OR(FIND("cola",[q1])>0, FIND("cola",[q2])>0)
Allow Modification
Users can choose whether to allow manual overrides of auto-selected options.
Important Logic
(1) If manual selection is made before formula triggers:
• Allow modification: Manual choice remains.
• Disallow modification: Formula result overrides.
(2) If manual selection is made after formula triggers:
• Allow modification: Formula no longer affects the option.
• Disallow modification: Formula re-evaluates and updates the option if conditions change.
FAQ
Q1: What is Selection Option Expression? What does it do?
A: Selection Option Expression sets logical expressions for selection options, automatically selecting answers based on preset conditions (such as keyword matching). This achieves questionnaire intelligence and automation, reducing manual user operations.
Q2: What scenarios are Selection Option Expressions suitable for?
A: Mainly suitable for two scenarios: 1) Brand Research: Automatically select options based on previous answers; 2) Assessment Surveys: Automatically select results based on scores. This improves questionnaire responsiveness and user experience.
Q3: How to use the Selection Option Expression function?
A: Usage steps: 1) Edit Multiple Choice/Checkbox questions → Click "Calculation Formula"; 2) Enter expressions in the option fields. The system will automatically select corresponding options based on expression logic.
Q4: What are the common expression methods for Selection Option Expressions?
A: Common expression methods include: 1) Keyword matching: If q1 contains "cola" or "sprite", automatically select Option 1 of q2; 2) Exact matching: If q1 exactly matches "wine", automatically select Option 1 of q2; 3) Multi-condition matching: If q1 or q2 contains "cola", automatically select Option 1 of q3.
Q5: How to set modification permissions for Selection Option Expressions?
A: Users can choose whether to allow manual override of auto-selected options. If modification is allowed, users can manually adjust after automatic selection; if modification is not allowed, the system will strictly execute according to expression logic, ensuring data consistency.
