topic Re: Error converting XLSForm in ArcGIS Survey123 Questions

Error converting XLSForm

rATAAdmin — Mon, 13 Dec 2021 21:08:21 GMT

I am getting this error [row:99} List name not in the choices sheet: cause

I don't know what this means, can any assist me, please. I have attached a screenshot as well.

@Anonymous User

Re: Error converting XLSForm

FrankOuyang — Mon, 13 Dec 2021 21:24:54 GMT

Hi, this error means that you have probable in you type column entered "select one cause" which means select one of the causes. In order to use 'select one' or 'select multiple' type, you will need to populate your selections in the choices sheet first.

Similar to what you did in the survey sheet, list_name will be the same for all your causes as "cause". Name will be unique for each cause and label is what each of the cause will be shown as in the survey.

Please see full documentation here.

Re: Error converting XLSForm

rATAAdmin — Mon, 13 Dec 2021 21:43:20 GMT

Hello Frank,

Thank you for the prompt response. I have populated both the survey and choices sheet. as you can see in the screenshots below: Can we have a call, please?

Re: Error converting XLSForm

FrankOuyang — Mon, 13 Dec 2021 21:52:42 GMT

Hi, I am happy to continue assisting you through this post so that other people with similar questions can find solutions here.

So in the first picture you post, the type is 'select_multiple cause' which indicates the 'list_name' in the choice sheet form should be 'cause'. But in your second picture, the list_name (first column) seems to be 'BARRIER'. So you will need to change it to 'cause'. Let me know if this still does work.

Re: Error converting XLSForm

rATAAdmin — Mon, 13 Dec 2021 22:17:16 GMT

I changed the 'cause' in the survey sheet to 'BARRIER' to match that in the choice sheet form and it worked.

Thank you so much, Frank.

Joseph