Passing value(s) to a repeat from a previous repeat

Agilityzen — Sat, 18 Sep 2021 15:12:00 GMT

I am working on a survey where I need to pass a value from one question in a repeat to the following repeat. Here's a better description:

1. when the survey is opened, the start time is passed to start and end times the repeat.

2. The biologist records the behavior, its behavior start and end times

3. When a new row in the repeat is added, I need the end time of the previous repeat to be passed to the start and end times of new row.

I have tried writing and rewriting the code and keep getting Dependency Cycles.I have also tried the indexed-repeat function with no success.

I have included my latest spreadsheet for review.

I know copying/pasting rows in repeats is in the development queue. Has there been any progress on this?

Any help you can provide is greatly appreciated.

Chris Anderson

Re: Passing value(s) to a repeat from a previous repeat

DeonLengton — Mon, 20 Sep 2021 06:51:33 GMT

Hi Chris

I think you were on the right track - see if the attached example works for you.

Basically, in the next repeat record I calculated the start date to be that of the previous record using the indexed-repeat functoin:

indexed-repeat(${end_date_time_b}, ${behaviour_records}, position(..)-1)