Survey123 Connect - Calculation fails with decimals and French custom system settings (dot instead of comma)

[leo_SwissGIS]

Hi,

We have an issue with latest release of Survey connect (3.7) and fields with calculations and decimals.

We are working on Windows 10 computers, with French as system language, but with dot as a decimal symbol instead of comma by default:

 

The example below shows a very simple calculation where the second field (type = note) just takes the first field (type = decimal) value.

The expected behavior is the following:

But with our system configuration, this is what we get:

No calculation done = whoops.

If we change back to the default settings (with comma instead of dot), the input in the first field needs to be with a comma, but the calculation works and gives a value with a dot.

Fun fact: when using pull-data from a csv file with dots, the input is not valid as it expects a comma but the calculation works anyway…

The thing is that we don’t want to change this setting only for Survey123 connect, as it is necessary for other software.

After publishing, there is no issues with the calculation in Survey App (although there is one with our Samsung tablets and default keyboard, as mentioned here).

Is that a bug or is there a way to solve this without changing the system settings? It was working well with previous versions of connect.

Léo

[Shwu-jingJeng]

Hi Leo,

This issue is similar to an existing salesforce issue we are working on:

BUG-000129238 Survey123 Connect for ArcGIS does not recognize the decimal numbers if the Windows language settings is in Portuguese (Brazil).

I suggest you to contact Esri Support. Our Support team will assign an official enhancement number for your records. Similar requests from other customers can then be attached to the same enhancement request, which helps us assess demand for the enhancement and prioritize it accordingly.

[leo_SwissGIS]

Hi!

Thank you for your response, that I haven't seen before. I have just noticed that the bug for Portuguese settings has been fixed in the new release (3.10) but unfortunately it still doesn' work with French.

We will contact the support and hope that we can solve the problem for the next release. This is rather problematic as we can not test properly our surveys when they include calculations with decimals.

Cheers,

Léo