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

09-18-2021 08:12 AM
New Contributor

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

0 Kudos
1 Reply
Esri Contributor

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)

0 Kudos