Table widget

The Table widget displays interactive attribute tables for feature layers and scene layers with an associated feature layer with the option to include multiple sheets that users access via tabs or a list. You can choose which fields to include in the table and turn on tools such as search and selection. Users can sort tables by one or multiple fields and by ascending or descending order.

Examples

Use this widget to support app design requirements such as the following:

• You want to display attribute tables.
• You want to provide a table for users to interact with, such as finding or sorting records, editing attributes, and selecting corresponding features in a map.

Usage notes

This widget requires that a data source be set for each sheet in the table. Table supports feature layers and scene layers with an associated feature layer. You can set actions for a Table widget to interact with other widgets, such as zooming to the selected feature on a map in a Map widget or filtering rows in a List widget. You can also use this widget to display feature attributes without including a map in the app.

Tip:

For fields containing long strings, users can hover over any cell to view its entire value in a ToolTip. URLs in cells are automatically shortened to View and become live links.

Settings

The Table widget includes the following settings:

• New sheet—Create one or more sheets in the table. (Click the Remove button to remove a sheet from the table.) For each sheet, specify the following settings in the Sheet configuration panel:
  • Data—Select the data source for a layer with attributes to show in the widget. In the data view settings, you can filter the data to restrict what appears in the widget, sort the data to display features in a particular order, or limit the number of features.
  • Label—Type a name for the sheet. This name appears in the widget as a tab or in a list of sheets.
  • Configure fields—Select the fields to include in the sheet. (The first 50 fields are automatically selected; use the Clear selection button if needed.) Drag selected fields to reorder them. Click the Visible icon to turn a column's visibility on or off when the widget first loads. (Users can change visibility at runtime with the Show/hide columns tool.) Attachment fields are supported. If the data source supports editing, check the Allow editing box so users who have access to the data can edit attributes by double-clicking in the table cells. You can choose which fields are editable. Lock icons appear in column headers for fields that can't be edited.

    Note:

    When the user exports to JSON, CSV, or GeoJSON formats using the Export all or Export selected data actions, only the fields you select for display are included in the export.

  • Header options—Customize the header row that appears at the top of the sheet. You can apply bold formatting to the header text, change the font color, and change the font size in pixels (px). You can also choose the header background color.
  • Tools—Provide tools for users to interact with the sheets in the table.
    • Search—Provide a search box for the sheet in the table.
      • Select searching fields—Choose one or more fields to search.
      • Exact match—Limit search results to only records that match the search phrase.
      • Hint—Customize the hint text that appears in the search box.
    • Select records—Allow users to select records in the sheet. Turning on this tool also includes Show selection (updates the sheet to only display the selected items) and Clear selection in the sheet's Options menu.
      • Select mode—Allow users to select single or multiple records in the table.
    • Refresh—This tool appears in the sheet's Options menu for users to refresh the table to get the latest data.
• Arrangement style—Choose from Tabs or Dropdown to specify how users can switch between the sheets in the table.