Format integer to remove commas ExpBuilder

[JayJohnsonWashoeCounty]

Is it possible to control field formatting in either the Table widget or List widget in Experience Builder?  I have an integer field that I need to display WITHOUT the typical commas separating the thousands place.

What I want:   202109

What I'm getting:  202,109

[jcarlson]

I've noticed this too. Experience Builder seems to ignore the field formatting defined in the layer's visualization settings. Same with date fields, regardless of the formatting and whether you choose "show time" or not, it comes in as M/D/YYYY, HH:MM [AM/PM].

Would love to see field formatting settings at the data source level, to consistently control field display in all widgets.

[RhettZufelt]

Have not tested in the Table Widget, but in the List and Edit Widgets (all tied to the map), all you have to do is open the map in the good old Classic Map Viewer, config the popup for that layer, and un-check the "Use 1000 separator" box.

R_

[JayJohnsonWashoeCounty]

The data in question is just a table - no map.  So...no popup to configure...

[Ryan_Gould]

@JayJohnsonWashoeCounty 

I had the same issue. A thousands separator was displayed when numeric field values are used in labels, and pop-ups in ArcGIS Online or Enterprise.  This was a problem when displaying acquisition year for aerial photographs.

To resolve this in pop-ups: I used the Round function, with the number of decimal places set to 0.

Example:

"Round(($feature.ACQUISITION_YEAR),0)"

For List elements in ArcGIS Dashboards: I used the Text function, with "0" for the digit format. 

Example:

"return GroupBy(fs,[Text('EQUIP_NUM',0),'DATE','CAMP_NAME','ROAD_SEG','FUNCTIONAL_ROAD_CLASS'], "

I hope this helps.

[AdamBowen]

Still seems to be an issue. I can't do any sort of number formatting. I have percentages that show up in the Filter and Table widgets as integers (0.125 instead of 12.5%). This is a headache as I need it to filter as numeric values, but display in all contexts as a percentage. The only workaround that I am seeing is to convert it to a text and apply a percent sign after multiplying by 100. That's great for the table, but I can't filter the data as a range when it is text. Is the Experience Builder dead in the water or are they still developing this? It seems like a simple feature to overlook for over a year with no resolution.

[Metropolitan_Planning_Council]

My workaround to this was to label the field with a % sign and use full integers as my percentage, and I did the same for the currency field. Until AGOL allows other number formats like percentages, currency, and dates this will be an issue.

[AaronKoelker]

Having this issue as well, along with not being able to do a Search on Integer fields. Would like to be able to Search on a Facility ID field for example. The workaround of course is also to republish with the ID field changed to a text/string field, but that's not always an option depending on the data source.

[VenkataSrikanth_Dasari]

Here is the solution I found in the below post.

https://community.esri.com/t5/arcgis-experience-builder-questions/how-to-remove-comma-separator-in-e...

Thanks

Srikanth Dasari

https://www.linkedin.com/in/srikanth-dasari-0526/

[VenkataSrikanth_Dasari]

Here is the solution I found and posted the information in the below link

https://community.esri.com/t5/arcgis-experience-builder-questions/how-to-remove-comma-separator-in-e...

Thanks

Srikanth Dasari

https://www.linkedin.com/in/srikanth-dasari-0526/