topic Re: Empty rows are created for all related tables in ArcGIS Survey123 Questions

Empty rows are created for all related tables

JayH — Tue, 07 Jan 2020 18:27:12 GMT

Hello all,

One of my survey seems showing unexpected behavior.

In the survey, users will choose project type and then relevant questions will be shown and saved under a related table. So if I choose Project B in my first survey and work on some questions, I expect to see '(0)' other than Project B column as no related tables are created for Project A, C, D and E. However, as shown the image below, all of them are filled with (1). If I click (1) show under ProjectB, there are questions and answers I typed in. But if I open the rest, they are all empty record.

I tried multiple entries, and no matter I choose, there are empty row created in every related table.

This is schema preview. User will choose only 1 project in each survey.

Project (select project)

----ProjectA

----ProjectB

----ProjectC

----ProjectD

----ProjectE

Re: Empty rows are created for all related tables

IsmaelChivite — Tue, 07 Jan 2020 20:16:34 GMT

Hi. Set the appearance of your repeat to minimal, and now empty records will be created. By default, when adding a new repeat to your form, a first record is always created so users can see questions within the repeat. You can overwrite this behavior by changing the appearance to minimal. A record will only be created if the user explicitly opens the repeat.

Re: Empty rows are created for all related tables

JayH — Wed, 08 Jan 2020 16:30:18 GMT

Hi Ismael,

Setting the appearance minimal still created empty row for the related project tables that are not supposed be used. I solved the issue by locating each repeat under its own group, and then applied relevant condition at the group level.

Cheers,

Re: Empty rows are created for all related tables

JayH — Thu, 23 Jan 2020 23:00:07 GMT

Hello Ismael,

I did more testing on my issues because I do not prefer using additional group unnecessarily. However, it looks like having 'minimal' or even 'compact' does not prevent from populating empty record in every related table when I am using conditions in 'Relevant'. Is it an expected behavior?

Cheers,

Re: Empty rows are created for all related tables

JamesTedrick — Fri, 31 Jan 2020 19:37:29 GMT

Hi Jay,

It may be helpful to share your form to identify what is occurring.

Re: Empty rows are created for all related tables

JoseValdes — Fri, 31 Jan 2020 19:56:45 GMT

hi i have the same situation. but only when the form is used in the browser then create the blank record . the form was created with connect.

Re: Empty rows are created for all related tables

JayH — Fri, 31 Jan 2020 20:33:55 GMT

Hello Jose,

I tested my survey in the web browser as well and this happened. I have not tested my it in mobiles as it is supposed to be used in the office environment. This maybe another limit of surveys in web form?? It looks like there are a number of functions that are not working yet in web form versions.

Re: Empty rows are created for all related tables

DezsoLovicsek — Thu, 21 Jan 2021 16:08:38 GMT

Hello, I am having the same problem with empty records being created in the webform when the repeat is not relevant. When I try and make the appearance of the repeat minimal, I receive the following webform initialization error: formLogicError, context node was not supplied. Any suggestions? The form was published with 3.11.