topic Re: Publish Survey123 Connect with repeats not working in ArcGIS Survey123 Questions

Publish Survey123 Connect with repeats not working

janderson_ksninc — Wed, 06 Apr 2022 18:51:50 GMT

I have created a survey in Survey123 Connect from a hosted feature layer with a point layer and a related table to hold the survey results. After I published the hosted feature layer, I was asked to add a couple of repeats to the form. After adding the repeats, the survey would not publish/update. After doing some reading, I learned that I am not able to add repeats to an existing survey and publish it (unless I'm mistaken). I then recreated the survey by copying over the survey questions/choices, etc from the first survey to the new form.

Now, when I go to publish the survey, I get the following error:

Does the hosted feature layer need to already have tables for the repeats added to it prior to creating the survey? Can anyone help with this?

Re: Publish Survey123 Connect with repeats not working

HuubZwart — Wed, 06 Apr 2022 19:28:20 GMT

Yes, either have the existing feature service match the data model (i.e. have a point layer and table with all fields configured) or create a new feature service from scratch from Connect upon publishing. For the latter to work remove the submission url/item from the settings tab in the XLS if you copy from your old XLS, this references the existing item to update.

Re: Publish Survey123 Connect with repeats not working

DougBrowning — Wed, 06 Apr 2022 20:17:24 GMT

You need to match the Name column on the begin repeat line to your repeat table name. That is how it finds it.

Re: Publish Survey123 Connect with repeats not working

janderson_ksninc — Thu, 28 Apr 2022 18:25:59 GMT

I'm not sure who marked this as a "solution" but changing the name of the repeat to match the related table does not allow me to publish. I just got off the phone with Customer Service and I can't seem to get a straight answer. All I'd like to know is: Does Survey123 Connect support having repeats when the survey is created from a feature service with a related table? If yes, then can someone please show me how to do this? If not, then I'd like to get a definitive "no, that's not possible." If someone could clear this up, that would be much appreciated!

Re: Publish Survey123 Connect with repeats not working

DougBrowning — Thu, 28 Apr 2022 18:57:20 GMT

Yes its possible I have a lot of them. The layer or table name has the word repeat in it? The error is saying the names do not match. Can you post a screen shot of the form at least and a screen shot of the service.

Re: Publish Survey123 Connect with repeats not working

janderson_ksninc — Thu, 28 Apr 2022 21:26:30 GMT

@DougBrowning - Thanks for responding! For this example, I created a new, fake survey as I didn't want to risk unintentionally editing an existing survey. I attached screenshots of the form, XLS form, feature service, the error that I'm getting, and the settings page of the XLS form. Please let me know if you spot something that I'm missing. Thanks again!

Re: Publish Survey123 Connect with repeats not working

DougBrowning — Thu, 28 Apr 2022 21:33:59 GMT

Can you screen shot the service page though also. Link in the bottom right.

I think it may be that form_id should match the main layer name Fake_Survey_Points and then the repeat name matches the table. You got the repeat table name in both spots. Try that quick. If not post the rest page.

Re: Publish Survey123 Connect with repeats not working

janderson_ksninc — Thu, 28 Apr 2022 21:37:55 GMT

@DougBrowning - Would you be willing to post a screenshot of a feature service showing the feature layer and related table along with screenshots of the XLS form (survey and settings pages) configured to accept repeats?

Re: Publish Survey123 Connect with repeats not working

DougBrowning — Thu, 28 Apr 2022 21:45:21 GMT

Hope that helps you are just matching up the names in the two places. That is how 123 finds them.

Re: Publish Survey123 Connect with repeats not working

janderson_ksninc — Thu, 28 Apr 2022 22:20:52 GMT

So, I redid the survey and changed it so that the form ID matches the main layer (point layer) and the name of the repeat matches the related table and now I'm getting this error:

The error says that I don't have a label when I clearly do. What am I missing?

Re: Publish Survey123 Connect with repeats not working

janderson_ksninc — Thu, 28 Apr 2022 22:29:17 GMT

I also noticed that your example differs from mine in that your Form ID is pointing to a point feature layer (PFCLentricForm) and your repeat also points to a point feature layer (PFCLentricFormWaypoints) whereas my example has a point feature layer and an actual table that are related to each other.

Re: Publish Survey123 Connect with repeats not working

janderson_ksninc — Thu, 28 Apr 2022 22:32:33 GMT

Re: Publish Survey123 Connect with repeats not working

DougBrowning — Thu, 28 Apr 2022 23:05:57 GMT

My example was a feature yes but normally I do tables. Sorry bad example but it should make no diff as long as they match.

Yea this label one is really weird. Cannot say I have seen that on before esp since you do have one. Maybe you copy pasted and did not use Paste Values? I would just try changing the text maybe it does not like the 1 or something and maybe paste in from the row above to fix the validation. Weird one. This post says its just a warning and not a big deal https://community.esri.com/t5/arcgis-survey123-questions/suppress-question-has-no-label-warnings/td-p/842061

I also see you have a reserved word on Condition. Could be some of the issue.

But your main problem I think is fixed so you can use it on the original survey.

Hope that helps

Re: Publish Survey123 Connect with repeats not working

janderson_ksninc — Thu, 28 Apr 2022 23:13:29 GMT

@DougBrowning- I guess the part that I'm struggling with is the fact that I don't want the survey results to go to the point layer but rather I'd like the survey results to go to the related table. If I change the Form ID to the point layer, doesn't that defeat the purpose of having a related table to hold the survey results? The label issue resolved itself btw, wierd.

Re: Publish Survey123 Connect with repeats not working

DougBrowning — Thu, 28 Apr 2022 23:54:53 GMT

Well you can make the repeat the form but then you need to fill out 1 form per repeat record. Hard to tell not knowing your workflow. But the form has to have a top level that goes somewhere. I guess I am not sure what the top level is that you do not want to edit. What you want to do is just a bit funky. One idea is a dummy parent layer and then feed the repeat to the other table. Sorry not much to go on. You can pm me if you like.

Re: Publish Survey123 Connect with repeats not working

GarrettRSmith — Mon, 09 May 2022 03:21:54 GMT

Hi @janderson_ksninc have you found out how to make this work?

I am also having the same issue and wanted to know if you have found a workaround?

I am trying to use a table for the Form ID and then two repeats that point to a polygon and line feature class. When I try to publish the survey I get an error stating:

"Parent layer id 2 not found for table CampsiteArea".

CampsiteArea is a polygon feature class.

Re: Publish Survey123 Connect with repeats not working

Amarz — Fri, 06 Sep 2024 00:06:51 GMT

If you are attempting to repeat the same point with new data, could you reference the Form ID from the same survey?