Check box issue in Grid component?

[satyanarayana]

In Grid component I have two fields.

One check box field has 4 items.
Second check box field has only one item.

If I checked the second check box , unchecked all the items in first checkbox.

How can I do this problem.
Example:

First field: Your Favorite fruits.
Apple
Banana
Orange
Mango

Second field:None


If I checked none,all fruits(Apple,Banana,Orange,Mango) of status is unchecked in First field.
If I checked any fruit in first field,second field value should be unchecked.

[GGandhi]

Re: Check box issue in Grid component?

hello

why do you need two fields,
can you not have just one with five choices?
such as
apple, banana, orange, mango, none

[satyanarayana]

Re: Check box issue in Grid component?

hello

why do you need two fields,
can you not have just one with five choices?
such as
apple, banana, orange, mango, none

If we take in this way , How can I do that functionality.

[GGandhi]

Re: Check box issue in Grid component?

hello

i am not sure the design of the database you have. but visually speaking,
if you are going to have two fields to answer one question ( say in the grid left column will be favorite foods, the next will be blank or none) it does not not look good, at least for me.
one column to say all about the food will be better to my liking. say apple, orange, banana, mango or none when only one choice needed and you should use radio buttons instead.

if you are going to have more than one selected item just leave the none part and have the initial value set to "None" so when you select any or all the selections the none part will go away,
and if the user have no preference they will simply skip the question because the answer is already there.
correction: None does not apply to checkbox, I was wrong

hope i make sense.

[GGandhi]

Re: Check box issue in Grid component?

hello

this is just a follow up, i think this solution works.

create a field favorite_food use radio button with two choices yes and no
create a field favorite_food_list use checkbox with four choices apple, orange, banana, mango
in the field properties of favorite_food_list show/hide properties use this formula favorite_food = "Yes"
when you preview the list is hidden till the user selects the yes button.

hope this works for you

[frankbicknell]

Re: Check box issue in Grid component?

This is the easiest way that I can think of.

Table with five fields all bit data type. eg apple - type bit, banana, orange, mango, none

in the onChange event of the fruit fields put this.

if (this.checked)
{
{grid.Object}.setValue('G','NONE',false);
}

In the none field onChange

if (this.checked)
{
{grid.Object}.setValue('G','APPLE',false);
{grid.Object}.setValue('G','BANANA',false);
{grid.Object}.setValue('G','ORANGE',false);
{grid.Object}.setValue('G','MANGO',false);
}

There are many other ways to do this as well but hopefully this will get you started.

[agillbb]

Re: Check box issue in Grid component?

As Gandhi said above, but the first field should probably be either a single checkbox (either checked or not) or a radio (two choices).
One other option is what Gandhi said at first - all choices including "none" in a single field, but trap the onclick event (or possibly other event?). When "none" selected, clear all others and when other choice is clicked then unselect "none". This takes a bit more javascript, though.

[satyanarayana]

Re: Check box issue in Grid component?

hello

this is just a follow up, i think this solution works.

create a field favorite_food use radio button with two choices yes and no
create a field favorite_food_list use checkbox with four choices apple, orange, banana, mango
in the field properties of favorite_food_list show/hide properties use this formula favorite_food = "Yes"
when you preview the list is hidden till the user selects the yes button.

hope this works for you

If user first selects the first radio button(YES) and checked two options and now selected the NO option and clicked on submit button. Then the data is saved for none option.

Sorry for bad English. I hope you will understand...

Thanks,

[satyanarayana]

Re: Check box issue in Grid component?

This is the easiest way that I can think of.

Table with five fields all bit data type. eg apple - type bit, banana, orange, mango, none

in the onChange event of the fruit fields put this.

if (this.checked)
{
{grid.Object}.setValue('G','NONE',false);
}

In the none field onChange

if (this.checked)
{
{grid.Object}.setValue('G','APPLE',false);
{grid.Object}.setValue('G','BANANA',false);
{grid.Object}.setValue('G','ORANGE',false);
{grid.Object}.setValue('G','MANGO',false);
}

There are many other ways to do this as well but hopefully this will get you started.

I have 77 options for single field with including none. I will try by taking array.

But we don't know the syntax or whether it is working or not. We have to do trail and error method

[satyanarayana]

Re: Check box issue in Grid component?

This is the easiest way that I can think of.

Table with five fields all bit data type. eg apple - type bit, banana, orange, mango, none

in the onChange event of the fruit fields put this.

if (this.checked)
{
{grid.Object}.setValue('G','NONE',false);
}

In the none field onChange

if (this.checked)
{
{grid.Object}.setValue('G','APPLE',false);
{grid.Object}.setValue('G','BANANA',false);
{grid.Object}.setValue('G','ORANGE',false);
{grid.Object}.setValue('G','MANGO',false);
}

There are many other ways to do this as well but hopefully this will get you started.

I am getting syntax errors when I wrote javascript for field in onChange -->inline javascript

Can you help me how to write javascript sysntax... Plz..

[frankbicknell]

Re: Check box issue in Grid component?

Sorry I did not include the row number in the set value method.
This works for a tabular or form grid with MySQL data.
filed properties are a checkbox with Treat field as logical field selected.

In the none field onChange

if (this.checked)
{
{grid.Object}.setValue('G','APPLE',[COLOR="#FF0000"]{Grid.RowNumber}[/COLOR],false);
{grid.Object}.setValue('G','BANANA',{Grid.RowNumber},false);
{grid.Object}.setValue('G','ORANGE',{Grid.RowNumber},false);
{grid.Object}.setValue('G','MANGO',{Grid.RowNumber},false);
}

In the fruit fields onChange

if (this.checked)
{
{grid.Object}.setValue('G','NONE',{Grid.RowNumber},false);
}

[agillbb]

Re: Check box issue in Grid component?

Note that there is no need for you to create 77 bit fields or an array.

Have a separate table which contains your fruits with a unique string ID.
e.g. Table = Fruits
FruitID - FruitName
F1 - Banana
F2 - Orange
F3 - Peach

Then in your PersonalData table, just have one character field (e.g. FruitIDList).

You will populate your checkbox choices from a simple query.

This field will be a comma-delimited list of FruitIDs - like "F1,F3,F9" - depending on your selection.

This is how checkboxes work in A5 - they generate a comma-delimited list of values.

[frankbicknell]

Re: Check box issue in Grid component?

I missed the part with 77 fields, I thought we were working with 5 fields.

[satyanarayana]

Re: Check box issue in Grid component?

I missed the part with 77 fields, I thought we were working with 5 fields.

Thank you very much...

[GGandhi]

Re: Check box issue in Grid component?

hello

If user first selects the first radio button(YES) and checked two options and now selected the NO option and clicked on submit button. Then the data is saved for none option.

that is correct, if the user selects none before selecting any choices or afterwards, it should return none. is that not supposed to be?
in my example when you select items, it does give you comma delimited array for that field for however many choices you may have, five or seventy-seven.
i thought that is what you are looking for in the first post.