Autopopulate Repeats based on Another Question

[emoreno]

Hi ESRI Community!

I have a substation inspections survey that has multiple repeat groups, and each repeat group starts with an identifier, for example, "Transformer Number". Our end users have complained about populating the identifiers for all these repeat groups manually, and I was wondering if there was a way to automate it for them.

Essentially, Is there a way I can get the number of repeats and their identifiers to adjust automatically based on what substation is being inspected? For example, for a substation that has 2 transformers, I'd ideally like for the user to select the Substation Name, have the survey automatically add 2 repeats for each transformer at the substation, and auto populate the first question of the repeats with their associated transformer numbers. 

Is this something that's achievable? Any help is appreciated. Thank you all!

[Neal_t_k · Accepted solution]

Yes this is possible as you describe and probably several different ways.

The simplest way I can think of is making some choice lists and and filter the transformer list based on the answer to the substation question.  To get the repeat count you would probably have to do another list to get the number of transformers which you can then use for the repeat count.

https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-choice-filters/ba-...

Taking it one step further you can prepopulate the questions in the repeat using pulldata(), count-selected(),  position(..) and selected-at().  However this involve curating some CSV lists for your substations and transformers, see attached example.  

https://community.esri.com/t5/arcgis-survey123-blog/use-existing-data-in-your-survey-the-pulldata/ba...

You can probably replicate this using a feature layer instead of a CSV as well using pulldata(@layer). 

https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-pulldata-quot-laye...

Hopefully this will help give you some ideas.  

[emoreno]

Thank you, I was able to build something similar based off your attachments