Survey123 Connect - Relevant Group Statements Broken?

Question

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

Calculations.xlsx

JordanMiller4 · Answer

What types of calculations would work in the first scenario? I still feel like I am hitting a road block on this one. Thanks

IsmaelChivite · Answer

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.