Surver123 Feature Report: Custom Placement of Repeat Entries in a Table

501
3
11-03-2022 05:49 AM
jantolihao
Occasional Contributor

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. 

jantolihao_0-1667477078271.png

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).

jantolihao_5-1667478502620.png

2nd Screenshot: Sample Preferred Feature Report to be Generated

I have also attached my initial parsing of the table (please see 3rd screenshot).

jantolihao_6-1667479157570.png

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.

jantolihao_7-1667479345434.png

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.

 

 

0 Kudos
3 Replies
Katie_Clark
MVP Regular Contributor

So, for a survey, would the user potentially add information for more than one carport, mezzanine, etc? Or always only one, if applicable?

Best,
Katie


“The goal is not simply to ‘work hard, play hard.’ The goal is to make our work and our play indistinguishable.”
- Simon Sinek
0 Kudos
jantolihao
Occasional Contributor

Hello, @Katie_Clark!

Thanks for replying. To answer your question, always only one.

0 Kudos
Katie_Clark
MVP Regular Contributor

In that case, I would recommend actually not using a repeat here, and changing the survey schema.

My approach would be to have a different group for each item (carport, mezzanine, etc). You would just have specific questions in the survey for each data point, i.e. ${carport_area}, ${carport_unitCost}, etc. This will make your XLS file have several more rows, but it makes the report formatting WAY easier. 

You could even have an initial select_multiple question like "What items do you need to enter data for?" and then depending on which ones they select, those dependent questions/groups would appear for them to fill out. 

I'm sure there are other ways to approach this, but that's how I've handled reports similar to this in the past...

Best,
Katie


“The goal is not simply to ‘work hard, play hard.’ The goal is to make our work and our play indistinguishable.”
- Simon Sinek
0 Kudos