nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Send Error - Only on Mobile Device

JohnnyHarley232

Hello all!

I have a complex survey that includes photos, links, webhooks, and calculations that is currently only giving me an error when trying to send in a survey on any mobile device. When loaded in a browser, it submits just fine. I have attached the XLS form and link to the public survey. I am thinking its an incorrect field name or long string but again, it submits on a browser...

https://arcg.is/8qfa0

Form 3.xlsx

Find more posts tagged with

Accepted answers

dougbrowning

I think these are your issue - String or binary data would be truncated.The statement has been terminated.

This is saying you are trying to put something in that is too big for the field. It is usually a string. Find out which once and bump up the field size like you said. I would not just do all of them I would try and find it. Look for anything over 255 chars.

My quick look it may be percent_work_complete field. You have it set to a size of 5 but you never round the value. So you are prob getting a percent like 33.333333333333% and that is more than 5 so it is mad. Remove the size 5 or add a round() in there so it looks pretty and is smaller.

Hope that is it.

All comments

JohnnyHarley232

Does the log file record errors that are submitted through the Survey123 mobile app? When update the Connect form and then try to submit a record through the Connect app, it says "Data values are valid".

dougbrowning

Not sure. I would check the log file next in the app. Turn it on in settings.

JohnnyHarley232

Heres the link

https://arcg.is/1iOanf

JohnnyHarley232

Doug,

Thank you for getting back to me. I have cleaned up the survey.. eliminating mismatched numbers and text in field names and going strictly lower case on field names and published a new survey. I have gotten rid of reserved names as well.

The only other thing I can think of is if the field lengths need to be increased? Do you think that the app data wont send because field lengths are too long? What would hurt if I just made every field length 1000 for safety? I have attached the new spreadsheet to this thread.

Thank you!

Survey Reporting v8.xlsx

dougbrowning

I see a few things. Overall the form is large and hard to read so I may have missed something. May want better names then concrrete2 and repeat5. You also flip between using caps and lower case in field names and sometimes _.

Size is a reserved word. See the little green box - cannot ignore these they are errors.

You named a repeat parentglobalid. That is a field 123 uses for tracking children. Not sure if this an error but good chance.

You have green errors on the label field also but that is prob from a copy paste. In excel always use Paste values or you will mess all the column formulas up.

I hope one of those does it.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.