topic Simple Arcade Question in ArcGIS Online Questions

Simple Arcade Question

YS2388 — Thu, 13 Jul 2023 21:46:21 GMT

Hi there,

I am new to Arcade programming and I have a simple question:

This is a standard scenario: I have created a feature point layer and a related table for use in Field Maps. This is a one-to-many relationship. Someone has gone out and collected multiple records for each point.

In Map Viewer, I would like the pop-up for the point layer to display the number of records for that point.

In the point layer's pop-up configuration I enter the following expression:

var relRecord = FeatureSetByRelationshipName($feature, "Rel_table");
var cnt = Count(relRecord);
return cnt;

When I click on any point the total number of records is always 1, even though there are always more than one.

Thank you for the help.

Re: Simple Arcade Question

JohannesLindner — Sat, 15 Jul 2023 00:10:28 GMT

Hmm, does it work if you filter the related table yourself?

var rel_fs = FeaturesetByPortalItem(...) var common_val = $feature.CommonField var rel_rows = Filter(rel_fs, "CommonField = @common_Val") return Count(rel_rows)

Re: Simple Arcade Question

YS2388 — Mon, 17 Jul 2023 17:10:37 GMT

Hi Johannes,

Thanks for the suggestion. I tried filtering and still have only the first record returned.