Select to view content in your preferred language

Remove commas from Integer field type

9485
12
10-11-2017 05:39 AM
Lake_Worth_BeachAdmin
Frequent Contributor

I have a field for 'phone number' that's integer type because I want to force numbers by the end user and not allow letters. however the once the numbers are entered they appear with commas ad the values in AGOL (5,546,433) for example. 

How can I remove these commas within survey123 .xls sheet? is there another parameter I am missing. 

Tags (2)
0 Kudos
12 Replies
deleted-user-qpvAI3Fo0MKR
Deactivated User

All good points I didn't consider.

I'll make it a point to use text fields for these attributes in the future.

Thanks for the swift reply!

AdamDaily
Frequent Contributor

I think this error is coming back around in the latest released version of Survey ( I believe it is 3.2.265). Our field crews downloaded the newest Survey123 app on their mobile phones from the play store (Using Galaxy S8) and now the existing surveys return error "Invalid Integer Value" when trying to submit a survey. I noticed my integer fields are now displaying values with commas (they were not previously). We have been collecting on the same mobile devices with the same surveys for months - all working fine until the Jan 31 2019 upgrade.

Is there a work-around or new setting that I need to be aware of within Survey mobile app to correct this issue? Nobody that has downloaded the new version has been able to submit any surveys since doing so. I saw Brandon Armstrong‌ comments about using text fields, but my survey is already published and I can't go back and make that change at this point.

DeonLengton
Esri Contributor

Hi everyone

The best way to handle phone numbers in my opinion is to use a TEXT field and change the appearance to numbers.

I found that if you use an integer you run into issues - for us in South Africa some numbers might start with a Zero and then that Zero is thrown away in an integer field.

With a text field you wont have that issue.