topic Re: Survey 123 - Repeat Count not allowing to publish form in ArcGIS Survey123 Questions

Survey 123 - Repeat Count not allowing to publish form

RobertMEIER — Mon, 03 Dec 2018 19:26:39 GMT

I have a related table in my service and when I set the repeat count and try and republish, it says 1 field does not exist in the feature layer.

I have a log file set up for survey 123 and can see it checking for a field called <my repeat table name>_count (RampInspection_count) and then saying it can't find it.

I have attached the log file.

FYI, even if I put zero in the count, I still get the error, only of it is blank can I republish the survey.

Do I have to add this column to my feature layer?

Thanks!

-bert

Re: Survey 123 - Repeat Count not allowing to publish form

Anonymous User — Mon, 24 Dec 2018 00:39:39 GMT

Hi Robert,

This is a bug we have seen before, however I believe it has been resolved.

Based on the logs, it appears you are using version 3.0 of Survey123 Connect, have you tested with 3.1? Also, there is a beta version available on EAC if you can also test with the latest version?

Are you publishing to AGO or Portal, if so what version?

Phil.

Re: Survey 123 - Repeat Count not allowing to publish form

RobertMEIER — Mon, 24 Dec 2018 14:03:27 GMT

I have updated Connect to 3.1 and the issue still exists. I am publishing to AGOL. The only wrinkle in the Survey is that I have nested repeat for images.

Here is the latest log file.

Thanks for the help!

Re: Survey 123 - Repeat Count not allowing to publish form

Anonymous User — Wed, 02 Jan 2019 00:52:28 GMT

Hi Robert,

Can you please also share your survey xlsx file too, I would like to see the configuration of the questions and try to reproduce the error with your survey.

Regards,

Phil.

Re: Survey 123 - Repeat Count not allowing to publish form

RobertMEIER — Wed, 02 Jan 2019 19:33:22 GMT

Here is the Survey form, thanks for taking a look.

Re: Survey 123 - Repeat Count not allowing to publish form

deleted-user-GpZRmORkzrlh — Thu, 03 Jan 2019 20:50:22 GMT

We are trying to use the repeat_count in the survey when writing to a feature service using the submission url setting. We are using Oracle so we had to change the field name in the DB to "_count" instead of "_COUNT". Our survey publishes successfully but we are not able to submit any data. We get the error "The survey was not able to be sent due to the following error: Parent to child relationship not found". Any suggestions on how to resolve this problem?

Re: Survey 123 - Repeat Count not allowing to publish form

Anonymous User — Fri, 04 Jan 2019 05:43:14 GMT

Hi Kelly,

Sounds like you have a different error to the one originally posted as it indicates an issue with the relationships, can you provide a copy of the xlsx form so I can take a closer look? How did you create the existing feature service and relationships?

Phil.

Re: Survey 123 - Repeat Count not allowing to publish form

Anonymous User — Mon, 07 Jan 2019 04:20:47 GMT

Hi Robert,

After looking into this issue more and understanding exactly how repeat_count works, when using a static value in the xslx form for repeat_count, a new field will automatically be added to the feature layer to store the value entered. This is required so that the field app can retrieve the stored value to then load the correct number of records in that repeat.

Therefore you will need a field in your feature layer called ${repeatname}_count where the ${repeatname} is the name of your begin repeat question that has the repeat_count applied. This can be created as read only and even hidden so that it is not displayed on the form in the field app.

Alternatively, you can reference another field in the repeat_count column instead of using a static value or use a calculation so that the additional _count field is not required in the schema. The field app will then use the value stored in the other field that already exists or based on the value being calculated.

Hope this helps.

Phil.

Re: Survey 123 - Repeat Count not allowing to publish form

RobertMEIER — Mon, 07 Jan 2019 15:01:04 GMT

I started by adding the field to the feature service related table called RampInspection. The begin repeat section name is RampInspection, so I added RampInspection_count as an integer field. Then deleted that field from the related table and added the same field to the feature layer. Both times I got the errors detailed below.

Then in the survey I added a hidden question with the name RampInspection_count, set the label to Ramp Inspection count and esri:fieldType to esriFieldTypeInteger. I tried adding the field to the repeat section, to the main feature layer section (group) and outside of both and I still am getting error messages when I save the excel doc.

If the question is added to either the repeat section or main feature layer group the message reads:

if the field is added outside of both the message reads:

Re: Survey 123 - Repeat Count not allowing to publish form

Anonymous User — Mon, 07 Jan 2019 23:48:33 GMT

Hi Robert,

The _count field needs to be in the parent, not in the related table as the repeat has to reference it from the parent layer.

However when trying to manually add it to existing feature service, it appears the repeat_count static value is still auto-creating the field in the schema in Connect, you should be able to view this in Connect and in the schema view of the survey. You should see two fields names the same now. You can try creating the field with exact same settings and config, it should be read only also.

