Error Survey123template report

Question

Hi, I am trying to create a report that will put the repeats in a table row by row, but it keeps giving me error when I try to upload as a template.  I think I am following the syntax examples correctly.  When I try to load the report template, it gives me an error: "Failed to parse ${Key_Result_Areas} since Key_Result_Areas cannot be found in the current parsing scope."

I have attached some screen shots and the xlsx form and report template.

Thanks, Moyin

abureaux · Answer

After many tries, it worked! Feature Report attached.

Edit: I noticed it also attached in my original post. Seems to be a graphical bug. Oh well!

PERFORMANCE_CONTRACTtry.docx

abureaux · Answer

I'm surprised you were able to get that far. I noticed a couple of things while looking at the XLSX:

1. You have duplicate names:

2. You have a repeat without a label. I assume this was done so there was no group/collapse button. However, there is a bug where repeats without a label can cause issues. Using an empty div tag here will eliminate that bug, but you will see the collapse button. If this survey works for your workflow, great. Feel free to leave as-is. But if you start getting random errors, I would come back to this.

Now, for the feature report. You are correct. Syntax wise, you are fine. However, S123 Feature Reports are very picky when it comes to repeats and tables. Unfortunately, I am publishing from Connect. There is a limitation in Connect that you cannot publish with capital letters, hence why I changed everything to lowercase.

Specifically, the issue is because your nested repeat is within the same table as your parent repeat. If you removed the table, it would work, but of course we want this to work in the table. My go-to solution for nested tables is to put the nested repeat inside its own separate nested table.

I have a working Feature Report, but it isn't letting me upload. I will try publishing this response and then try uploading the Feature report separately.

Also, I apologize. Because of the limitation I have, you will need to update the names in the Feature Report (assuming it uploads) for it to work with your survey. Also, I didn't want to convert everything to lowercase, so I only really looked at the one part of the Feature Report.

PERFORMANCE_CONTRACTtry.docx

MoyinoluwaOlajide1 · Answer

Attached are the files the template created and also the survey123 connect xlsx

PERFORMANCE_CONTRACTtry.docx

try.xlsx