Select to view content in your preferred language

once(join()) work differently on the first repeat

2234
11
03-14-2022 01:27 PM
DougBrowning
MVP Esteemed Contributor

When I use once(join)) inside of a repeat the first records works differently.  It adds it right away where all other repeats adds it after the move to the next repeat.  I am trying to get around this using position but I use pages which means it is in a group which means it always returns 0.

First repeat

DougBrowning_0-1647289435934.png

 

Second repeat is the same

DougBrowning_1-1647289466300.png

 

3rd repeat see how the last value is not on the list.

DougBrowning_2-1647289520044.png

 

I maybe got around it by counting a field in another field after the list and then checking that field to adjust my check.  May not make sense but it seems that the order matters.  So if I count a field before that field I do not get the count you are on but if I count it after I do get it.

Thanks

0 Kudos
11 Replies
JoshB123
Regular Contributor

Thanks for the heads up, i've tested and can not find any issue's so far, although ive got the once() method working now with your help. Does the looping happen every time, is something I should avoid to be safe?

Another frustrating thing I found was the app only submits the first repeat if I don't manually cycle through all the repeats, is this something you've found a solution to at all?

Josh

0 Kudos
DougBrowning
MVP Esteemed Contributor

No you pretty much always have to cycle through the repeats.  That is why I gave up on what you are trying to do.  Its more complicated with no real benefit.

I think it was position in a calc but not sure.