How to format display of calculated result in Survey123

[JimTolbert]

I am using Survey123 for a Road Tour app.  Part of that is calculating the square yards of a segment.  Currently, I am successfully calculating the area with a "calculate" statement as displaying the result with a "note" statement.  I have been unable to successfully format the result to an integer.  I have tried input mask, but it is not an input and I tried "esriFieldTypeInteger" in the "bind::ersi:fieldType".   The length and width are read from previous data with pulldata().  Any suggestions?  Many thanx............ jt

[JamesTedrick]

Hi Jim,

There are input masks that can be used to prompt data input in a pattern, but there isn't an existing function that can format a number into currency text in the form specification we use (XLSform).  We are looking at ways to support this in the future.

[JohnWatson_EBA]

Hey James, the input mask can be fickle. I want to give the option to put in dollar values, up to 1000, so I tried 0009.00. Only the tens column is required. I used the zero because ASCII digit permitted but not required. However, in Excel, 0009.00 gets changed to 9, no matter how I format the cell. Any thoughts on that?

[AdiKurniawan]

Hi James, 

I also face a similar problem. My calculation result shows that the number is store as a string instead of integer format when I try to access through an indicator in operation dashboard. I have tried to follow your suggestion to add a syntax int() in the Calculation column. Is there any suggestion from you?

Thank you.

Regards, 

[DeonLengton]

Hi Adi

To force the type to Integer you need change the bind::esri::fieldType value of the question to esriFieldTypeInteger

By default most questions in Survey123 resolve to String types.