topic Re: 'Enter a supported XLSForm type...' message in ArcGIS Survey123 Questions

'Enter a supported XLSForm type...' message

JayHodny — Mon, 20 Dec 2021 18:53:22 GMT

Good afternoon. I am working with the latest version of Survey123 Connect and publishing to ArcGIS Enterprise 10.9.1. I have created a new survey project from an existing survey, and then modified the XLSForm. I have noticed that I cannot choose 'type' in the cells in column A of the XLSForm. When I highlight a cell, I receive the message in the screen shot below and no drop-down list appears. If I enter the type manually in a cell in column A, this seems to work, but it is not the desired behavior. If I add a row, and highlight a cell (e.g., cell A4 in column A) there is no option to choose a type from the list. I cannot figure out how to resolve the issue. Any suggestions would be appreciated. Thanks in advance, Jay

Re: 'Enter a supported XLSForm type...' message

DougBrowning — Mon, 20 Dec 2021 19:37:16 GMT

Most likely in the past you did a Ctrl C instead of paste values which brings validation with it and messes it all up.

See these posts for more info and fixes.

https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-microsoft-excel/ba-p/897060

https://community.esri.com/t5/arcgis-survey123-blog/updated-xlsform-templates-for-survey123/ba-p/897022

Re: 'Enter a supported XLSForm type...' message

JayHodny — Mon, 20 Dec 2021 19:42:25 GMT

Bingo! Cntrl-C/Cntrl-V - guilty. Thanks for the posts Doug.