Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
i have list box Flag here I need one more option like ALL
Result should be like
Thanks,
May be this
=If(GetSelectedCount(Button) = 0, 'Green Flag',
If(SubStringCount(Concat(DISTINCT '|' & Button & '|', ','), '|All|') = 1, '("Green Flag"|"Red Flag"|"Yellow Flag")',
'(' & Concat(DISTINCT Chr(34) & Button & ' Flag' & Chr(34), '|') & ')'))
Attached file is blank... can you repost?
Hi,
see Attachment.
Regards,
Antonio
PFA
When there is no selection it is select from all (meaning no filter). Add All by Inline with no value.
Not sure if antoniotiman already have what you want, but when you clear the selection, do you want to see Green Flag or you want to see nothing selected?
when i select clear
flag list box want to select Green flag and button also want to select green
if i select green and yellow means it's not reflect in list box
thanks for reply
when i select green and yellow means it's not reflected in list box
So right now when you select clear, Green Flag is selected, but when you select Green and Yellow together, then nothing is selected? Is that the issue?
What do you want to see when Clear is selected?
What do you want to see when Green and Yellow are selected together?
by default or using clear--> Green want to select in button and listbox
other than that whatever user select in button it want to reflect in listbox
if they select all means it want to select all flag