How to extract the answers from select_one type questions which are not visible?

[hideoshiraishi]

I could solve the issue using pulldata() function referring to this thread and tutorial.

Using PullData from xls Form

Hi James Could you change your question type to text or integer from calculate as is the case above. This would definitely solve the issue of visibility for the pull data. Regards Stephane

https://support.kobotoolbox.org/pull_data_kobotoolbox.html

In this way I could avoid using calculate and select_one chains and directly call the attributes from an external csv file. But I also realized that pulldata() works properly not in preview, but in deployed survey form.

list_sp.csv (162 Bytes) sp_test.xlsx (14.5 KB)

Thank you!!