topic Re: Consistent numbering of repeat items in ArcGIS Survey123 Questions

Consistent numbering of repeat items

deleted-user--2hDb5YTmQS1 — Tue, 23 Jul 2019 09:59:37 GMT

Hi,

There are already some threads on how to number repeat items (e. g. How to assign each repeat group within a repeat a number label).

The proposed solution, using the once(count()) combination, seems to do the trick, but it cannot guarantee a consistent numbering of the repeat items. When, in a first instance, I create three items within a repeat (numbers #1, #2, #3) and then delete the first item (#1), the two remaining items still have numbers #2 and #3 (which is okay). Now, when I create another item (actually number #4) it also gets number #3 leaving me with two items that are numbered #3. (Maybe this is what James meant by noting '...that this does not update if a repeat is deleted mid-way through completing the form').

Is there any other way to consistently number all items in a repeat question, taking intp account that items might get deleted?

Thank you very much, best regards,

Jürgen

Re: Consistent numbering of repeat items

DougBrowning — Tue, 23 Jul 2019 20:37:52 GMT

This may have came from my post. I use it a lot but it never came up!

Now that I think about it maybe once(max() + 1) would work. You have given me something to consider here.

Re: Consistent numbering of repeat items

deleted-user--2hDb5YTmQS1 — Wed, 24 Jul 2019 07:44:41 GMT

Hi Doug,

Thank you for your answer. Although this new approach with the max() function seems reasonable, I don't get it working. Did you find out how to do the trick?

Thanks, Jürgen

Re: Consistent numbering of repeat items

DougBrowning — Wed, 24 Jul 2019 14:34:57 GMT

max only works outside the repeat if I remember right. So you need a hidden field outside the repeat with max in it.