HOW TO

Remove comma separators in ArcGIS Experience Builder widgets

Last Published: April 19, 2023

Summary

In ArcGIS Experience Builder, widgets such as the Table widget displays numerical field values with the thousand separator (comma). As the widgets reference data from a hosted feature layer, removing the thousand separator from the numerical field values requires creating a new text field mirroring the data from the numeric field. This article provides the workflows to remove the thousand separator (comma) displayed in the Table widget in ArcGIS Experience Builder.

The image below shows the Table widget with the thousand separator (comma) in ArcGIS Experience Builder.

The Table widget with the thousand separator in ArcGIS Experience Builder

Procedure

Create a new text field and populate it with values from the numeric field through ArcGIS Online

Note:
To edit a hosted feature layer, a user must be the owner of the feature layer, the organization administrator, or a member assigned a role with editing privileges. Refer to ArcGIS Online: Who needs to edit? for more information.
  1. Sign in to ArcGIS Online and click the Content tab.
  2. Click My Content and click the web map or hosted feature layer.
  3. Click the feature layer under Layers in the item details page.
  4. Add a new text field to the feature layer. Refer to ArcGIS Online: Add fields from the Table view for more information. Select String in the Type drop-down menu.
The Add Field window with the parameters to be filled
  1. Click the new field, select Calculate to open the Calculate Field dialog box, and click Arcade.
  2. In the Expression dialog box, insert the following Arcade expression. Replace <fieldName> with the numeric field.
$feature["<fieldName>"]
  1. Click Test to view a preview of the expression result. If the required result is achieved, click OK.
Specifying the Arcade expression in the Calculate Field dialog box
  1. On the ArcGIS Online My Content tab, open the ArcGIS Experience Builder experience to edit the Table widget and configure the fields to display the new text field.

Create a new text field and populate it with values from the numeric field through ArcGIS Pro

  1. Sign in to ArcGIS Online and click My Content under the Content tab.
  2. Click the ellipsis icon Ellipsis icon in ArcGIS Online by the web map or hosted feature layer, and click Open in ArcGIS Pro to download the .pitemx file.
  3. Open the .pitemx file in ArcGIS Pro.
  4. Click Edit on the ribbon, and click the Enable editing The Enable editing icon button in the Manage Edits group.
  5. In the Contents pane, right-click the feature layer and click Attribute Table to open the attribute table of the feature layer.
Opening the attribute table of the feature class from the Contents pane
  1. Click the Add Field The Add Field icon button to open the Fields view and create a new text field. Select Text from the drop-down menu in the Data Type column.
  2. Within the Fields view, right-click the edited row and click Save from the context menu.
Saving the newly created field
  1. In the attribute table view, right-click the newly created field and select Calculate Field to populate the field with values from the numeric field.
    1. For Expression Type, click the drop-down menu and select Python 3.
    2. For Expression, double-click the numeric field to be mirrored. In this example, 2019 Total Population is selected.
    3. Click Verify to run a test of the expression. If the expression is valid, click OK. The text field is populated with values from the numeric field.
The Calculate Field window with the parameters to be filled
  1. Click Edit on the ribbon, and click the Disable editing The disable editing icon button in the Manage Edits group.
  2. On the item details page of the hosted feature layer in ArcGIS Online, click the Data tab.
  3. In the Table view, click Options > Show/Hide Columns and check the new text field check box to display it in the table.
  4. On the My Content tab, navigate to and open the ArcGIS Experience Builder experience to edit the Table widget and configure the fields to display the new text field.

The image below shows the Table widget with the thousand separator (comma) removed in ArcGIS Experience Builder.

The Table widget with the thousand separator removed in ArcGIS Experience Builder

Article ID: 000029996

Software:
  • ArcGIS Online
  • ArcGIS Pro 3 1
  • ArcGIS Experience Builder
  • ArcGIS Pro 3 0
  • ArcGIS Pro 2 x

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Related Information

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options