AnsweredAssumed Answered

Calculation doesn't work after first repeat since 1.7

Question asked by GWRC_CM_GIS on Sep 12, 2016
Latest reply on Sep 13, 2016 by GWRC_CM_GIS

I'm having a problem with hidden fields within a repeat.  Users indicated quite strongly they didn't want to fill in the same answer over and over again in a Repeat question.  In the Repeat I used the Calculation function with ${Field Name} to copy a previously entered answer from the parent table to the child table (for our database purposes).  It worked perfectly in testing and database functions were built around all relevant data being in one row.

 

Calculation in the xlsform

 

The same form created with Survey 123 Connect Build 1.7.35 copies the first repeat (1 of 1) but none of the subsequent repeats. Changing from Hidden to Text didn't seem to make a difference and Default doesn't work in Repeats..  Any ideas on when this will be fixed as we were planning to roll out to all users by the end of the month.

 

Output CSV example

 

 

Outcomes