Setting Check Box to Checked or Unchecked based on a cell

[Former Member]

Hi ,

I need to set a check box in xcelsius to checked or unchecked state based on the value of a cell. Is it possible?

Thanks.

[Former Member]

It is possible in around about way. Please see attachment.

This will also help if anyone is trying to do a select all for all check boxes.

Save attachment than rename and replace the ".txt" to ".xlf".

Cameron Spath

Dickinson + Associates

SelectAll.txt.zip

[Former Member]

Hi, I have 50 checkbox components which is unchecked by default when the dashboard opens. after user checks some of them and submits the values for processing, when that page with the checkboxes comes back, I need those checkboxes reset back to unchecked. If this was the only screen in my dashboard, then a reset button works fine to solve my problem(i.e it unchecks on clicking the reset button). I have multiple screens on this dashboard. So, I need to somehow uncheck the check boxes when the user returns to this page.

[Former Member]

Hi,

Yes we can make it as possible dude. There is a simple funda to acheive this.

I accept that there is no direct way to acheive it, but if we implement a simple logic

we can achieve this.

we use 2 check boxes with same insert in.

The 1st check box should be checked and the other should be Unchecked.

When you insert some thing like 1 in a cell then u should get the Checked one

insert in Cell: B1

Formulae in C1: If(B1=1,1,0)

DV for CheckBox 1: C1

DV status: 1

DV for CheckBox 2: C1

DV status: 0

Here the insertin will take the value of the visible component, in future if u want to throw any values from the chek box

it will work properly.

If you explain your problem elaborately, i hope i can help you in this logic.

Regards,

AnjaniKumar C.A.

[Former Member]

Hi AnjaniKumar ,

Thanks for the reply. I have tried the way you have explained. I have run into an issue in that case. Here is the sequence of steps:

1. By default Unchecked box B2 shows up.

2. I check that box, then Checked Box B2 shows up.(using your logic)

3. Now, B2 is also in checked state. So, when I uncheck B1, it shows B2 with checked state.

I hope am clear. Please let me know if you need more information.

Thanks,

KartheeK

[Former Member]

Hi KartheeK

You can use the reset button if u wanna reset the values of Check box.

Regards,

AnjaniKumar C.A.

Edited by: AnjaniKumarCasula on Jun 9, 2010 7:58 AM

[Former Member]

Not possible. You can do this only for very limited components like radio button, combo & Label based menu, List Box.

[Former Member]

I agree that it is not possible directly, but you may be able to get the desired effect by using 2 check box components, one with default of checked and the other with a default of unchecked, with DV set to a value held in the cell you are talking about.