Issues with checkbox control

[drgarytraub]

I have a checkbox similar to:

- dogs
- cats
-tigers

I can use javascript to set the value to say dogs (by saying checkbox=dogs, and then the dogs box is checked - similarly for cats and tigers.

But, if I want to check the dogs box AND the cats box, and I try to set the checkbox to check the dogs AND cats checkboxes (by saying checkbox=dogs,cats nothing happens.

So if I use {grid.Object}.setValue('G','SLEEP_PROBLEMS',rowNum,'Good'); the good box is checked
If I use {grid.Object}.setValue('G','SLEEP_PROBLEMS',rowNum,'Poor'); the poor box is checked
But, if I use {grid.Object}.setValue('G','SLEEP_PROBLEMS',rowNum,'Good,Poor'); nothing happens when what I want is for good and poor both to be checked.

What am I missing?

[iRadiate]

Re: Issues with checkbox control

Maybe something like {grid.Object}.setValue('G','SLEEP_PROBLEMS[]','[Good','Poor']);

[drgarytraub]

Re: Issues with checkbox control

That does not work, and neither does this: {grid.Object}.setValue('G','SLEEP_PROBLEMS',rowNum,'[Good','Poor']);

The real issue that I am trying to resolve is to do this with a lookup. For example, I have a form with a checkbox control as described above. I also have defined a lookup table so that when a link is clicked, it will open a table showing me a list of prior records I can copy in to the new record. The lookup grid is also made up of checkbox controls. This works as expected when there is only one box checked on the lookup grid's checkbox control, but does not work at all when there is more than one box checked. Two or more values will copy correctly from the lookup in to the new record if the receiving control is a textbox control but not a checkbox control. Is this a bug? Or is there a workaround?

[madtowng]

Re: Issues with checkbox control

Try this.

{grid.Object}.setValue('G','SLEEP_PROBLEMS[]',rowNum,'Good','Poor');

[RichCPT]

Re: Issues with checkbox control

Maybe a Grid is different, but in a UX you would not include [] after the control ID and you would pass in an array not a string. It would look like this:

{dialog.object}.setValue('SLEEP_PROBLEMS', ['Dogs', 'Cats']);

So, in Post # 2 above, there is a typo, I think meant to write:

{grid.Object}.setValue('G','SLEEP_PROBLEMS[]'[COLOR="#FF0000"], rowNum, ['[/COLOR]Good','Poor'] );

If that does not work then try using just the straight control name like this:

{grid.Object}.setValue('G','SLEEP_PROBLEMS', rowNum, ['Good','Poor'] );

[RichCPT]

Re: Issues with checkbox control

If you are getting a comma delimited string of choices from your lookup window when you do the 'getValue' then convert that string back into an array before calling setValue.

Slctd = Slctd .split(',');

[iRadiate]

Re: Issues with checkbox control

So, in Post # 2 above, there is a typo, I think meant to write:

{grid.Object}.setValue('G','SLEEP_PROBLEMS[]'[COLOR="#FF0000"], rowNum, ['[/COLOR]Good','Poor'] );

Perhaps Rich is correct, however the Alpha Documentation on this states the following regarding checkboxes:

Set the value in 'FAVORITECOLOR'. Assume that 'FAVORITECOLOR' is a multi-valued field (e.g. a Checkbox control or a Dropdown control configured to allow multiple values):
{grid.Object}.setValue('S','FAVAORITECOLOR[]',['alpha','beta','gamma']);

https://www.alphasoftware.com/docume...e%20Method.xml

[Sarah Mitchell]

Re: Issues with checkbox control

I have a checkbox similar to:

- dogs
- cats
-tigers

I can use javascript to set the value to say dogs (by saying checkbox=dogs, and then the dogs box is checked - similarly for cats and tigers.

But, if I want to check the dogs box AND the cats box, and I try to set the checkbox to check the dogs AND cats checkboxes (by saying checkbox=dogs,cats nothing happens.

So if I use {grid.Object}.setValue('G','SLEEP_PROBLEMS',rowNum,'Good'); the good box is checked
If I use {grid.Object}.setValue('G','SLEEP_PROBLEMS',rowNum,'Poor'); the poor box is checked
But, if I use {grid.Object}.setValue('G','SLEEP_PROBLEMS',rowNum,'Good,Poor'); nothing happens when what I want is for good and poor both to be checked.

What am I missing?

Hello Everyone!

I saw this post today and updated the documentation for {grid.object}.setValue() to clarify the information and hopefully clear up this question.

The syntax to set multiple values is an array. You must specify the row number if you're setting the value in a Grid row. Otherwise, the row number is not needed:

// Grid Part
{grid.object}.setValue('G','COLORS[]',2,['blue','grey']);

// Search Part - no row number
{grid.object}.setValue('S','COLORS[]',['blue','grey']);

// Detail View Part - no row number
{grid.object}.setValue('D','COLORS[]',['blue','grey']);

The [] are not necessarily required here as the method will append them if they are needed. However, in other contexts -- such as using the $n() method -- you must include them. So it's best to be in the habit of adding them.

Hope this is helpful.