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; } } }

survey123 string or binary data would be truncated

CaitlinSmith2

Hi Esri World,

I created a survey using Survey123 Connect and sent it out. Some users report that they get an error message that says: "String or binary data would be truncated. r/n the statement has been terminated" when attempting to answer a multi-line text question. I changed the character limit for this question from the default to 1000, but that doesn't seem to be helping. Any ideas?

Caitlin

image001.jpg

BLM-EGIS_error1.png

Jen_ZumbadoHannibal_1-1651682673795.png

Najděte více příspěvků označených jako

Accepted answers

All comments

diegocarvalho

Hi James,

In addition to Timna's points, from what I got, we cannot update the field lengths once the survey is publisher, correct?

BUT, here are a few questions:

The forms filled through the web browser respect the same field length as the ones filled in Survey123 app or the web version is limited to 255 characters and can't be changed?
If we change the field length in Connect and republish the survey, it will be changed in the Apps, but not in the web forms?

Tks!

TimnaG

Hi James,

Couple of questions:

If we were to set the field length prior to publishing to a value well over 255 characters - what is the upper character limit?
Also - if a survey has been published, but not yet gathered any responses, could Esri not allow for change of field length in Survey123 Connect?

This would allow more flexibility for anyone who has to create surveys for clients/managers who have had a 'change of heart' in the direction they are taking after giving initial instruction (like that never happens LOL). Or is there a workaround by adding a new multiline text field in the XLSForm with the required increased character length specified in the bind::esri:fieldLength column? Or any other 'workaround'? Thanks.

JamesTedrick

Hi Caitlin,

That will set the size on initial publishing only- it can't update the size due to the limitation with ArcGIS Online.

CaitlinSmith2

Thanks James. What about the bind::esri:fieldType column in Survey123 Connect? This is where I changed the number to 1000 to override the default value of 250.

JamesTedrick

Hi Caitlin,

Unfortunately, modifying the length of text field storage is not capable within ArcGIS Online, so Survey123 cannot support it.

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

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