Restrict Listbox values

[mikevmalta]

Hi,

I am loading a field in a listbox with an expression, so that only those values for which certain amount of days have passed will appear.

However when I am selecting more than one value from this listbox, I am getting all the possible values (greyed out) being shown.

Can this be avoided? i.e. I don't want the other values, that the expression does not satisfy, appearing in grey.

Thanks in advance!

Michael

[alexandros17 · Accepted solution]

Select "Hide deleted"

[mikevmalta]

Thanks alexandros17!

By any chance there isn't any way to avoid showing the grey area?

Sorry if I am asking too much (just curious)

Thanks!

[alexandros17]

I think you can't,

if you have preselected values and you want to show only some values you can do

if(myfield='myvalue', myfield, null())

this filter values but when you make a selection the old problem appears again because other values keep existing.

[mikevmalta]

Thanks a lot for your replies

[#6]

Hi,

If you want to hide all the values which are not associated,

or

not to show gray values in the listbox

Try this,

1. Go to the properties

2. On the General tab -> Field -> Expression

3. Give this expression over there       =if(aggr(count(Field),Field),Field)

Done.

I welcome all your feedback.