Restrict to one survey per geometry in Field Maps

MarcelBeckmann

I am using Field maps to collect geometries. With the popups in the WebMap we created a link from the Field Map Apps to Survey123 where a survey can be filled out as described here: https://doc.arcgis.com/de/survey123/reference/integratewithotherapps.htm

This is working fine so far. But for every geometry there is the possibility to fill out multiple surveys. This would be a one-to-many-relationship (1:n) . So there can be many surveys for one single geometry.

I would like to implement a one-to-one-relationship (1:1). Meaning for one geometry only one survey can be filled out. Is there a way to achieve this behaviour?

 

GlenShepherd

Hi @MarcelBeckmann ,

To my knowledge, in the configuration you've described, there is no setting that we can establish to restrict how many surveys (related records) can be submitted per feature.

However, you could set up the layers in your web map to behave a certain way to prevent additional edits to geomtries that have related records...

• Create a Spatial Join (using Map Viewer) between the feature layer and the related table, and output a joined view layer. 
• Apply a filter to the view layer so that you're only rendering geometry that without a related record
• Add your Survey123 URL to the pop-up of this layer

Now users will only be able to see geometry and complete surveys for records that are yet to be surveyed. And once they have been surveyed, the filter will remove the feature from the web map.

 

Keep in mind, these joined view layers don't work offline unfortunately.