topic Re: How to allow the entry of decimals in a Survey123 decimal field in ArcGIS Survey123 Questions

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

MattRapke — Wed, 28 Mar 2018 17:35:39 GMT

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?

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

JamesTedrick — Wed, 28 Mar 2018 19:36:23 GMT

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.

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

MattRapke — Wed, 28 Mar 2018 19:42:01 GMT

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.

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

JamesTedrick — Wed, 28 Mar 2018 19:44:48 GMT

Hi Matt,

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

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

MattRapke — Wed, 28 Mar 2018 20:01:10 GMT

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?

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

MattRapke — Wed, 28 Mar 2018 21:08:04 GMT

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.

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

JamesTedrick — Wed, 28 Mar 2018 21:30:54 GMT

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.

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

MattRapke — Wed, 28 Mar 2018 21:43:19 GMT

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.

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

JamesTedrick — Wed, 28 Mar 2018 21:53:18 GMT

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

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

MattRapke — Wed, 28 Mar 2018 22:52:38 GMT

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.

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

JamesTedrick — Wed, 28 Mar 2018 23:01:13 GMT

Hi Matt,

My apologies, I was under the impression that the issue was with the field app. The issue with the web form is known (BUG-000111251) and is being addressed in the next release of Survey123 (due out shortly).

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

MattRapke — Thu, 29 Mar 2018 13:50:12 GMT

Thanks James. I was hoping to have this survey go live in about 2 weeks. Do you expect the release to be out within that time frame? If not then I will need to include a hint to let the users know they need to enter a comma.

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

JamesTedrick — Thu, 29 Mar 2018 18:15:56 GMT

Yes, the release is scheduled to come out early next week.

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

NicolasRoger — Tue, 15 May 2018 17:59:03 GMT

hi James. I also have an issue with decimal fields on a web form (the survey was created with Connect). My problem is that the field won't accept either "." or "," in the field at all. It works fine when I test it on the desktop Survey viewer.

I am using Survey123 connect version 2.7.72 which seems the latest one.

EDIT: I am using firefox.

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

FaranZafar1 — Thu, 08 Nov 2018 06:53:22 GMT

Hello,

I have integrated collector for ArcGIS with survey123 while configuring the pop up. The lat/long are coming from collector to survey123 form. When i use this integration from the laptop through the survey123 desktop app (attached image1), it gives me complete value of the lat/long after decimal (attached image2). The complete values after decimal are very important, in order to have the exact location.

Issue:

When i use the same workflow in the mobile (both iOS and android), 2 digits comes after decimal from collector to survey123 mobile app. Therefore the location is not accurate.(image3)

Kindly let me know how to fix this as same form is showing complete values in the laptop survey123 app while in mobile app it shows only two values after decimal.

Thanks

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

MarcosPereyra — Thu, 22 Nov 2018 18:22:48 GMT

Hi James. I have an issue with decimal fields on a web form (the survey was created with Connect). My problem is that the field won't accept either "." or "," in the field at all. It works fine in desktop Survey viewer and Survey123 App (android).

I am using Survey123 connect version 3.0.142.; Firefox Chrome & IE

Thank you

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

KevinThompson — Tue, 23 Apr 2019 17:57:30 GMT

This is the exact problem I am having anyone have a solution?

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

DougBrowning — Tue, 23 Apr 2019 22:36:10 GMT

Did you try changing the number of decimal places in the Web Map that feeds Collector. It is in Pop up then Configure Attributes.

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

KevinThompson — Wed, 24 Apr 2019 13:33:18 GMT

Hey Doug,

This worked but I can now only have up to 8 decimal places and the coordinates go much higher than that.

Here is the thread I created:

Survey123 Mobile App Truncating Number Fields?

Thanks for the help!

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

DougBrowning — Wed, 24 Apr 2019 13:50:53 GMT

Did you maybe publish this as a service via ArcMap? I wonder if changing it in ArcMap before publishing would do it? Total guess.