Need "All selection" Button

[vengadeshpalani]

Hi all,

i have list box Flag here  I need one more option like ALL

1. if i select ALL it want to select all value in the list box (Green Flag, Red Flag, Yellow Flag)
2. if we did not select any value it wants to select Green flag automatically 

Result should be like

Thanks,

[sunny_talwar]

Are you saying that this is what you want or is this what it is doing right now? The reason I am confused is because you are saying Green want to select...

user select in button it want to reflect....

It seems to me that this is what is going on right now.... but I might be mis-interpreting you...

[antoniotiman]

See Attachment

[vengadeshpalani]

actual requirement

by default or nothing selected in listbox means  it' automatically select green flag, other than that it depends on user selection

and one more is user  need all value in list box if they select all means it's want to select (green,yellow,red) flag

[sunny_talwar · Accepted solution]

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), '|') & ')'))

[passionate]

Hi Antonio/Vengadesh,

Modified App from Antonio.

Now this will satisfy your condition.

Regards,

Pankaj

[antoniotiman]

Another way, without  add 'Flag' in Concat

and this works also if field is like 'Red AnyText'

=If(GetSelectedCount(Button)=0,'Green Flag',If(Button='All','*','('&Concat(DISTINCT '*'&Button&'*','|')&')'))

Regards,

Antonio