How to Sort Point Feature Data Table in AGOL by "Has Attachments" / "Does Not Have Attachments"

GrantKaye

Hi - I have a point layer in ArcGIS Online with ~700 point records. Some points have attachments, some do not. See attached screenshot. 

The table will not allow sorting by this column. When I export this layer as a CSV, the "Photos and Files" column is not exported. 

I need to make a "to-do" list of points that do not have Photos attached.

How can I make this list?

Screenshot 2024-03-03 at 10.02.13 AM.png

KoryKramer_0-1732199900411.png

RoryMcPherson

You can use Arcade to return a count of attachments. You can do this in ArcGIS Pro or ArcGIS Online. You could also choose to apply this to symbology to see which features have attachments, or you could use this in a field calculation to write the total number of attachments to a given field. If you don't want to modify your schema by adding a field for this, in ArcGIS Pro you could create a selection of features with attachments and then export a csv file from that. Hope that helps.

// Returns the number of attachments associated with the feature
Count(Attachments($feature))

Here is a link to the Arcade documentation for Attachments.