Position(..) malfunction in repeats in survey 123

[JuanSthebanSanchezAragon]

Hi, I´m using the position(..) tool to get the position for each repeat in my survey, but there´s an issue when a repeat in between is deleted.

As an example lets say I have 4 repeats, the counting would be 1,2,3,4, if I delete the third one the order should update to 1,2,3, but instead it shows 1,2,4. The idea for it is to be automatic so it is a hidden field. thanks so much for reading, and really hope there something to do.

Have a wonderful day.

 

[FrankOuyang]

I tried it in my Survey123 Connect but didn't encounter this problem after deleting entries in the repeat. Can you post more rows in your table so we can see what's in the whole repeat group? And are you using the latest version of the software? 

[JuanSthebanSanchezAragon]

Hi, thanks so much for replying, this is the excel I´m currently working with to do the position task.

[DerrickWestoby]

try this modified XLS instead (added row 9, changed row 8 calculate column). 

I don't know if this is still true on the most recent version of S123 connect, but I think that using position(..) in an integer field won't (or wouldn't) update if a change was made.   At least in my currently published surveys, they -will- auto-update if I use a calculate type to pull the position, then update my hidden integer field from the calculate.    (Which you can still prevent by using once(position(..))  )

[RobertAnderson3]

I just want to say thanks for this information on the integer field not working with position(..) it resolved an issue my colleague was having after much hair pulling.