idea Set map symbol styles based on attribute from relationship table in ArcGIS online in ArcGIS Online Ideas

Set map symbol styles based on attribute from relationship table in ArcGIS online

GeorgieCassar — Tue, 05 May 2015 00:53:42 GMT

It's great now that ArcGIS online supports relationship classes. It makes it easy to insert multiple inspections on an asset. However, it's difficult for an inspector to visually see which assets they have already visited.
I would like to see the ability to symbolise the main feature by a statistic of its related records eg. Count of attribute from related records. Currently you can add that statistic to the origin feature's popup. We just need to add ability to symbolise by that value.

Re: Set map symbol styles based on attribute from relationship table in ArcGIS online

PaulCone — Tue, 22 Jun 2021 08:59:55 GMT

You might be interested in this related idea for Collector...

https://community.esri.com/ideas/10683

Re: Set map symbol styles based on attribute from relationship table in ArcGIS online

PaulCone — Tue, 22 Jun 2021 08:59:58 GMT

Also this idea has already been posted...

https://community.esri.com/ideas/10515

Re: Set map symbol styles based on attribute from relationship table in ArcGIS online

simoxu — Wed, 05 Aug 2015 02:44:28 GMT

It's essential!

Re: Set map symbol styles based on attribute from relationship table in ArcGIS online

JustinConnerWR — Thu, 08 Jun 2017 16:54:28 GMT

This can be done as a separate query layer based on most recent related record, but it is cumbersome.

Re: Set map symbol styles based on attribute from relationship table in ArcGIS online

KatieSteele — Tue, 27 Jun 2017 13:50:27 GMT

Come on ESRI!!! We need this!!! Make it a reality!!

Re: Set map symbol styles based on attribute from relationship table in ArcGIS online

SébastienPerret — Tue, 11 Jul 2017 13:18:29 GMT

This would indeed be very useful for field work (particularly for teams). While it is possible (though laborious) to implement workarounds, the updates of the symbology take up to one minute or more (depending on the refresh interval set on the webmap).

Re: Set map symbol styles based on attribute from relationship table in ArcGIS online

RichardSmith2 — Wed, 04 Oct 2017 21:23:12 GMT

It is crazy that this request has almost 1000 votes including the ideas that have been merged with it and is still only on "reviewed". This has got to be the most important capability for anyone who wants to use Collector to do field inspection reports. A visual way to identify assets that have changed status as a result of an inspection is a necessary capability.

Re: Set map symbol styles based on attribute from relationship table in ArcGIS online

HuongTran1 — Thu, 30 Nov 2017 22:07:14 GMT

I am trying to achieve this by selecting max date and grouping by fileNum when I publish this map I get warning messages, in AGOL I can only see my related table no feature. Any help would be appreciated.

Re: Set map symbol styles based on attribute from relationship table in ArcGIS online

Zach_Robinson — Mon, 29 Oct 2018 22:54:22 GMT

It's been a year since the last comment on this idea. This seems so essential to me! I hope ESRI can provide an update to this idea soon.

Re: Set map symbol styles based on attribute from relationship table in ArcGIS online

CalebAnderson — Mon, 04 Nov 2019 20:01:14 GMT

Any word if there has been any traction here? I searched around for an option using Arcade and no luck.

Re: Set map symbol styles based on attribute from relationship table in ArcGIS online

AnooshehTarassoly — Tue, 11 Feb 2020 23:27:06 GMT

Need this so badly!

Re: Set map symbol styles based on attribute from relationship table in ArcGIS online

AnooshehTarassoly — Mon, 24 Feb 2020 17:27:01 GMT

PARTIAL SOLUTION: You can now create a join on AGOL between the layer and related record, keeping only the latest record or adding summery statistics from the corresponding records.

To symbolize by latest inspection:

Analysis --> Summarize Data --> Join Features

In box 4: Join one to one. Select "Define which record is kept." Select "Order By". Order by your date field, sort by Newest.

Check "Create results as hosted feature layer view"

You'll then have a new layer that you can use to symbolize by the latest related record. It updates automatically as the data changes in the original records/layer.

The limitation with this solution is you can't have a join/view layer on Collector map you plan on taking offline. If you try to download this map it will fail, which is a known limitation.

Re: Set map symbol styles based on attribute from relationship table in ArcGIS online

Virk_Navneet — Thu, 16 Apr 2020 15:58:48 GMT

This is key feature for large organizations where data is collected and managed by different departments and the GIS department consumes their data via related tables and shares maps/apps with entire organization for united workflow. Workarounds and doing this in a patch work way is not scalable and certainly not easily maintainable. Please consider adding this functionality to the next release.

Re: Set map symbol styles based on attribute from relationship table in ArcGIS online

MarioGilSanchez — Wed, 16 Jun 2021 07:20:57 GMT

It's essential! we need this funsjonality alt over in the world

Re: Set map symbol styles based on attribute from relationship table in ArcGIS online

LindsaySpencer — Fri, 23 Dec 2022 16:07:28 GMT

This is a similar idea to what I need - basically wanted to use arcade to create a feature set from the related records, and use that to symbolize the parent feature! Please help get this idea off the ground!

Re: Set map symbol styles based on attribute from relationship table in ArcGIS online

HollyTorpey_LSA — Wed, 26 Nov 2025 20:36:12 GMT

It's been 10 years and 213 kudos. Is this even under consideration? It's so important, and all the workarounds are clunky.