I have a table (instructions attached).
When I click on Case Type = 'CFIN',
a listbox will have the values:
So my listbox will have Case Types
CCIN
CFIN
When I click on either,
CFIN
or
CCIN,
another text box will have
< 5 days,
<=10 days and
>10 days
This is just text.
CFIN has an 3 expressions
CFIN < 5 days
CFIN <= 10 days
CFIN > 10 days
When I click on CFIN in the listbox, i want
< 5 days,
<=10 days and
>10 days
to evaluate to
CFIN < 5 days
CFIN <= 10 days
CFIN > 10 days
so I'm assuming
pick(match(CFIN < 5 days,CFIN <= 10 days,CFIN > 10 days), ''< 5 days', '<=10 days', '>10 days') as mySelectedValue
doesnt work however.
If I select CCIN from CaseType, I expect to see 'CCIN <5 days', 'CCIN <= 10 days' and 'CCIN > 10 days' which would appear as
< 5 days
<= 10 days
> 10 days
So in other words, the outcome listbox will have
< 5 days.
<=10 days
> 10 days
for which ever Case Type is selected but they will correspond to different expression CCIN < 5 days and CFIN < < 5 days would appear in the list box as '< 5 days'
Attached visual
