Work with tables

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.

To show a table for a feature layer or table layer, complete the following steps:

1. Open a map in Web Editor.
2. 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.

3. Click Options next to a layer or table.
4. Click Show table.

   The table appears at the bottom of the map.

5. Optionally, click the expand arrows to view more of the table in the map.
6. 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.

To show or hide columns, complete the following steps:

1. Follow the steps to show a table.
2. On the table header, click Show/hide columns .
3. Check or uncheck the check box for the 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 —Deselect all features from the map and table.
• Zoom to selection —Zoom the map to the extent of the selected features.
• Show selection —Temporarily hide 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.

To create a record in a table, complete the following steps:

1. Follow the steps to show a table.
2. 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.

3. Optionally, if templates were authored for the table in ArcGIS Pro, choose the appropriate template.
4. Add values to the editable fields.
5. Click Create.

The record is created in 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 can calculate expressions using SQL or ArcGIS Arcade.

To calculate a field, complete the following steps:

Note:

Field calculations cannot be undone. For this reason, it is recommended that you 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.

1. Follow the steps to show a table.
2. 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.

3. Choose the language to use for the calculation, either Arcade or SQL.
4. 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.

5. 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.

6. Optionally, do any of the following while composing an expression:
   • Click Test features filter to add a filter to the test features.

     Note:

     This option allows you to filter the test features and does not impact the features that will be calculated.

   • Click Test features to view the table of the test features.
   • Click Preview values to preview the calculated values for the 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.
7. 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 the layer.