One-to-One Joins in Survey123 Connect

241
1
Jump to solution
08-04-2020 09:44 AM
JenniferHopkins
New Contributor III

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?

0 Kudos
1 Solution

Accepted Solutions
ZacharySutherby
Esri Contributor

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 

View solution in original post

0 Kudos
1 Reply
ZacharySutherby
Esri Contributor

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 

View solution in original post

0 Kudos