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

code 400 not supported columns cannot be added to view services

MTI

Hi - I originally created my survey in the web designer then had to add spanish translation in Survey123 Connect. After publishing in connect (which originally worked fine), I had to update and add a question which is on Line 22 of the xls form. I'm now getting the "code 400 not supported columns cannot be added to view services" error and not sure how to fix. Help please!

Thanks!

form.xlsx

Find more posts tagged with

Accepted answers

IsmaelChivite

One way to fix this would be (assuming you have Survey123 Connect 3.11)

In Connect, use the Save As option in your surveys's card (in the gallery) and create a new copy of your survey.
Do NOT publish your survey right after creating the copy through Save as. Instead. Refresh your survey using the Update button in the left toolbar and once it has been refreshed, publish.

If you take the steps above, you will be creating a brand new survey.

If you already have data in the old survey, you can download it in Excel of File Geodatabase format from ArcGIS.com and then use the Append option (in the Feature Layer Item Details page) against your surveys layer to add back all the data you have.

Part of the problem here is that Survey123 designer creates feature layer views and Connect does not know how to handle with them properly. If you start another survey in designer and you see you need to update it from Connect, it is always best to download the survey, create a copy (save as) and then publish a brand new survey.

All comments

ShaneFeirer

Good afternoon Ismael,

I was having the 400 not supported columns... error when trying to add a new column in Survey123. I created a copy and published the survey as you requested, however, I am not able to append data to the survey as you suggested. I have included the XLSX file and I could send the data seperately if that is helpful.

Agritourism in San Diego FB.xlsx

RichardSanchez1

This worked like a charm for me when I tried to exactly what was described, making changes to a form in Connect after it had been published.

MTI

Thank you so much. Publishing as brand new did the trick.

IsmaelChivite

One way to fix this would be (assuming you have Survey123 Connect 3.11)

In Connect, use the Save As option in your surveys's card (in the gallery) and create a new copy of your survey.
Do NOT publish your survey right after creating the copy through Save as. Instead. Refresh your survey using the Update button in the left toolbar and once it has been refreshed, publish.

If you take the steps above, you will be creating a brand new survey.

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.