Prefill Question(s) in repeat with answers from previous record

Question

Good Morning,

I have a survey form for collecting samples from buildings.  The samples are contained within a repeat ( ${repeat_samples} ).   Within the repeat, I have fields for Building Number, Floor Number & Room Number.  Since multiple samples are always taken from each room, I would like NEW samples to default to the Building, Floor and Room values entered in the previous record.  This is the formula that I've tried using, but receive a dependency cycle error: 
indexed-repeat(${bldg_num}, ${repeat_samples}, position(..)-1)

Any help greatly appreciated. Thanks

DerrickWestoby · Answer

Thanks Doug.  I may try this in a test version of the XLS, but not too fond of the javascript implementations based on experience and if you're already reporting it struggles with large surveys.  The surveys I have in use with javascript running are much less stable already.

dougbrowning · Answer

I have only got 1 way to work but it only works on small repeats.  See here  https://community.esri.com/t5/arcgis-survey123-questions/prepopulate-answers-in-a-repeat-with-last-values/m-p/1093928

DerrickWestoby · Answer

Thanks for the response, Philip.   I'm not attached to this specific way to accomplish the goal, just the goal itself.  If there's another way to make a question's default answer match the input from the previous record in the repeat, I'd love to hear that!

I sent you a message with my XLS as well.  Thanks for taking a look.