If that still doesn't work, the only other option for you with the existing feature service is to create a new integer field as a hidden field type, call it whatever you want but not_count, add the new field name to your survey xlsx file, and put the repeat count value you want in the calculation column of that new field in the xlsform, and then reference the question name in the repeat_count field to the begin repeat question.

Let me know how you go with that, but it will work.

Phil.

Re: Survey 123 - Repeat Count not allowing to publish form

BenjaminSperry1 — Tue, 01 Oct 2019 20:44:03 GMT

Hi Philip,

I am running Survey123 3.6 and am encountering this same problem. The solutions you suggest do not work in my case.

There has to be something else going on because I have several forms that have no problem with relate counts but even my test forms have run into the error.

Any advances on this recently?

Thanks

Re: Survey 123 - Repeat Count not allowing to publish form

Anonymous User — Wed, 02 Oct 2019 05:36:59 GMT

Hi Benjamin,

Can you please provide more details and share your xlsx form, and more specific information about if you are using AGO or Portal (is so what version)? Are you using an existing feature service? How are you using repeat count in your form?

Phil.

Re: Survey 123 - Repeat Count not allowing to publish form

BenjaminSperry1 — Wed, 02 Oct 2019 12:22:55 GMT

Hi Philip, Thanks for the speedy response.

I am using Survey123 3.6 with Enterprise Portal 10.7.1

I can see an attach option but the xlsx is basically this:

This has a nested repeat but I get the same results with a single repeat.

If I publish this survey, with a integer repeat count, it adds the try_count field to the schema and becomes a permanent field in the database.

I then create a new form based on the FC created by this previous form.

If I try to set a repeat count limit I get this error:

If I don't set a repeat count limit in the original form then when I try to add one in the child form I get this error:

If I create a new field with a calculation I get the same error.

The problem started in Survey123 3.3 and so I updated to 3.6 to see if it solved the problem but the error persists.

Thank you for your help.

Re: Survey 123 - Repeat Count not allowing to publish form

Anonymous User — Thu, 03 Oct 2019 12:38:53 GMT

Hi Benjamin,

Did you add the "try_count" field manually to the feature layer, or was it created by Survey123 Connect the first time it was published? If you are using an existing feature service and Portal you may need to add it yourself manually to the correct layer.

It appears based on your first screenshot of the xlsx form you have added the repeat count to the nested repeat, which is called "trying". This will be the name of the layer that is created in feature service. Therefore in the "try" layer, which is the parent repeat, there needs to be a field called "trying_count". Based on the error message in one of your other screenshots, there is duplicate "try_count" fields, which doesn't make sense, as for the repeat count to work with a static value there would need to be a field called "trying_count" in the layer "try" so the value can be written to it, and this field does not need to be added to the survey form.

Your other example should also work where you are using a dynamic value for the repeat count from another field, provided that field also exists in the feature layer, in this case in the parent layer.

Regards,

Phil.

Re: Survey 123 - Repeat Count not allowing to publish form

BenjaminSperry1 — Thu, 03 Oct 2019 13:39:32 GMT

Hi Philip,

Thanks for the guidance.

After a lot of fiddling I found that it is the order that matters.

In the original form creation you have to specify a repeat count

Which adds it to the schema of the feature:

This is added as a permanent field in the FC.

Then when you create another form based on this FC you have to delete the repeat_1_count field before you can add repeat counts.

This: (Sorry I put the repeat_count on the wrong line in this screen capture, it should be on the actual repeat)

Produces this error in the dependent form:

But when you delete those two fields:

It works:

As you suggested, each time you add a value in the "repeat_count" column it creates the ${field_name}_count.

In a dependent form if you haven't created the fields already (in the master form) it will create them and you will get the error that it is incompatible with the URL because you have added fields.

If in the master form you did create them they will pass into the dependent form and adding a value to "repeat_count " will try to create them again, giving the error that there are duplicate fields.

If you create the ${field_name}_count fields in the master and delete them from the "survey" tab in the dependent form then it adds up and you don't get the errors.

In my case using a calculation didn't prevent Survey123 from creating the ${field_name}_count, so doing it in this order is the only thing that worked.

Thanks again, I appreciate your guidance.

Re: Survey 123 - Repeat Count not allowing to publish form

Anonymous User — Thu, 03 Oct 2019 22:31:01 GMT

Great, glad you got it working. Thanks for sharing your findings.

Phil.

Re: Survey 123 - Repeat Count not allowing to publish form

AndrewE — Tue, 03 Mar 2020 15:47:57 GMT

I just want to make sure i'm understanding this correctly you said:

use a calculation so that the additional _count field is not required in the schema

So it is possible to use the repeat_count in a survey and not have an additional field added to my feature service. How and where do I add this calculation. Everything I have attempted so far still results in a ${repeatname}_count being added to my schema.