Suppose I have a select_one_from_file question:
Question 1: What country are you living now?
Then I have a follow up select_multiple_from_file question:
Question 2: What other countries have you lived previously?
I want to ask for help with the following.
Is it possible in xlsForm to exclude from the choices in question 2 the answer in question 1?
How do we check that all responses in question 2 does not contain what was answered in question 1? or How do we detect, if ever it happens, that the answer to question 1 is included in the replies to question 2?
There is a search() function that you can use in a csv to limit what can be displayed in the form. The syntax looks like this
search('csv_file','search_method','column_to_search_for',${search_string})
search_method can be startswith, endswith, contains, and matches.
In my first post, I asked for help regarding this question:
Is it possible in xlsForm to exclude from the choices in question 2 the answer in question 1?
This question can be easily answered if the search() function has a search method similar to "does not contain" or "does not match"
So if my reply to Question 1 (What country are you living now) is Japan which is saved in variable ${country_now}
Then in countries.csv I have the following
Code, Name
Jpn, Japan
Ind, Indonesia
Chn, China
Phi, Philippines
Mal, Malaysia
I can use a search function like search('countries', 'not_match', 'Code', ${country_now}) so that what are displayed in the choices does not include Japan.
I wonder if what I described can be done in XLSForm