topic Arcade Count Attachments in Related Table in ArcGIS Online Questions

Arcade Count Attachments in Related Table

MarcoPoetsch — Mon, 15 Nov 2021 02:17:56 GMT

Hello all,

I would like to return the number of attachments in a related table.
Is this possible?

I know how to count he number of related records, and I know

var relatedrecords = FeatureSetByRelationshipName($feature, "MonitoringPhotoSites") var cnt = Count(relatedrecords); return cnt;

And I know how to count the attachments in the feature

Count(Attachments($feature)

But I'm not quite sure how to combine those two together. Has anyone an idea?

Cheers,

Marco

Re: Arcade Count Attachments in Related Table

JohannesLindner — Mon, 15 Nov 2021 06:34:44 GMT

Something like this?

var related_records = FeatureSetByRelationshipName($feature, "MonitoringPhotoSites") var cnt = 0 for(var rr in related_records) { cnt += Count(Attachments(rr)) } return cnt

Re: Arcade Count Attachments in Related Table

MarcoPoetsch — Mon, 15 Nov 2021 19:03:44 GMT

Yep, thats it. Not sure what I did wrong. I tried a for loop, but it seems that I missed something...

Anyway, thanks Johannes!