Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
try below one
=if(GetFieldSelections(City)='Boston' or GetFieldSelections(City)='Washington' or
GetFieldSelections(City)='Boston, Washington',1,0)
Regards,
Sultan
Maybe this approach is more suitable:
wildmatch(concat(distinct City, ','), '*Boston*', '*Washington*')
- Marcus
You can also try this
SubStringCount(Concat(DISTINCT '|' &City & '|'), '|Boston|') = 1
or
SubStringCount(Concat(DISTINCT '|' &City & '|'), '|Washington|') = 1
Hi,
try below one
=if(GetFieldSelections(City)='Boston' or GetFieldSelections(City)='Washington' or
GetFieldSelections(City)='Boston, Washington',1,0)
Regards,
Sultan
Maybe this approach is more suitable:
wildmatch(concat(distinct City, ','), '*Boston*', '*Washington*')
- Marcus
You can also try this
SubStringCount(Concat(DISTINCT '|' &City & '|'), '|Boston|') = 1
or
SubStringCount(Concat(DISTINCT '|' &City & '|'), '|Washington|') = 1
Thank you Marcus, it works.
Thank you Sunny, it works also.😁