One-to-One Joins in Survey123 Connect

[Anonymous User]

Hello,

I have a feature service that includes one points layer and 5 related tables, which are related using relationship classes. Of the 5 tables, 3 used a one-to-one and 2 used a one-to-many. When I created a new form from the feature service in Survey123 Connect, only fields from the tables using a one-to-many join were included.

Is it possible to use a one-to-one join for the source data?

[ZacharySutherby · Accepted solution]

Hello Jennifer Hopkins‌, 

ArcGIS Survey123 only supports 1:Many GlobalID to GUID relationships when working with existing feature services and related tables. One to one relationships are not supported. 

Please use the note at the bottom of the Prepare a feature service section of this documentation for reference: Use Survey123 with existing feature services—Survey123 for ArcGIS | Documentation 

A workaround if you don't want folks adding many records in the related table is to use a repeat count. If you would only like one record in the related table when taking a survey you can specify the repeat count to 1 which will only allow for one submission. 

Please use this link for reference: Repeats—Survey123 for ArcGIS | Documentation 

Please note although the repeat count it set to 1 if you have the inbox enabled and folks are editing existing records through the inbox they will be able to add new records to the related table. 

Thank you, 

Zach