topic Re: Survey submitted from several different Tablets. in ArcGIS Survey123 Questions

Survey submitted from several different Tablets.

Reuben — Wed, 13 Mar 2024 01:51:35 GMT

hi,

I had a survey where different sections were filled by 5 people using

5 Tablets.

After retrieving the 5 Tablets, I began uploading each section of the survey

from tablet 1 to tablet 5. Submission was successful. But when I check the survey data

in my Survey page, only the data from one of the 5 Tablet was in the table. Data submitted by the other

4 Tablets were missing.

Question is, What could I have done wrong ? What could have been the problem?

Appreciate any response

Re: Survey submitted from several different Tablets.

DougBrowning — Wed, 13 Mar 2024 19:59:15 GMT

Were they all from the inbox or something like that? If so the last survey would overwrite the final.

Re: Survey submitted from several different Tablets.

abureaux — Wed, 13 Mar 2024 20:17:24 GMT

I have not seen that behaviour before. It would help to see your XLSX.

Did you see the values entered into the S123 Field App, and then after submitting they didn't make it to the database? Or were the values just not in what the tech saved?

Re: Survey submitted from several different Tablets.

Reuben — Wed, 13 Mar 2024 23:13:06 GMT

They we're saved in the Out Box. I upload from the Out Box

Re: Survey submitted from several different Tablets.

Reuben — Wed, 13 Mar 2024 23:14:39 GMT

Yes all values were entered and saved in the Out Box of the Field App. I upload the Values from the Out Box

in the Field App.

Re: Survey submitted from several different Tablets.

abureaux — Thu, 14 Mar 2024 15:43:42 GMT

Hmm. Did you set query parameters? That can result in blanks if not set.

And of course a field set to null can do that too.

Re: Survey submitted from several different Tablets.

Reuben — Thu, 14 Mar 2024 18:14:21 GMT

hi,

Thanks. The query parameter to be set for

all rows?

Re: Survey submitted from several different Tablets.

abureaux — Thu, 14 Mar 2024 18:31:10 GMT

ngl, I always set it for all rows since it's faster and easier.

Technically you can use it more sparingly, but unfortunate I don't recall where the guidance document is for query parameters. Here are the couple I remember off-hand:

Very important to set this for Begin Repeat.
I think that setting query allowUpdates=true for Begin Repeat carries down to all items within the repeat, making setting it for those items within the repeat redundant (I still do anyways...)
You cannot set a query parameter for a blank row (you will get an error when you save the XLSX Form).
There is no need to set query parameters for End Group/End Repeat.