topic Text field return 0 value in ArcGIS Survey123 Questions

Text field return 0 value

MariusVerdes — Tue, 31 Jan 2023 14:01:49 GMT

Hello. I hope there is not another thread on this topic, I did not find one from my research.

For a few days, I noticed that from one of our surveys, the answer for a few questions returned the 0 value. That it's strange because it's a text field and this has never happened before. I attached a screenshot as an example.

Is this a new bug?

The 0 value affects us because this data is used inside a dashboard and a report generated using Microsoft PowerBI.

Many thanks for considering my request.

Re: Text field return 0 value

jcarlson — Tue, 31 Jan 2023 15:00:40 GMT

Was the survey built in the web interface or Sruvey123? Can you share how this field is being filled in? Is it a select_one, an open text entry, or something else?

Re: Text field return 0 value

MariusVerdes — Tue, 31 Jan 2023 15:45:45 GMT

Hello @jcarlson ,

The survey was built using Survey123 Connect. But I found where and why this "0" value appears. It happens only in the fields that have a calculation set up, please see this thread (https://community.esri.com/t5/arcgis-survey123-questions/survey123-automation/m-p/1251850#M47121).

Now I need to know how to make this "0" value disappear when the condition in the calculation is not met.

This is a compliance survey used by my colleagues and they perform full or partial audits. And when it's a partial audit, depending on the situation in the field, this calculation returns a "0".

Do you have any idea how to solve this or what workaround I can use?

Many thanks.

Re: Text field return 0 value

jcarlson — Tue, 31 Jan 2023 15:52:15 GMT

It it's as simple as leaving it null, you can put the condition into the relevant column to hide the question entirely when the condition is not met, thereby not entering any value into it. What is the calculation being used?

Re: Text field return 0 value

MariusVerdes — Wed, 01 Feb 2023 08:53:50 GMT

Hi @jcarlson ,

I tried to move the condition from the calculation column to relevant and the condition did not work anymore. This calculation is set up like an automation, when someone chooses "NO" at question 7.1, the survey selects "NO" for another 12 questions.

But when my colleagues perform a partial audit, the calculation still applies and returns a "0" value. I am trying to get a workaround for this situation.

Thanks,

Marius