Select to view content in your preferred language

How to remove comma separator in Experience Builder table

18806
39
07-13-2022 03:31 PM
CalebAnderson
Occasional Contributor

Hello! I'd like to remove the thousands comma separator in the table I have in an experience:

CalebAnderson_1-1657751309022.png

I tried going to the visualization for the feature and unchecking the thousands separator. Also tried pulling the data from a web map where I did the same with no luck:

CalebAnderson_2-1657751420201.png

 

 

39 Replies
CameronLacelle
Frequent Contributor

The only "solution" I've found about this from Esri is this: https://support.esri.com/en-us/knowledge-base/how-to-remove-comma-separators-in-arcgis-experience-bu...

 

They basically just say to create a brand new field in your data that is a text field and populate it with your numeric values from your numerical field. Not sure about others but this is certainly not a viable solution from my organization's end. This is a poor excuse for a technical solution/workaround for an issue where all you need is a setting in a widget or a dataset to turn off comma separators. By default these should be off anyways. We are experiencing this problem with our Civic Addresses in our applications where users pushing data to a table widget will see fields like "Street Number" displayed with a column so 1234 Fake Street would show up as 1,234.

A REAL solution needs to be implemented that does not involve poor data design.

JM_Rail
New Contributor

April 2025 and this is still an issue. Please move this up the priority list, ESRI. Thank you. 

JM_Rail_0-1744745235018.png

 

SophieSanders_24
Emerging Contributor

Also experiencing this issue in Experience Builder on Enterprise, e.g showing as;

2,023

2,024

2,025

Similar to this poster the experience builder is not honouring the fields settings

RachelS
Frequent Contributor

3 years on, and still no fix. Really could do with this fixed and I can't change ours to a text field as it's being used in a dashboard for filtering years.

Is there any update on this @jcarlson?

0 Kudos
jfischer91
Regular Contributor

@TianWen mentioned several years ago that esri was working on this. I wonder where that stands now?

JBH
by
Frequent Contributor

Having to do a workaround of adding a new field is a bit of a crazy ask when this feels like a no brainer feature.

Ming
by
Frequent Contributor

For JSAPI v4.32, you can:

1. Following the official link to install the JSAPI offline (don't need to install calcite offline) and update the variables arcgisJsApiUrl

https://developers.arcgis.com/experience-builder/guide/install-guide/#install-the-offline-node-cache

2. On your web server that hosts JSAPI, navigate to 4.32 --> Esri --> widgets --> FeatureTable --> FieldColumn.js file

3. Modify 

const A = { useGrouping: !0, maximumFractionDigits: 20 };

to

const A = { useGrouping: false, maximumFractionDigits: 20 };

4. After update, clear browser cache or use private mode to test the application.

Ming_0-1754406677144.png

 

Ming_1-1754406687154.png

 

0 Kudos
Ming
by
Frequent Contributor

This issue has been fixed in ExB v1.18.

DanCopKac
Frequent Contributor

how do i fix this issue in the search widget's result? The map service was added via URL, so it's only part of the Experience, it's not part of a web map so I can't change the settings in the web map. 

searchresult1.pngsearchresult2.png

0 Kudos
DustinGriffin_GISP
New Contributor

This is pretty unbelievable... I held off on WAB migration to ExB for long as possible because of these type amongst many other app update issues and we still can't perform the most simple of formatting adjustments and have them persist.  ESRI has completely lost the plot here.  Soon as I complete my open source mapping toolset I'll be slowly getting every client possible off ESRI.  I simply can't endorse these products anymore as ExB and Pro have moved GIS backwards instead of forwards.  

0 Kudos