Home > Forum > Forms > Drop down list - pick range of values

Drop down list - pick range of values
0

I have a form with drop down list.
This drop down list is using static list.
Static list have 8 "items".
Steps are A>B>C>D

I would like to use items 1-3 in step A and B where index ID of stem is for example 111 and 112,
and if is in step C or D then the list have only options 4-8.
of course i would like to reset value a drop down list when enter to step C .

BTW: I don't know SQL yet ...
and in editor in filter there is no if then else .... so ....

it works only in first step ... but later not ...
if is only case1 then is 3 items works to the end ... A to D
but if I have got case1 OR case2 then .. appears in step B All 1-8 not in C ...

---EDIT---

OK, it works on A [1-3] and C [4-8]
B have got all 1-8 ... so ... I will try with another OR .... and check

In reply to: Marek Wołosiewicz

Try this, and clear field value when you are enter to step C from step B or B from C.

Thank you for help.

I did 2 cases - 2 options of filtering:

1) with AND
2) with IS IN

in both cases .. is working (see animation)

Question - with is better to use ?
personally for me is missing in webcon [i use 2022.1.4.84] in filters :
1) case ... select
or
2) if then, elseif, else ....
and those brackets are confusing ... :/ [I need to use to it] specially if I need 3 times "OR" ...

P.S.
I did not use clear command to the field ...