choice filter based on another numeric field

[newwollyka]

I have a question when the enumerator should enter an ID. The ID field is integer and it can go from 0 to 10000.

I have another question in the form (select_one question) that has dozen of choices. I want to filter (using choice_filter) those choices based on the ID field entered. So in case, the ID was >0 but less than 1000, I want choices a to e to appear, if the ID is between 1001 and 5000, only choices f to i should appear, and if the ID is >5000, the rest of the choices should only appear.

I couldn't make it work preperly. I managed for the first choices to appear, but when entering for example 3000, choices from a to i are all appearing. Also, the list  is sorting by the filter instead of the order of the list now.

Any help is appreciated

Any help?

[newwollyka · Accepted solution]

I fixed it using multiple filter columns. However the sorting of the list is still based on the choice filter and not the list itself!