topic Re: How to put Count() and Once() in pulldata calculations? in ArcGIS Survey123 Questions

How to put Count() and Once() in pulldata calculations?

IrisTheunisse — Wed, 28 Feb 2018 14:58:46 GMT

I’ve a survey including a repeat function. Within this repeat function, pulldata is being used to automatically fill a field (field = categorie in attached documents) based on the repeat generated with count(). This works except from the case when I want to go back to a previous item in my repeat. In that case it overwrites the previous item based on the new count. Therefore, I added the once() function to my pulldata calculations to enable going back to previous repeat items, but then it somehow shows my first entry twice. I cannot figure out why this behavior happens. Do you maybe have any idea or any suggestion about this? See attachment for both survey folders (including xls and pulldata csv files).

Re: How to put Count() and Once() in pulldata calculations?

JamesTedrick — Wed, 28 Feb 2018 21:06:01 GMT

Hi Iris,

I can see the issues you are having - it appears that the once() is not working properly for the first repeat, leading to a trailing numbering sequence. I've filed an issue to address this.

Re: How to put Count() and Once() in pulldata calculations?

IrisTheunisse — Mon, 05 Mar 2018 14:59:58 GMT

Hi James,

Thanks! Do you have any idea when this will be solved? Do you know if there is a workaround for this issue? A workaround with which items in a repeat can be automatically filled by using pulldata. Is there maybe a function that can replace the count() function?

Re: How to put Count() and Once() in pulldata calculations?

JamesTedrick — Fri, 09 Mar 2018 22:11:49 GMT

Hi Iris,

In my testing, I was receiving the sequence 0,1,2,3 , so adding 1 to the count should work around the issue. I don't have a specific timeline for resolution.

Re: How to put Count() and Once() in pulldata calculations?

JohnathanHasthorpe — Fri, 21 Sep 2018 05:48:02 GMT

This issue will be resolved for 3.1.

Re: How to put Count() and Once() in pulldata calculations?

joerodmey — Thu, 18 Jul 2019 14:03:58 GMT

Don't know if this still an issue and if it applies to my issue. Basically I'm using once() to only collect the username of a user via the webform only once and not replace it if a different user logs in. Would this be an issue with once()?

Re: How to put Count() and Once() in pulldata calculations?

JamesTedrick — Wed, 07 Aug 2019 19:35:54 GMT

Hi Joe,

Typically, once() is used only in the context of a form session (as opposed to editing forms); that being said, it should work in the context you describe.

Re: How to put Count() and Once() in pulldata calculations?

joerodmey — Thu, 08 Aug 2019 19:50:30 GMT

Hi James,

I’ve tried numerous times using once() in calculation field and the expected behavior doesn't occur. My code is:

once(if(${Request_Status}='In_Progress',once(${user_status}),"))

Thanks

Re: How to put Count() and Once() in pulldata calculations?

JamesTedrick — Fri, 09 Aug 2019 16:27:18 GMT

Hi Joe,

Looking further into this, I don't think you'll be able to achieve what you are wanting through a formula - the act of logging in/logging out on the webform reloads the form, causing an essentially 'new' form to be generated.

Re: How to put Count() and Once() in pulldata calculations?

joerodmey — Fri, 09 Aug 2019 16:37:17 GMT

I believe that you have confirmed my thinking. Do you have another idea or do you need more info?