Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I want restrict the listbox items based on condition. Im attaching the sample document.
=If(not IsNull(Reason), customerName)
=If(not IsNull(Reason), customerName)
Please try in your list box expression like below
=if( len (Reason) <> 0,customerName)
PFA
Or may be this too
=If(not WildMatch(Reason,0), customerName)
Thanks to all,
All above answers are correct and useful.
Thanks,
ASHOK
Hi Tresesco,
Listbox filter the values correctly, but in the current selections showing two filter values. so, i want show the selected customer filter in the current selection box. Please find the attachment.
Well, try the below expression:
=Aggr(only({<customerName,Reason={'*'}>} customerName), customerName)