Is there a way to count how many records have an attachment (photo) or do not have an attachment

Question

Is there a way I can create a widget in a Dashboard that shows the count of records that have a photo attached (or does not have a photo attached).

I'd like to be able to export a list of all records that do not have a photo attached and also show them on the map so they can be revisited

JamesPoeschel · Answer

Have you tried using the Count function on attachments in arcade?

Count(Attachments($feature))

You could create a calculated field that has something like this:

If(Count(Attachments($feature)) > 0) {
  return 'Has pictures'
} else {
  return 'No pictures'
}

From there perhaps you could create a widget that exports either or. Or a filter to show only features with or without pictures, then export.