idea Show Related Records in Pop-Up in ArcGIS Online Ideas

Show Related Records in Pop-Up

ChristopherStrong — Tue, 22 Jun 2021 09:02:11 GMT

There have been other versions of this idea that have been flagged as "implemented", (https://community.esri.com/ideas/9541 and https://community.esri.com/ideas/11131 ) but the ability to show or format related records in the pop-up still does not exist.

It would be great to show a list of the related records in a feature's pop-up. I'd like people to be able to view different contact information when clicking on a building, but the only way for this to work currently is by creating a long one-to-one join and publishing that as a service or by forcing users to open the table. Both have implications with data design and user experience.

Both of the previous ideas where marked as implemented, but the 2016 update to ArcGIS Online only added related table functionality in the webmap's Details Page (which is not a user friendly way to interact with a webmap). The 2016 update also allowed the ability to summarize related data (Configure pop-ups—ArcGIS Online Help | ArcGIS ), so one-to-many relationships with text display a feature count. Again, while an improvement, this isn't terribly helpful for those wanting to view one or two details stored in a related table.

I understand it may be difficult to display potentially complex relationship information in a small pop-up, but I have faith in ESRI finding a way to make this better if they continue to work on it.

Re: Show Related Records in Pop-Up

AmyRoust — Wed, 07 Sep 2016 13:27:29 GMT

The June 2016 release got closer to this, but I agree that there are still enhancements needed. Right now, I have a polygon feature class that has a many-to-one relationship with a table. I really need to be able to show the records in the related table in our pop-ups, but that appears to be the only relationship that is not currently supported.

Re: Show Related Records in Pop-Up

MelanieRosenberg2 — Wed, 28 Sep 2016 21:48:46 GMT

I vote for complex relates! We NEED a way to host a view relates and joins in the cloud, where I can access related records to a table that is related to the features. Or simply viewing/editing/relating tables without spatial features.

Re: Show Related Records in Pop-Up

Anonymous User — Tue, 03 Jan 2017 19:38:09 GMT

Yes, it would be useful to us also to see them in the popup. With complex relates and views. In the Attrib Table is nice but not as friendly in certain use cases.

Re: Show Related Records in Pop-Up

TiiuKelviste1 — Thu, 27 Jul 2017 07:22:29 GMT

Yes, please make this online software more advanced. It's not logic to hold data any other way than using relationships but right now you have to make many workarounds to get to see what you need. Multi-tabbed pop-up could solve this from the users perspective - one, still small pop-up but related records all shown in one place and separately configurable as it is now.

Re: Show Related Records in Pop-Up

JRAdams — Tue, 06 Mar 2018 17:00:45 GMT

Is this on the road map? Any ideas on when 1 to M relationships will be viewable in pop-ups??

Re: Show Related Records in Pop-Up

deleted-user-aIw_A3YQRnA9 — Fri, 08 Jun 2018 19:06:00 GMT

June 2018 - Building out an application that has an extensive array of related tables - spent so much time on my tables! Wish so much that I could display the related attribute information in my pop ups!

Re: Show Related Records in Pop-Up

erica_poisson — Fri, 27 Jul 2018 18:13:23 GMT

For those of us using Collector as a means for inspecting assets, it would be VERY nice to be able to view related information in a pop-up window, as in many cases each related record has a photo attachment representing the status of the asset at that visit.

Re: Show Related Records in Pop-Up

BrianFausel — Thu, 09 Aug 2018 15:40:51 GMT

Voted up. Its frustrating that this functionality is available in some apps but can't be as easily achieved in WAB. I have a partial workaround in this similar Idea thread involving the "Near Me" widget.

Re: Show Related Records in Pop-Up

JillThornton1 — Sat, 11 Aug 2018 15:11:12 GMT

Yes. Yes. A thousand times Yes. Sure do wish this was a basic out of box feature for AGOL!

Re: Show Related Records in Pop-Up

PatrickSmyth1 — Tue, 27 Nov 2018 17:05:43 GMT

Still nothing it seems? Can't display related table information that is a string in pop-up as anything other than aggregate stat (count? what good does that do anyone?)

Re: Show Related Records in Pop-Up

KevinLambeth1 — Mon, 07 Jan 2019 20:23:11 GMT

This would be extremely helpful especially and much easier for our consumers to understand.

Re: Show Related Records in Pop-Up

FernandoAlvarez — Tue, 26 Feb 2019 23:36:20 GMT

While it is nice to see the "see related records tab" it still not sufficient. Having related records would open the door for better deliverables on WAB. Its been 3 years since this was introduced, please add this feature to your plan.

Re: Show Related Records in Pop-Up

JonathanSkloven-Gill — Fri, 15 Mar 2019 17:03:09 GMT

What is the point of GIS online (aka a relational database of data and geography), if you cannot access, display, design around said related data? ArcGIS Online has been around for a while now, this needs to become real

Re: Show Related Records in Pop-Up

MichaelVolz — Fri, 26 Apr 2019 17:13:10 GMT

Unless I'm mistaken it seems like this Idea has been implemented, it's just that there are bugs associated with it especially with regards to showing related records in date order which would be important in inspection result type apps where you would revisit the site multiple times.

It seems like this thread is directly related to this issue as pop-ups in web app builder can display related records:

https://community.esri.com/thread/183860-is-sorting-related-records-in-web-app-builder-possible

Re: Show Related Records in Pop-Up

MichaelKelly3 — Sun, 12 Dec 2021 11:54:13 GMT

This can be achieved using Arcade in the Popup - something like this does the trick:

var related_table = FeatureSetById($datastore, "1");
var filter_query = "parentglobalid = '" + $feature["globalid"] + "'";
var related_data_filtered = Filter(related_table, filter_query);
var related_data_filtered_count = Count(related_data_filtered);

var output = "";
if (related_data_filtered_count > 0) {
    output = "Total of " + related_data_filtered_count + " records";
    for (var relatead_data_row in related_data_filtered) {
        output += TextFormatting.NewLine + relatead_data_row.FieldName1 + " - " + relatead_data_row.FieldName2;
    }
} else {
    output = "No Related Records...";
}

return output;‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

It outputs all of the related data which can be formatted as needed in the popup.

The outputs can be configured as appropriate. Some config changes necessary depending on your setup (in this case Global ID's are used for the relationship, and the fields being used are FieldName1 and FieldName2).

Re: Show Related Records in Pop-Up

Anonymous User — Wed, 07 Aug 2019 16:02:14 GMT

Hi Michael,

Using this expression, how would I be able to get related photos to show in the popup? I'm needing this functionality on several projects and it has been plaguing me. Is this even possible?

Re: Show Related Records in Pop-Up

JanineLatham — Thu, 12 Dec 2019 15:05:03 GMT

Did you find a resolution for the related photos to show in a popup?

Re: Show Related Records in Pop-Up

Anonymous User — Fri, 13 Dec 2019 17:25:46 GMT

This is not possible with Arcade. However, it is possible to create Web Maps with attachments displayed in a popup when configured with the Map Viewer Beta - more info here. These new features are only compatible with applications written with the 4.x API.

If using 3.x, you have to run something like this which copies the Attachment URL to an attribute field so it can be viewed in the popup.

Re: Show Related Records in Pop-Up

JaredPilbeam2 — Thu, 16 Jan 2020 18:42:36 GMT

Michael,

So you're saying there is no way at all to view related photos in popups in either AGOL or Portal?