GetFieldSelections with AND condition not working

[ashis]

Hi , I have a listbox called City and it has few city names. 

I want one button to show or hide if city selection is either Boston or Washington , or both.

so i but the below condition in the button;

=if(GetFieldSelections(City)='Boston' or GetFieldSelections(City)= 'Washington',1,
if(GetFieldSelections(City)='Boston' and GetFieldSelections(City)= 'Washington',1,0))

It works if either one city is selected but do not work if Boston and Washington are selected. 

Any thought please.

Thanks,

Ashis

[sultanam · Accepted solution]

Hi,

try below one

=if(GetFieldSelections(City)='Boston' or GetFieldSelections(City)='Washington' or
GetFieldSelections(City)='Boston, Washington',1,0)

Regards,

Sultan

[marcus_sommer · Accepted solution]

Maybe this approach is more suitable:

wildmatch(concat(distinct City, ','), '*Boston*', '*Washington*')

- Marcus

[sunny_talwar · Accepted solution]

You can also try this

SubStringCount(Concat(DISTINCT '|' &City & '|'), '|Boston|') = 1
or
SubStringCount(Concat(DISTINCT '|' &City & '|'), '|Washington|') = 1

[ashis]

Thank you so much, it works.

[ashis]

Thank you for your reply. it works.

[ashis]

Thank you Marcus, it works.

[ashis]

Thank you Sunny, it works also.😁