listbox as checkbox

[#1]

Hi guys,

I created a checkbox from a listbox and everything works for this expression.

= if(match([MaterialTaste],'WATER','Water'),'WATER','ALL EXCEPT WATER')

This works and I get the display as follows:

Fig1 is when nothing is selected and is correct.

Fig2 is when Water Checkbox is selected and other selections(calendar options + other selections) are made. It works and is correct

Fig3 is when ALL EXCEPT WATER Checkbox is selected and other selections(calendar options + other selections) are made. I does not have a Tickmark.

How to get the tickmark also for ALL EXCEPT WATER checkbox? Any ideas.

Customers want it otherwise they are getting confused without tickmark.

Thanks and Regards

Sravan

[#2 · Accepted solution]

Hi Sravan,

I recommend making a new field in your script.

if(match([MaterialTaste],'WATER','Water'),'WATER','ALL EXCEPT WATER') as NewMaterialTaste

[Miguel_Angel_Baeyens]

Hi,

You might use MixMatch() instead of Match(), since is case insensitive.

Regards.