topic Retain Value from day to day (between Surveys) in ArcGIS Survey123 Questions

Retain Value from day to day (between Surveys)

AKorsos — Wed, 23 Mar 2022 17:49:44 GMT

I am designing a form that picks up a point during a field survey and, for each repeat, counts the number of points collected. I then use that count to help label the point. The crew would return to the hotel, 'Choose Send Now'. When they return to site, and start up the form, I would like the form to continue from the previous days count. ex: If 3 points were chosen the previous day, the count would begin at 4.

Does anyone know how to accomplish this?

See Below...

type

name

label

hint

guidance_hint

appearance

required

required_message

readonly

default

calculation

constraint

constraint_message

relevant

choice_filter

repeat_count

media::audio

media::image

bind::type

bind::esri:fieldType

bind::esri:fieldLength

bind::esri:fieldAlias

body::esri:style

bind::esri:parameters

parameters

body::accept

body::esri:visible

body::esri:inputMask

label::language (xx)

hint::language (xx)

guidance_hint::language (xx)

required_message::language (xx)

body::accuracyThreshold

bind::esri:warning

bind::esri:warning_message

bind::saveIncomplete

select_one IPADNo

IPADNo

IPAD No

minimal

esriFieldTypeString

begin repeat

GetSampleLocation

CAPTURE SUB SURFACE SAMPLE DATA

field-list

geopoint

SampleCoordinate

Capture Sample Location

minimal

esriFieldTypePointZ

integer

CountSamples

Count Samples

count (${GetSampleLocation})

esriFieldTypeInteger

text

SI_Name

Sample Number

minimal

if(${CountSamples}< 10, "S" + ${IPADNo} + "000" + ${CountSamples}, "S" + ${IPADNo} + "00" + ${CountSamples})

esriFieldTypeString

end repeat

CAPTURE SUB SURFACE SAMPLE DATA

Re: Retain Value from day to day (between Surveys)

BarbaraWebster1 — Wed, 23 Mar 2022 21:03:07 GMT

Hi @AKorsos,

If you add "query" to the bind::esri:parameters column for the begin repeat row, the previously submitted repeat records will be viewable when the crew accesses the survey record from the inbox. The CountSamples calculation will then be based on all the repeat records that have been submitted for that form instead of just the records added since the last time the survey was submitted.

Also see the Repeats section in the Prepare for existing survey data section of the documentation for more info.

-Barbara

Re: Retain Value from day to day (between Surveys)

AKorsos — Thu, 24 Mar 2022 15:07:49 GMT

Hi Barbara

Thank you much for the tip. I am new to the ESRI coding thing.

I added 'query' to the bind::esri:parameters column for the begin repeat row, and in options I enabled the Inbox... however it doesn't appear to work. I should note as well that when I view the inbox after enter a simulated 1 day collection, no records appear after I refresh. Clearly I am missing something?

Thanks again

Re: Retain Value from day to day (between Surveys)

BarbaraWebster1 — Thu, 24 Mar 2022 18:50:26 GMT

@AKorsos No problem, are you not seeing any survey records at all in the inbox? Or is it just the repeat records that aren't showing up?

If you aren't seeing any survey records at all, you could check to see if the sent box is enabled too. If the surveys are in your sent box then they won't show up in your inbox.

If it's just the repeat records that aren't visible in the inbox, would you be able to share your XLSForm so we can take a more detailed look?

Thanks,
-Barbara

Re: Retain Value from day to day (between Surveys)

AndreasKorsos — Thu, 24 Mar 2022 21:12:45 GMT

Hi Barbara

I entered a 'days' collection in the App. Closed the app and then went back in as if it was the next day and nothing appeared in the Inbox...

Here is the sheet. I have hidden most of the questions so I could concentrate on this problem.

Andreas

Re: Retain Value from day to day (between Surveys)

BarbaraWebster1 — Thu, 24 Mar 2022 21:47:46 GMT

Thanks for the XLSForm, on initial read through it looks like everything is configured correctly in the form. If you look at the survey details page in the field app is there a sent box along with the inbox?

Re: Retain Value from day to day (between Surveys)

AndreasKorsos — Thu, 24 Mar 2022 22:28:27 GMT

Hi Barbara

Yes I have what you show. A Collect, Inbox, and a Sent showing 1 sent

Thanks

Andreas

Re: Retain Value from day to day (between Surveys)

BarbaraWebster1 — Thu, 24 Mar 2022 23:00:23 GMT

In the field app a record will only show up in one of the 'boxes' at a time, so if you go into the sent box and press 'Empty' and then refresh the inbox, the record should appear in the inbox.

It's also possible to disable the sent box in the settings in Connect if you only want to access records from the inbox.

Re: Retain Value from day to day (between Surveys)

AndreasKorsos — Fri, 25 Mar 2022 15:32:12 GMT

Hi Barbara

I did both. Left the Sent Box and then turned it off. I was able to see the items in the inbox after a refresh... unfortunately the count still starts as 1 again after restarting the survey rather than recognize the count in the inbox. It is almost as if the 'query' is not looking at the inbox. Did you use the form that I provided to see if it worked on your end?

Thanks

Andreas

Re: Retain Value from day to day (between Surveys)

BarbaraWebster1 — Fri, 25 Mar 2022 17:12:07 GMT

I tested out your form and the count calculation is continuing from the last count. I included a GIF of what I'm seeing when I have a record that has two previously existing repeats. Are you seeing the previous day's repeats when you open the record from the inbox?

Re: Retain Value from day to day (between Surveys)

AKorsos — Tue, 29 Mar 2022 12:33:54 GMT

Hi Barbara

It made no sense that the form didn't work so this weekend I redid the form... typing everything out (no copying) and it now works.

Thanks for your help,

Have a gr8 day

Andreas

Re: Retain Value from day to day (between Surveys)

BarbaraWebster1 — Tue, 29 Mar 2022 16:29:08 GMT

Glad you got it working!