Select to view content in your preferred language

Integer and decimal questions where answer is '0' causing problem in conditional template and form view on s123 site

83
5
Monday
LiviaBetancourtMazur
Regular Contributor

Hi. I have a survey that I published using S123 Connect. That survey has a conditional template set up  so my customer can review reports of survey submissions. We have several integer and decimal type questions and I noticed that if a respondent answers either of those with '0' (zero) it causes the form view not to display that question/answer and same for the conditional template (the question/answer is skipped when it should not be).

The screenshot below depicts this. I am expecting the items circled in blue to show up on the form view tab on the right (see corresponding blue markup) in between the items underline in purple. The same exact situation occurs in my accompanying conditional template.

Screenshot 2025-10-06 145622.png

What can I do so this does not occur?

I tried to do some research and the only thing I could find was this post that speaks of a similar, yet inverse, situation.

0 Kudos
5 Replies
abureaux
MVP Frequent Contributor

There is a good chance this is "working as intended" (i.e., dynamically displaying data). But you would need to submit a bug report to Esri Support. That site is really a what you see is what you get scenario. 

Beyond that, I wouldn't rely on that popout or even that site for any business processes. For any sizable database, I've found the performance to be incredibly poor. Transferring the data via automations to another database would be best. Then you'd have complete control over the data and how it's displayed.

0 Kudos
LiviaBetancourtMazur
Regular Contributor

Thank you for your response! You make good points!

0 Kudos
TylerGraham2
Frequent Contributor

In your survey you could create hidden text fields and use a calculate to take the value from your integer/decimal fields and write them as a string.  Then in the Survey123 website form view, hide the integer/decimal questions and show the calculated string fields instead.  

FYI it does do this in the word report template too, 0 values don't display so in there you have to add 0 to the question to get it to return a 0 value.  e.g. if int_a = 0 and you use ${int_a}, it will return as blank, but ${int_a + 0} will return a 0 in the template output.   

0 Kudos
LiviaBetancourtMazur
Regular Contributor

Hey Tyler, thanks for your suggestion. I did come up with a similar work around for the Word template. I like your idea of the hidden text fields! I may also go that route as my work around only "fixes" the Word template and not the form view (though like the other commenter suggested, I am already trying to get the customer away from viewing survey results in that way as it's not great). Thanks again!

0 Kudos
TylerGraham2
Frequent Contributor

If you built them a webmap or dashboard for them to view records in, you could put some arcade in to get it to show 0 if it was still showing blank there.  

0 Kudos