topic Re: Add Related table attributes onto polygon's pop-up in ArcGIS Online Questions

Add Related table attributes onto polygon's pop-up

LearnThenShare_JC — Sat, 01 Apr 2023 04:13:18 GMT

Hello! I need assistance with adding related table fields to a polygons popup. The source data is below.

polygon: https://maps2.dcgis.dc.gov/dcgis/rest/services/DCGIS_DATA/Property_and_Land_WebMercator/MapServer/40

Re: Add Related table attributes onto polygon's pop-up

KenBuja — Mon, 03 Apr 2023 14:02:38 GMT

This expression will show how many surveys from the table have been done at a property.

var related = FeatureSetByRelationshipName($feature, "DCGIS.SURDOCS"); var output = `${count(related)} survey`; if (count(related) != 1) output += "s"; return output;

You can use that expression in the popup like this

Re: Add Related table attributes onto polygon's pop-up

LearnThenShare_JC — Mon, 03 Apr 2023 21:16:20 GMT

Hi @KenBuja , Thank you for the expression. If I am looking to add the one or more attributes from the related table, not simply a count, is there an additional Arcade expression that makes that happen? The related table has an image type field and an image URL. I would like the image type attribute(s) and the image URL(s) to show in the popup - not only accessible in the "related tables" link at the bottom. Thank you!

Re: Add Related table attributes onto polygon's pop-up

KenBuja — Tue, 04 Apr 2023 13:31:59 GMT

This expression will show each of the surveys' url

. However, I don't think there's currently a way to make each of them clickable

Re: Add Related table attributes onto polygon's pop-up

LearnThenShare_JC — Wed, 05 Apr 2023 15:02:33 GMT

Hi @KenBuja : Thank you again for the additional expression! This is very promising. I do wonder what are the technical limitations specific to bringing in the full data from related tables. I will implement the expression that you provided and let you know when it works (and accept as solution), and I will let you know if I find out how to make all the link data actual links to the image. Thank you!!!

Re: Add Related table attributes onto polygon's pop-up

KenBuja — Wed, 05 Apr 2023 16:05:54 GMT

All the attributes from each related record are available to the popup, as shown in this script.

Re: Add Related table attributes onto polygon's pop-up

KenBuja — Fri, 07 Apr 2023 13:27:13 GMT

With some more work, I was able to get a clickable link for each related survey. This is using the popup content element. Add in an Arcade element and use this script

Re: Add Related table attributes onto polygon's pop-up

LearnThenShare_JC — Fri, 08 Sep 2023 18:30:36 GMT

Hi @KenBuja

Can you assist again with a similar expression? FYI I am still on Classic Map if that matters here.

The polygon: https://maps2.dcgis.dc.gov/dcgis/rest/services/DCGIS_DATA/Property_and_Land_WebMercator/MapServer/40

The fields from the related table for the popup:

BIDNAME ( type: esriFieldTypeString, alias: BIDNAME, length: 50 )
BIDTOTALDUE ( type: esriFieldTypeDouble, alias: BIDTOTALDUE )
BIDCOLLECTED ( type: esriFieldTypeDouble, alias: BIDCOLLECTED )
BIDBALANCE ( type: esriFieldTypeDouble, alias: BIDBALANCE )

Thank you!

Re: Add Related table attributes onto polygon's pop-up

KenBuja — Fri, 08 Sep 2023 19:47:15 GMT

Give this a try:

var rec = First(FeatureSetByRelationshipName($feature, "DCGIS.ITSPE", ['BIDNAME', 'BIDTOTALDUE', 'BIDCOLLECTED', 'BIDBALANCE'])); return `${rec.BIDNAME} • Total Due: ${Text(rec.BIDTOTALDUE, '$#,###.00')} • Collected: ${Text(rec.BIDCOLLECTED, '$#,###.00')} • Balance: ${Text(rec.BIDBALANCE, '$#,###.00')}`