Multiple photos Survey 123

Question

My survey allows for multiple photos. Once I download and extract the photos, is there an automated way to join the photo names from the attachment table to the one record for that survey? Ideally, I would like each record in my survey to have a field for [PHOTO1], [PHOTO2], [PHOTO3], etc.

TamsynG · Answer

Hi Jodie, Did you ever resolve this issue? I am in the same situation where I have more than one photo related to a record and I cannot seem to get a one-to-many join to work in ArcGIS Pro

Jodie_M_Gosselin · Answer

Yes, I would like to add many fields to the record in the parent feature class. I would like each field to hold one photo name that is associated with that feature in the ATT_NAME field. So I'd like to add the fields [PHOTO1], [PHOTO2], [PHOTO3], and so on. Some of my records have up to 21 photos and I'd like to have each photo name captured in the parent feature class. I need this to send to another department in Excel so that they can reference the photos as they are stored on our server.

Anonymous User · Answer

Hello Jodie,

So, you are attempting to the push the "names" of the photos found within the "ATT_NAME" data field of the attachment table into a data field within the parent feature class?

Is that what you are trying to do?