I’m trying to make a change to an existing survey. Because no default value was set when the survey was created, most records either have a value of “Yes” or “Null.” I’m trying to make a calculation formula that sets a record’s answer to “No” if a null value, but Survey123 keeps telling me I’m creating a dependency cycle (see screenshot). Can anyone tell me where I’m going wrong with the calculation formula below?
if(${survey_status} = '', 'No', '')
Thanks so much!
Solved! Go to Solution.
Generally, you can't reference a field in its own calculation. Why not just run a field calculation against the whole table to convert the Nulls to No?
Generally, you can't reference a field in its own calculation. Why not just run a field calculation against the whole table to convert the Nulls to No?
Yep, that worked. Guess I was just overthinking this one. Thanks, Josh!