Select to view content in your preferred language

How to remove comma separator in Experience Builder table

11381
36
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

 

 

36 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
Regular 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.

0 Kudos
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