Survey submitted from several different Tablets.

[Reuben]

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

[DougBrowning]

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

[Reuben]

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

[abureaux]

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?

[Reuben]

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.

[abureaux]

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.

[Reuben]

hi,

Thanks. The query parameter to be set for 

all rows?

[abureaux · Accepted solution]

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.