topic Re: once(join()) work differently on the first repeat in ArcGIS Survey123 Questions

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

DougBrowning — Mon, 14 Mar 2022 20:27:21 GMT

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

Second repeat is the same

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

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

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

Anonymous User — Tue, 22 Mar 2022 08:34:38 GMT

Hi @DougBrowning,

Does this appear to be new or different behavior with the recent 3.14 release, or did you see the same thing before with 3.13?

Are you able to send us this form (updated copy) so we can take a closer look?

Thanks,

Phil.

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

DougBrowning — Tue, 22 Mar 2022 14:05:45 GMT

I think new to 3.14 but not sure. I had to change the code since 3.14 broke my dups check trick. I ended up having to code around it by checking if it was the first repeat. This was actually hard since I had to count a field that was after the constraint field - which took a few hours to track down.

if(${TempCount}=0, 1,${Species}='' or contains(${Species}, "XXXX") or not(contains(${AllPlantsCheck}+",",${Species}+",")))

I will email you the form. Thanks

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

Anonymous User — Wed, 23 Mar 2022 05:47:19 GMT

Thanks @DougBrowning,

Got your email, we will take a look and get back to you.

Phil.

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

jrowe19 — Tue, 26 Mar 2024 23:23:58 GMT

Hi @DougBrowning and Phil. Was this ever resolved? I am having the same issue. Thank you!

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

DougBrowning — Tue, 16 Apr 2024 16:13:55 GMT

Update to myself. 2 years later and it is still doing it. I finally found a fix. If you set your count field that has a calc of 1 to also have a default value of 1 then the repeats calc properly.

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

JoshB123 — Tue, 15 Oct 2024 08:51:30 GMT

@DougBrowning Im trying to create a very similar survey and struggling to understand using Once() in repeats. Would you be happy to share XLS form to help me understand how it works properly?

Josh

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

DougBrowning — Tue, 15 Oct 2024 19:23:20 GMT

Just have a field with 1 in it then a second field is once(count())

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

JoshB123 — Wed, 16 Oct 2024 10:09:46 GMT

Thanks, I figured out I wasn't actually needing to use the once() function. I wanted to have a select multiple that populated into repeats but also updated itself when the select multiple list was changed, but regardless of the order they were selected.

Instead I used this: selected-at(${species_choice},position(..)-1)

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

DougBrowning — Wed, 16 Oct 2024 12:39:27 GMT

position can cause looping in your form so watch out for that. In Connect open your form and then wait a minute or two and see if this symbol pops up in the upper right corner.

I had to take position out of all my forms as it would loop to infinity and started to cause slow or crashing forms. It will seem ok at first, but if that symbol shows up do not ignore it.

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

JoshB123 — Wed, 16 Oct 2024 16:33:53 GMT

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

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

DougBrowning — Wed, 16 Oct 2024 19:08:14 GMT

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.