Publishing Survey that uses nested Related Tables

Question

Hi all,

I am using Server 10.5 that is non-federated.

I have a feature class(Substations), which is related to another feature class(Equipment), which is related to a table(Inspections). When creating a survey off of an existing feature service( which contains all three items above with the method listed in this documentation: How To: Create Survey123 for ArcGIS surveys that connect to non-federated ArcGIS Server services), I only have the first two feature classes put into my table. I am wondering if it is possible to have multiple nested related tables in a single survey?

Anonymous User · Answer

Without seeing your database schema, it sounds as though the form is looking for the established relationship between the parent and the child.

Here are some assumptions:

1). Your database schema is the Substation feature with a bunch of related tables that pertain to each type of asset found within the substation?

2) You are attempting to allow for a user to enter multiple assets at one time within the related table?

3). You want the data to populate out in columns instead of rows for each asset type within your related tables? Meaning, that you would rather have the data populate new columns instead of new rows when being submitted into the table.

Are these correct assumptions?

What did you use to create the forms? Web based or Survey123 Connect? Which version are you using?

AaronThompson · Answer

Mike,

Thanks for the help, along with the detailed examples, I appreciate it!

What I'm trying to do now is publish a survey that allows repeats of related tables (multiple pieces of equipment, horizontally organized, not vertically), without gathering any data from the substation parent feature class. Is this possible? If I have multiple types of equipment in the same survey, with repeats, I get the error when publishing that says:

The custom feature service submission url is not compatible with this survey(Parent relationship Electric_Facilities not found for table Battery_Bank)

Ideas?

Anonymous User · Answer

Sorry, but one other possibility is to use the custom URL schema to push some attributes from the substation form into other survey forms that would then utilize the submission URL to submit data to the related tables for each substation feature.

Essentially, you could create the schema in ArcGIS desktop that would contain your location feature that contains each of the related tables, post to your server as a feature service, then create Survey123 forms that would match the related tables schema, and use the submission URL to submit data from the form into the related tables.