Feature Report - Extract Repeat Field Data

BattJones

I'm attempting to pull a specific field's data from a repeat into a feature report table. The table is a static list of all the possible values and I'm attempting to have a checkbox populate next to each value that was present in the repeat table.

For instance, I have values A01, A02, A03, A04, etc. If A01 and A04 were entered into the repeat table, then I'd like to have a checkbox show up next to the value in the static feature report table.

I've attempted to get this to work by using ${fieldname | checked: "value"} next to each value and including ${#repeatname} ${/} at the beginning and end of the table. I've also tried doing this with no table and without the repeat name, but can't seem to get it to work. The basic checkmark function will work, but the table or list repeats each time.

 

How can I pull out just the data from the repeat field without the table repeating? Thank you!

Repeat-Table-1.png

Repeat-Table-3.png

Repeat-Table-2.png

KojiKUROSAWA_4-1718665801209.png

KojiKUROSAWA_3-1718665775586.png

KojiKUROSAWA_2-1718665730973.png

DerrickWestoby

You are trying to print a single table for your entire report, and that table has a pre-set list of values that you want a check next to if ANY record in your repeat's related field contains, correct? 

If that's correct, I think there's two ways to do this.  

1. Don't reference the repeat in your feature report. Instead, have a hidden field in your XLS form (outside of the repeat) that returns a 1 if that  value is entered and a 0 if not.  You'd have to do this for every option that's possible.   This way, you could reference the questions outside of the repeat and not worry about your table itself repeating for each record in the repeat. 

 

2. Use the repeat summary/aggregate functions, along with a little bit of funny business in your feature report itself. 

${REPEAT_TABLE_NAME | where:”YOUR_VALUE = 'A1' " | stats:"count,objectid"}

The example above will reference a question in your repeat (and does not require the open/close tags for repeats) and will return a numeric value of how many repeat records have 'A1' selected.   Maybe you just want to print that number out instead of a checkbox, maybe not.  

If not, you could highlight that entire formula and change it to black text with a black background.  It won't be an actual checkmark, but you could give the appearance of a solid black box for non-zero values.  You'd still need to add an IF statement to only return values greater than 0, though (since this will still return a 0 for empty values).    But it'll allow you to access the counts in a single table without repeating the table for each. 

 

Check out this article for more information on the Aggregate functions in the feature report - https://doc.arcgis.com/en/survey123/browser/analyze-results/featurereportqueries.htm