Hello, everyone!
I have a repeat group in my Survey123 XLSForm (please see 1st screenshot). However, I can't seem to parse it properly in a table.
1st Screenshot: Repeat Group in Sample Survey123 XLSForm
I want my feature report to look like the attached screenshot below (please see 2nd screenshot). So, I have here listed items (Carport, Mezzanine, Balcony, etc.). If the user added a "Carport", it would automatically have a check mark beside it and automatically fill-in its corresponding details in the table (Area, Unit Cost and Total).
2nd Screenshot: Sample Preferred Feature Report to be Generated
I have also attached my initial parsing of the table (please see 3rd screenshot).
3rd Screenshot: Initial Parsing of the Feature Report
However, it resulted to generated Feature Report table below (please see 4th screenshot). My first entry (1st row) is Carport. The parsing seemed to get it right (I assumed). However, the second entry (2nd row) is supposedly for Porch which is incorrect in the resulted table. Also, the entries are duplicated. Maybe because of the repeat group (${#value_computation}) repeated per row in the parsing stage.
4th Screenshot: Generated Feature Report Table
I am new to survey123 forms, so, if you have any hints or suggestions on how to attain the preferred output (2nd Screenshot), I would appreciate it. Thank you very much.