Survey123 Connect - Relevant Group Statements Broken?
I have a simple form attached that I would like to simply count if a field has a value and if that value equals 1 than assign that as project status = proposed. I'm running into the issue when I try to set a group relevant statements to key on the project status I am getting the Error Converting XLSForm. I've attached a sample form if anyone is able to help solve this I would greatly appreciate it!
Adding a Relevant Group Statements keeps showing the Error Converting XLSFor
The problem is caused by the calculations highlighted in the next screenshot:
You are creating an end-less cycle:
- Calculations trigger when the value of the question changes...
- The calculation says: If you have a choice selected, change the value to 0 or 1
- Now that you have changed the value, the calculation triggers again...
Another issue is in this calculation:
if(${num_selected} = 1, "proposed",if(${num_selected} = 2, "callback", "unknown"))
The num_selected question is a note question type, which is by default a text value, but you are comparing against a number: ${num_selected} = 1
It will be better if you do this:
- if(${num_selected} = "1", "proposed",if(${num_selected} = "2", "callback", "unknown"))
Other than that, your form works as I think you would expect.
