HOW TO
Related records are secondary data that have relationships with the primary data. However, unlike join tables, related records are not appended to the primary data. So, the related table is viewed separately from the primary attribute table.
The table below shows the primary data and related records (secondary data) of three postgraduate students, and the number of fossils collected from central Peninsular Malaysia. Data are collected using the Survey123 for ArcGIS form with multiple repeat records.
Primary data: Paleontology report | Name | Nelisa | Syahida | Nisa | ||||||
Field supervisor | Prof. Shafeea | Prof. Aziz | Prof. Kamal | |||||||
Date of fieldwork | 31/8/2019 | 30/8/2019 | 30/8/2019 | |||||||
Base camp location | Lipis town | Temerloh | Jengka town | |||||||
Geologic age | Late Permian | Middle - Late Triassic | Late Triassic | |||||||
Geologic Formation | Gua Musang | Semantan | Kerum | |||||||
Secondary data (Related records): Paleontology report - fossils | Fieldwork location | Gua Bama | Kechau | Merapoh | Mentakab | Chenor | Bera | Jengka | Kuala Krau | Jerantut |
Brachiopod | 26 | 21 | 19 | 13 | 18 | 30 | 18 | 30 | 22 | |
Bivalve | 18 | 28 | 17 | 20 | 17 | 21 | 12 | 28 | 20 | |
Cephalopod | 6 | 8 | 11 | 6 | 7 | 8 | 8 | 5 | 3 | |
Porifera | 12 | 2 | 0 | 5 | 6 | 5 | 3 | 5 | 0 | |
Unidentified fossils | 27 | 31 | 12 | 18 | 19 | 28 | 20 | 22 | 27 |
The image below shows the data collected and viewed in ArcGIS Online Map Viewer. The base camp (primary data) and fieldwork (related record) locations are plotted on the map based on the answers given in the survey. Details of primary data on the fieldwork are categorized as 'Paleontology report', while related records on the number of fossils collected are categorized as 'Paleontology report - fossils'. A dashboard is created from Map Viewer for display and visualization purposes.
Use any of the workarounds below to view related records in Operations Dashboard for ArcGIS.
Use the List or Details element and configure Layer Actions for map interactions
This option is suitable for spatial and non-spatial related records. Configuring either the List or Details element displays the related records on the dashboard. Also, configuring Layer Actions between dashboard elements allows interactions by triggering an event in the target element when data in the source element is selected.
Note: Currently, Operations Dashboard for ArcGIS only supports related records at the visualization level. Querying related records is not possible.
Note: Alternatively, configure the Details element to display related records on the dashboard. Click Add > Details, and select the related records layer. However, unlike the List element, users are unable to configure field formatting, and set Details as the action source.
The Map element is linked to the List element. Based on the image below, clicking a primary data shows only the related records associated with the primary data. Three records out of nine related records appear in the List element (target field) when one data in the Map element (source field) is selected.
Note: It is possible to set the List element as the source field, and the Map element as the target field. This way, clicking the data in the related records List element flashes or zooms to the location of the data on the Map element. Refer to Operations Dashboard for ArcGIS: Actions for more information on using widgets as source or target actions.
Configure a survey to have a geopoint question within each repeat and show the related records as pop-ups in Operations Dashboard for ArcGIS
This method is suitable for spatial related records. Creating a survey form in Survey123 Connect for ArcGIS with a geopoint question in each repeat simplifies visualization of the related record on Map Viewer, and on Operations Dashboard for ArcGIS.
Note: Nested repeats cannot be viewed on ArcGIS Online Map Viewer and other related web apps, including Operations Dashboard for ArcGIS.
Clicking any related record on the map opens the details in the pop-up window, as shown in the image below.
Clicking the related records on the dashboard opens the pop-up window displaying the related records, as shown in the image below.
Note: If the pop-up display does not appear in Operations Dashboard for ArcGIS, navigate to the upper left corner of the map, and click the Configure icon . Enable the Pop-ups field on the Settings tab of the Map window and click Done.
Get help from ArcGIS experts
Download the Esri Support App