Getting one column of answer in my result when I have 4 elements in my list_name

[MaholyRavaloharimanitra1]

Hello,

As you can see highlighted in red box in the first jpeg attached, I have 4 "Anaran'ny VOI" while it should be just one column. The reason is because in my list of choices, I have 4 different Faritany (first red box in the 2nd picture attached). I wanted to limit the list of choice that appear for the end user so I have used the choice_filter (in the red box of the 3rd picture) but it didn't work, so I would need your advice because I am stuck there. Please note that each VOI is related to one Faritra and I have put region as title of the Faritra each VOI is affiliated to (as shown on picture 2, red box 2 and 3). 

Thank you 

[IsmaelChivite · Accepted solution]

Hi @MaholyRavaloharimanitra1 

I am not quite sure the choice filter is the reason why you see four duplicated columns in the website. A complete diagnosis will be easier if you share your XLS file as an attachment.

Additionally, the choice filter expression in your XLSForm appears to be incorrect. Check this for details: https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-choice-filters/ba-...   It seems to me like the expression should look like region=${Faritra} or selected(${Faritra},region)

[MaholyRavaloharimanitra1]

Hello,

Thank yo for your answer. Here is my XLSForm

[MaholyRavaloharimanitra1]

Hi @IsmaelChivite,

Thank you so much for having a look at my issues and thank you for the link, very useful 👍.

Yes, I have tried region=${Faritra} and I thought this is the origin of the four column I got in my results, because yes, only the VOI related to the Faritra is displayed on my choice list when reviewing my form on survey123. I have tried to use selected(${Faritra},region) and no list at all is appearing after one Faritra is chosen. I am attaching below the related XLSForm of my survey for you to have a look at and thanks again for helping.