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
Solved! Go to Solution.
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.
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?
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,
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.