Survey123 using existing feature layer. Survey publishes but cannot load data or submit new records.

Question

Hi,

I am running into an issue when publishing a new survey that is based on an existing feature class. The feature class is a polyline detailing information on assets and the table contains information on inspections. The table has a 1 to many relationship to the feature class using GlobalID and GUID fields.

The survey publishes perfectly fine. I can see the data in the survey123 web app but when selecting one the slide-out form loads continuously. I think the problem may be the relationship between the table and polyline field selecting from one does not auto select from the other table (although it works just fine in ArcOnline). Looking through the network logs i was able to identify an issue related to a query (see attached image). Im unsure on how to fix the issue and where to go next. Any help would be appreciated. I have also attached the xls file.

many thanks

Form 8.xlsx

query error.PNG

query response error.PNG

AdamTerrell_7-1720712588709.png

AdamTerrell_5-1720712518652.png

lzorloni_1-1720712408825.png

RABConsultants · Answer

In the end, I had to delete the relationships and then remake them in ArcGIS Pro and then reshare them in AGOL. After doing that it worked for some reason.

dougbrowning · Answer

On an existing service it would not be able to create a new one.  I do not see the field parentglobalid in your form.  You need to use the 123 convention and match that.  I suggest you make a new form based on this excel, publish it, then look at the schema.  Then match your existing to this schema.  Wait in fact I do not see a GUID field in your repeat at all?  Even if in the service it needs to be in the form and match up.

You can also have 123 build a form from the service you have and see what it looks like. Then match.

I honestly do not know if 123 can use a diff relationship or not.  I would do the two above and see what you can figure out.  It is not a 1:1 relationship is it?

This page is unclear  https://doc.arcgis.com/en/survey123/desktop/create-surveys/survey123withexistingfeatureservices.htm

Hope that helps

RABConsultants · Answer

thanks for looking at this Doug, i have implemented the changes as suggested but still coming up with the same issue. Can i just check something, when creating a survey on an existing feature class i assumed it used the existing GlobalID and GUID but from your suggestion survey123 makes a new one? If that is the case that is not happening for me and could be a possible cause?