Survey123 – sometimes doesn't send answers of required fields into the database

Question

I will simplify my Survey123 form.

My form consists of two begin repeat sections that have the same questions except of one question.

This one question is in the first begin repeat section and on it depends automatic data copying into the second begin repeat section.

All questions are required, in both, first and second begin repeat section.

Meaning the following:

First Begin Repeat

select_one AorB

Type_Of_Event

select_one

BR1_Question1

dateTime

BR1_Question2

geopoint

BR1_Question3

Second Begin Repeat

select_one

BR2Question1

if(regex(${Type_Of_Event},'A'),${BR1_Question1},null)

dateTime

BR2_Question2

if(regex(${Type_Of_Event},'A'),${BR1_Question2},null)

geopoint

BR2_Question3

if(regex(${Type_Of_Event},'A'),${BR1_Question3},null)

Sometimes, but not always, occurs that answers of the second begin repeat section are not sent into the database (Enterpise Portal 10.9.1., DataStore). I access the data using ArcGIS Pro by connecting to the Portal through drag and drop Feature Layer to map.

The answers in the inbox are displayed as if they had just been answered (blue color text) when the Event is A on which depends automatic data copying.

I am using Survey123 Field App 3.15.156

I can't figure out why, because all questions are required and must be answered, otherwise form cannot be sent.

Since there are answers to the questions from the first begin repeat section, it could be realized that the form has been sent and all questions are answered.

For further data analysis, I need the answers from the second begin repeat section and because of the data gathering logic, these questions need to be in the second begin repeat section.

TihanaPolezari · Answer

I am using regex because I have multiple TypeOfEvent for which data is copied. I was trying the same combination of answers and sometimes occurs that the answers are not sent and sometimes they are, so basically, it works with regex when sometimes data are sent.

The form is too complex and unfortunately, I cannot share it on the internet to show you.

I will try your logic for calculation with multiple OR statements, so I hope it will help. Thanks for your answer.

TihanaPolezari · Answer

Yes, I know that. Thanks for your answer.

ZenMasterZeke · Answer

Repeat answers go in separate linked tables, not the main feature layer table. This doesn't explain why some answers show and others don't, but may be a place to start looking.