You can display an interactive table at the bottom of a map to see information about features or records in a layer. Seeing a tabular view of the data can be a quick way to analyze information and start making decisions. You can sort and filter the attribute data and hide fields to focus on specific data.
You can also access information about each field in the table to understand what the data represents, and get more information about the layer by viewing related data tables, photos, or other file attachments. If you have privileges to edit the layer, you can edit or delete attribute values.
Learn more about editing attributes
Show a table
Showing tables can be a useful way to see the information associated with the feature and table layers in a map.
Note:
Web Editor supports opening and viewing tables for subtype group layer sublayers.
Complete the following steps to show a table for a feature layer or table layer:
- Open a map in Web Editor.
- On the Contents (dark) toolbar, do one of the following:
- Click Layers
to show the feature layers on the map.
You can also use the Alt+Shift+L keyboard shortcut for Windows or the Option+Shift+L shortcut for Mac.
- Click Tables
to show the tables on the map.
Note:
The Tables pane is only available if the map includes one or more table layers.
The Layers pane or Tables pane appears.
- Click Layers
- Click Options
next to a layer or table.
- Click Show table.
The table appears at the bottom of the map.
- Optionally, click the expand arrows
to view more of the table in the map.
- Click Close
in the table header to close the table.
Sort a column
Sorting a column can help you explore the data in the table or find rows that need to be edited.
To sort a column, click the arrows in the column header once to sort ascending or twice to sort descending. Click the arrows a third time to remove sorting for the column.
Alternatively, click Menu in the column header and choose Sort ascending
or Sort descending
.
Show or hide columns
If a dataset contains fields that aren't necessary for your current work, you can hide them from view.
Hiding or showing columns only applies to the table and does not affect which fields are visible in the Attributes pane. Hidden columns are shown again when a table is closed and reopened.
Complete the following steps to show or hide columns:
- Follow the steps to show a table.
- On the table header, click Show/hide columns
.
- Check or uncheck the check box for columns you want to show or hide, respectively.
Reorder columns
To reorder columns in a table, click and drag the column header into a new position.
Reordering columns in a table does not affect the field order in the dataset. The columns return to the default order if the table is closed and reopened.
Work with table selections
Features selected on the map are also selected in the table and vice versa. The following options are available from the selection menu in the table header when one or more features are selected:
- Clear selection
deselects all features from the map and table.
- Zoom to selection
zooms the map to the extent of the selected features.
- Show selection
temporarily hides all unselected rows from the table view. You can click Show all
to make all rows visible.
Create a record in a table
You can add a record to a table containing spatial or nonspatial features. Nonspatial tables have no geometry information. They store descriptive information, but because they do not store a geographical component, features cannot be drawn on a map. When you create a record in a table, any forms you configured in Map Viewer or ArcGIS Pro will appear in Web Editor.
Note:
You cannot create a form for a layer in Web Editor. Use Map Viewer to configure forms for attribute editing.
Complete the following steps to add a record to a table:
- Follow the steps to show a table.
- Click Create record
.
If you are creating a record in a nonspatial table, the Create features pane appears showing all editable fields. If you are creating a record in a feature layer, the Create features tool is activated and you can follow the workflow to create a feature.
- Optionally, if templates were authored for the table in ArcGIS Pro, choose the appropriate template.
- Add values to editable fields.
- Click Create.
The record is added to the table.
Calculate fields
Field calculations allow you to alter the values of every row for a single field in the attribute table of a layer. Field calculations are supported for string, numeric, and date fields.
You have the following two options when writing calculation expressions on fields in a hosted feature layer:
- SQL—Use SQL for the fastest performance with calculations that can be performed with standardized SQL (SQL-92) expressions on nonspatial attributes. You can run SQL on sync-enabled hosted feature layers and layers configured to track feature creators and editors, whereas you cannot run Arcade expressions on such layers.
- ArcGIS Arcade—Arcade is ideal for calculations that require more functionality than SQL, as Arcade provides access to attribute values and feature geometry, allowing you to create expressions that include spatial operations. Additionally, if an error occurs while calculating a particular row, you can stop and troubleshoot the problem, and start the calculation again after you correct the problem.
Note:
ArcGIS API for JavaScript 3.44 and later will not be updated with the latest ArcGIS Arcade language features. Arcade expressions authored in JavaScript API apps at version 3.44 or later will only support Arcade language features introduced in Arcade version 1.21 or earlier. To learn more about Arcade language support across ArcGIS products, see the Arcade version matrix.
Complete the following steps to calculate a field:
Note:
Field calculations cannot be undone. For this reason, a good practice is to add a field, calculate values into it, and confirm the calculation is what you wanted. If it is, you can then calculate the original field to equal the added field. Once you confirm the values are correct in the original field, you can delete the field you added.
- Follow the steps to show a table.
- In the layer table, click Menu
on the column containing the values you want to calculate, and click Calculate field.
The calculate field window appears.
- Choose the language to use for the calculation, either Arcade or SQL.
- Optionally, click Add new to add a filter to calculate values for only a portion of the data, and click Next.
Note:
If you do not add a filter, the calculation is run on all features. If you applied filters to the map or layers in the map before opening the calculate field window, these filters will not be recognized when calculating field values.
- Compose a calculation expression using the following components:
- For Arcade, use global variables, functions, and constants.
- For SQL, use basic operators, a field list, and functions.
Tip:
For examples of common calculations that can be performed in ArcGIS Online, see Example calculations.
- Optionally, do any of the following while composing an expression:
- Click Test features filter to add a filter to your test features.
Note:
This option allows you to filter your test features and does not impact what features will be calculated.
- Click Test features to view the table of your test features.
- Click Preview values to preview the calculated values for your test features.
- Turn off Auto preview to prevent the calculated values preview from automatically updating while authoring an expression. Turn Auto preview on to allow the calculated values preview to update while authoring an expression.
- Click Table
, Map
, or Map and table
to navigate between views.
- Click Test features filter to add a filter to your test features.
- Click Run calculation to run the expression.
The time it takes for the calculation to complete depends on the expression's complexity and the number of features in your layer.