Get data column/value from choices sheet

[stephanealoo]

Hi @jdugh
Thank you for your post.

@jdugh

@Kal_Lam , you taught me the select_one_from_file and the pulldata function, and it work’s great, thank !

Glad to know this works for you.

@jdugh

fter that, I test choices_external sheet, but without success.

It would be interesting to see how you have executed this. However, I would strongly recommend that you look at the following discussion. I believe you can customize your form using the logic that had been provided.

Managing cascading select questions for a very large question choices

Hi @cchukwu I would like to propose an entire different approach to getting this form to work. This will however require that you do some work on your end to customize the form on the cascade selection using the following instructions. Approach 1: Using search () in the appearance column. NOTE: This method will only work on the android collect application. The original writeup can be found here (XLSForm Docs). This method does not need you to execute choice_filter for cascade questions …

@jdugh

I had a choice_filter in my survey choice. this has the effect of adding the list of choices in the XML.
(test with xlsform Online)
So, I had a calculate with the XML path in the calculation field.
And I get the data !

I tried looking at your form and I did not clearly understand what exactly was your goal. If you could please clarify and confirm whether the information I have provided above also clarifies your issues.

Stephane