S123 and non-unique database field name (existing feature service)

103
2
Jump to solution
01-04-2019 02:07 PM
Highlighted
Occasional Contributor II

I'm developing an S123 form using an existing feature service that has a common key in three related feature classes. The field name is the same, but they are in different feature classes. The Survey123 documentation states:

  • The name column determines the name of the ArcGIS feature service column in which the response to the question will be stored. No spaces or special characters are allowed in this column. No two rows can have the same content.

The feature service also has relationship classes using globalid-guid and takes advantage of this. There are several reasons why we use this common key. One is in this thread related to parent-grandchild relationships. My latest reason is for wanted to use the batch attribute editor widget in WAB. This requires that fields have the same name if you want to batch edit the same field in different feature classes.

I know this is possible because I did it...the xlsform give a warning by highlighting the cells red, but otherwise it publishes just fine and collects data without any issue. But I'm just curious if this is likely to be possible in the future. In other words, is it probable that future releases will make this no longer possible. 

Reply
0 Kudos
1 Solution

Accepted Solutions
Highlighted
Esri Frequent Contributor

Hi Jimmy,

As per the documentation, having two field names with the same exact name is not supported by Survey123. This will not be supported in future either and is a known limitation for several reasons.

Whilst you may have been able to successfully publish the survey, note there could be issues with submitted data to these fields via the field app and web app, and issues when trying to modify the survey and republish, or issues when trying to use the Survey123 website and some of the analysis and feature reporting tools. Therefore is it not recommended to publish surveys that contain two questions with the same name field.

Regards,

Phil.

View solution in original post

2 Replies
Highlighted
Esri Frequent Contributor

Hi Jimmy,

As per the documentation, having two field names with the same exact name is not supported by Survey123. This will not be supported in future either and is a known limitation for several reasons.

Whilst you may have been able to successfully publish the survey, note there could be issues with submitted data to these fields via the field app and web app, and issues when trying to modify the survey and republish, or issues when trying to use the Survey123 website and some of the analysis and feature reporting tools. Therefore is it not recommended to publish surveys that contain two questions with the same name field.

Regards,

Phil.

View solution in original post

Highlighted
Occasional Contributor II

Hi Phil,

Thanks for the info. Since it allowed me to publish the survey, I was just curious if maybe this was allowed/possible, but not recommended or advertised. We'll figure out a different way to implement this to avoid any issues in the future.

Jimmy