Select to view content in your preferred language

How to allow the entry of decimals in a Survey123 decimal field

4841
23
03-28-2018 10:35 AM
MattRapke
Emerging Contributor

I am trying to publish my first Survey123 survey that contains a decimal type field. I created the survey using Survey123 Connect, and everything worked fine in the form view on Connect. I published the survey and tried to do a test run to make sure that all the fields worked properly. When I copy-pasted a decimal number into the decimal field, the form converted the decimal to a comma. For example, if I copy 3.92 and paste it into the form, it shows up as 3,93. On the back-end the data is entered properly as a decimal, but the survey will be conducted in Canada and the users will be confused by the comma. Furthermore, I am unable to manually type a "." value into the decimal type field instead of a ",". Is there a setting I am missing to prevent this conversion and allow "." decimal entries?

0 Kudos
23 Replies
JamesTedrick
Esri Esteemed Contributor

Hi Matt,

This sounds like it may be a locale issue - what is the locale of the device you are entering data on?  Non-Canadian French locales would use the comma as a decimal mark.

0 Kudos
MattRapke
Emerging Contributor

I'm not sure how Survey123 determines computer location, but I am using my computer from my home in Bruce County, Ontario. I was connected over a VPN to the University of Guelph. It does the same thing whether or not I'm using the VPN. 

0 Kudos
JamesTedrick
Esri Esteemed Contributor

Hi Matt,

I'm referring to the device's locale (language/formatting settings) - this is normally an OS-wide setting.

0 Kudos
MattRapke
Emerging Contributor

I'm using Windows 10, I went to Settings > Time & Language > Region & Language. My country is set to Canada. I changed it to the U.S. to see if that would affect anything, but it didn't. Are those the settings you're referring to?

0 Kudos
MattRapke
Emerging Contributor

Hi James

I just installed Survey123 connect on a different computer and published a survey with only a single test question with a decimal field type. That survey also forces commas and prevents "." entries in the decimal field regardless of the computer that I use to enter the data. I don't think it's an issue that's local to both of my machines. 

0 Kudos
JamesTedrick
Esri Esteemed Contributor

Hi Matt,

What are you copying the number from- a text document, Excel, something else?  We are not able to reproduce this in Windows or Mac.

0 Kudos
MattRapke
Emerging Contributor

It doesn’t matter what I copy from, the result is always that the form transforms the decimal into a comma. When I try to manually enter the values using the keyboard I am unable to enter a “.” but the form will accept a single “,” as the decimal value. 

0 Kudos
JamesTedrick
Esri Esteemed Contributor

Cna I also ask you to check the advanced date/number settings just to make sure: 

0 Kudos
MattRapke
Emerging Contributor

Mine looks the same other than my measurement system is metric. The decimal symbol is definitely "." in my settings. 

Here is a link to my dummy survey with a single field with the decimal type:

https://survey123.arcgis.com/share/75ab1b17d7044948895cf174f7635b77 

Please let me know if you are able to enter a decimal number. Like I said, I can't get it to work on either of my computers. I have tried both Chrome and Edge browsers just in case. Both of them are stand-alone units, so there are no centralized IT settings that would be causing the issue. 

I did however just try it on my iPhone and it was able to enter the correct decimal value just fine.

0 Kudos