Hello everyone,
I’m working on an inspection form created entirely in Survey123 Web Designer (not Connect / XLSForm), and I’d like to confirm whether the following workflow is fully supported.
Context
I work a lot with Survey123 Connect, where in a similar scenario I would normally use a chain of if() statements in the calculation column of the XLSForm. However, I understand that this approach is not available in Web Designer, and calculations must be built using the visual rule-based interface instead.
In my current survey, I have a select_one question whose value is determined automatically (in my case, using AI analysis of audio or images, but the result ultimately resolves to a fixed domain).
Example of select_one values:
- Approved
- Moderate loss
- Critical loss
- Not reported
What I want to achieve
I want to add a second question, hidden from the user, whose value is calculated based only on the selected option of the first question.
For example:
- If the select_one value = Approved → calculated question = 100
- If the select_one value = Moderate loss → calculated question = 70
- If the select_one value = Critical loss → calculated question = 10
- Else → calculated question = 50
This calculated value would then be used later in additional calculations to produce a final inspection score.
Is this pattern (mapping a select_one response to a numeric or text value using a calculated question) fully supported and reliable in Survey123 Web Designer?
Any confirmation, guidance, or references to documentation would be greatly appreciated.
Thanks in advance!
