Null Records in Related Tables within One Survey Form

98
3
08-23-2019 09:46 AM
Highlighted
New Contributor II

Ismael Chivite

James Tedrick

I am trying to consolidate a number of existing Survey123 forms into one form in order to simplify backend processing and reporting and also enhance the end user experience.

 

Currently, each survey is comprised of 10-15 questions, with a Y/N/NA/Other response choices,  when other is selected a conditional text field is conditionally formatted and stores an outlier response.

 

The driving force behind the redesign is to capture more granular detail from the end user, instead of the “Y,N,N/A,Other” format, we would like to provide a series of domain/list of choices that we have identified as common issues or violations for each question, which will also include Yes (compliant), N/A, Other.

 

Our desired structure in Survey123 & ArcGIS Online will look like the following:

 

Site – Parent Table – Containing Site Specific Detail (Address, City, State etc.)

FQA Survey approx. 20 Surveys comprised of at least 10 questions – Related to Parent

 

In our initial design we are using the <begin group> to group each FQA aesthetically, followed by <begin repeat>, which creates the related table, and use one select_one question for  compliance and a select_multiple in the instance where non-compliance was found and the ability to select multiple violations per question.  When using the select multiple function, I am also employing the hidden field technique to avoid all selections being stored in one field as comma separated values.

Yes – Compliant

N/A – Not Applicable

No – Show Select Multiple list of common infractions, where one or many can be chosen, including Other.

Other – Conditional Text Box Appears where user can enter what the issue is/was.

 

The challenge we are trying to overcome in the XLS Form is, using the begin repeat function, when the end user doesn’t not fill out all surveys, which will be the majority of the time, we get Null records in each related table that is not filled out of applicable to the site observation being performed.

Is there a way to have a site table, related to multiple observation tables, and not have all groups filled out, and still not have records (null) created for each group that has not been used during a specific observation?

Reply
0 Kudos
3 Replies
Highlighted
Esri Esteemed Contributor

Hi William,

As part of developing our next release (mid-Sept.), there have been a number of improvements to empty repeat handling - could I ask that you try one of the beta builds available in the Survey123 Early Adopter Community to see if it addresses the issue you are seeing?

Highlighted
New Contributor II

Hello James,

Thank you for the prompt response.

No problem, I will try the latest build, is there something specifically that I need to use in the "relevant" field or other way to potentially mitigate this issue?

Best,

Bill

Reply
0 Kudos
Highlighted
New Contributor II

James,

I was able to use the Beta Version to eliminate the null records, which is fantastic.

However, my concern is users will accidentally hit the "plus" or "trash can" creating a bogus record(s) or unintentionally deleting records they want to submit.

Is it possible to:

a. Hide the interface that allows the user to add an add an additional record

b. Or  is there a way to designate which questions or groups of questions in a particular survey are published to which related table w/o using the begin repeat.

The only reason I am using the begin repeat here is to generate a related table, not necessarily to allow the user to add multiple records.

Thank you for your time and assistance.

-Bill