Listbox as Check box

[carolin01]

Hello,

If I have a list box and use it as check box is it possible to keep a specific value always checked even if one press clear?

I would like to keep "Total" in my list box even if you click clear.

Many thanks in advance for your help.

Best regards,

Carolin

[jsingh71 · Accepted solution]

Hi Carolin,

First you select Total from your list box and then click on Set Clear state option.

After that you can select other options also in list box and then click on clear. It will clear all other except the first one which you selected before click on Set Clear Set.

And also in Sheet properties add one trigger Select in Field for selecting specific option what you want.

[#3]

Hope attached example is what you are looking for...

I have used a Field Event Trigger (Settings > Document Properties > Triggers) to toggle select 'Total' if 'Total' is deselected.

When you implement it for the first time, however, 'Total' might be unselected. But selecting it once will keep the Toggle Select cycle going forever.

[jsingh71]

you are right pradip earlier I didn't checked, I thought carolin is using LED but she didn't.

[carolin01]

I liked this but for some reason it didn´t work when I copied the expression from that weg page. I noticed that I had to use [$Field] instead which worked first well but it stopped working at this stage:

As you can see from the text box it doesn´t give '0' as result and I don´t know why as one step before it still worked all well.

[MK_QSL]

I am using the same.

Dont just read the post but check the whole video.

It should definitely work.