Select to view content in your preferred language

Survey won't send due to issue with Nested repeat.

61
2
Friday
GeorgeClutterbuck
Occasional Contributor

Hi for some reason my survey form won't send even though it published fine. I think the issue is to do with a nested repeat I have where I record flora species quadrats. But I have another nest repeat which works without issue. All I get is an operational rollback error when I try to submit. I've attached the s123 sheet below. Thanks.

 

 

0 Kudos
2 Replies
MobiusSnake
MVP Regular Contributor

Nested repeats shouldn't be a problem, I use them occasionally and don't typically have any issues.  Nothing in your XLSX is jumping out at me as anything different than what I've done.  I was curious if you went more than two levels "deep" but it doesn't look like it; I've never tried a "three-deep repeat", can't say whether that causes problems.

You might be able to get a more detailed error message if you enable debugging.  On the device you're using for capture, go into Survey123's settings, and under Diagnostics enable debugging.  Try to submit again, then turn off debugging and have a look for any error messages in the log file that it creates.

0 Kudos
DougBrowning
MVP Esteemed Contributor

You have several dup field names like generated_note_field_70.  You also have several using reserved words like label and final.  You also end some in _ which is not a good practice.

Looks like you are not using the template is your biggest issue.  It will check for all of this for you and mark then in green for reserved.

DougBrowning_0-1739200010477.png

And in Red for dups.

DougBrowning_1-1739200039276.png

 

I suggest you start with a brand new blank template and bring over each column - MAKING SURE to use Right click Paste Values.  This way the formulas in excel to check all this is not overwritten.

Then all of this is easy to see.  You never want to mess up the template.  Not even sure how\why you did this.

Hope that helps

 

 

0 Kudos