Survey123 related tables - copying over field from parent table

670
1
05-08-2020 04:15 PM
RyanWillshear1
New Contributor

Hello!

I have created a survey to capture photos taken at various sample sites and everything is working perfectly, except one thing. 

I have a group with text fields for site number and then a set of groups and repeats to be able to take multiple photos of a sample site. The photos are stored in related tables in ArcGIS Online and I have been downloading them with FME, no problem. Unfortunately the sample number is only recorder in the parent layer, it is not copied over to the related tables. 

Is there anyway to do this?

Thanks in advance

Tags (1)
0 Kudos
1 Reply
Jeff_VanEtten
Occasional Contributor

Ryan

I had to do this recently also.  The workaround is to add a hidden type in your repeat, calling it something like parent_object_id with a label of Parent reference (or whatever you want).  Then in the calculation column, you can add the parents ID column ${object_id}.  This will pull this through for all repeats.  Below is a link where I found this recently.

https://community.esri.com/groups/survey123/blog/2020/04/09/survey123-tricks-of-the-trade-repeats 

Cheers

Jeff

Jeff Van Etten
Head of GIS
Tetra Tech Ltd
0 Kudos