Forums

checkboxes group

wissam.abdo@usj.edu.lb 11 Dec, 2012
Hi,
I am using Joommla 2.5, I have a form that i created in CF.
I have in this form a checkboxes group field, whenever the user choose a value or multiple value, nothing is written in the table for this field!
i verified the name and all the options, nothing wrong.

P.S: how can I, through joomla screens, see the actual structure of the table that I am writing on?

many thanks
GreyHead 11 Dec, 2012
Hi wissam.abdo,

Please see this FAQ

Bob

PS I suggest that you don't use your email address as a username here as it is publicly visible. If you PM me with an alternative I can change it for you.
wissam.abdo@usj.edu.lb 12 Dec, 2012
I checked all the points referenced in the FAQ list, it's all ok for me.
i'm wondering why it is not saved in the table, adding to this i have 3 fields in this table of type checkboxes group and for all of them i have this issue.
Attach a printscreen of my config fields.

thanks in advance

here is the script of the table, the 3 fields are English French Spanish:
`ckw20_chronoforms_data_worldassemblyform3` (
`cf_id` int(11) NOT NULL AUTO_INCREMENT,
`cf_uid` varchar(255) NOT NULL,
`cf_created` datetime NOT NULL,
`cf_modified` datetime NOT NULL,
`cf_created_by` int(11) NOT NULL,
`cf_modified_by` int(11) NOT NULL,
`cf_ipaddress` varchar(255) NOT NULL,
`cf_user_id` int(11) NOT NULL,
`First_Name` varchar(255) NOT NULL,
`Name` varchar(255) NOT NULL,
`Gender` varchar(255) NOT NULL,
`Date_of_Birth` varchar(255) NOT NULL,
`input_email` varchar(255) NOT NULL,
`Photo` varchar(255) NOT NULL,
`Occupation` varchar(255) NOT NULL,
`Address` varchar(255) NOT NULL,
`Community_Delegation` varchar(255) NOT NULL,
`Country` varchar(255) NOT NULL,
`Phone` varchar(255) NOT NULL,
`Mobile` varchar(255) NOT NULL,
`Fax` varchar(255) NOT NULL,
`Skype_contact` varchar(255) NOT NULL,
`Member_of_CLC_since` varchar(255) NOT NULL,
`Member_current_group` varchar(255) NOT NULL,
`input_text_34` varchar(255) NOT NULL,
`input_text_35` varchar(255) NOT NULL,
`Guide_Spiritual_Exercises` varchar(255) NOT NULL,
`Member_formation_team` varchar(255) NOT NULL,
`Group_Guide_since` varchar(255) NOT NULL,
`National_or_Regional_Eccl_Assistant` varchar(255) NOT NULL,
`Delegate_previous_General_Assembly` varchar(255) NOT NULL,
`Other_experience` varchar(255) NOT NULL,
`English` varchar(255) NOT NULL,
`French` varchar(255) NOT NULL,
`Spanish` varchar(255) NOT NULL,
`Other_languages` varchar(255) NOT NULL,
`needs` varchar(255) NOT NULL,
`diet` varchar(255) NOT NULL,
`laptop` varchar(255) NOT NULL,
`input_submit` varchar(255) NOT NULL,
PRIMARY KEY (`cf_id`)
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8$$
GreyHead 12 Dec, 2012
Hi wissam.abdo,

Have you added a Handle Arrays action to your form On Submit event?

Please drag a Debugger action into the On Submit event, then submit the form and post the debug - including the 'dummy emails' results here.

Note: if you are using the Easy Wizard you can turn on Debug on the Others tab.

Bob
wissam.abdo@usj.edu.lb 12 Dec, 2012
thanks.

here is the result. it's ok but no data for these 3 fields in the table !

Data Array:

Array
(
    [chronoform] => WorldAssemblyForm
    [event] => submit
    [Itemid] => 270
    [option] => com_chronoforms
    [lang] => fr
    [view] => form
    [First_Name] => testFR11
    [Name] => testFR11
    [Gender] => Male
    [Date_of_Birth] => 2012-12-05
    [input_email] => awissam@yahoo.com
    [Photo] => 
    [Occupation] => 
    [Adresse] => 
    [Community_Delegation] => 
    [Country] => testFR11
    [Phone] => 
    [Mobile] => 
    [Fax] => 
    [Skype_contact] => 
    [Member_of_CLC_since] => 
    [Member_current_group] => 
    [input_text_34] => 
    [input_text_35] => 
    [Guide_Spiritual_Exercises] => 
    [Member_formation_team] => 
    [Group_Guide_since] => 
    [National_or_Regional_Eccl_Assistant] => 
    [Delegate_previous_General_Assembly] => 
    [Other_experience] => 
    [Anglais] => Lu,Compris
    [Francais] => choice 3,choice 4
    [Espagnol] => Ecrit
    [Other_languages] => 
    [needs] => 
    [diet] => 
    [laptop] => 
    [input_submit] => Submit
    [8c85533210e09033cbe39a50865c5aa5] => 1
    [language] => fr-FR
    [_PLUGINS_] => 
    [chronoform_data] => 947b448bf77d6f27b1fc42f9985cc2d7,2012-12-12 11:34:05,0,178.135.28.17,0,WorldAssemblyForm,submit,270,com_chronoforms,fr,form,testFR11,testFR11,Male,2012-12-05,awissam@yahoo.com,,,,,testFR11,,,,,,,,,,,,,,,Lu,Compris,choice 3,choice 4,Ecrit,,,,,Submit,1,fr-FR,,43
    [chronoform_data_cf_id] => 43
)

Validation Errors:

Array
(
)

Debug Data

    email
        4
...
GreyHead 12 Dec, 2012
Hi wissam.abdo,

I see 'Anglais' in the form data but there is no input named 'English' returning a result.

Bob
wissam.abdo@usj.edu.lb 13 Dec, 2012
no, cause the language was french, but even in english language i have the same issue. please see below what the debugger write:

[chronoform] => WorldAssemblyForm
[event] => submit
[Itemid] => 274
[option] => com_chronoforms
[lang] => pt
[view] => form
[First_Name] => wissam
[Name] => wissam
[Gender] => Female
[Date_of_Birth] => 2012-12-12
[input_email] => [email]awissam@yahoo.com[/email]
[Photo] =>
[Occupation] =>
[Address] =>
[Community_Delegation] =>
[Country] => wissam
[Phone] => ++961 369
[Mobile] =>
[Fax] =>
[Skype_contact] =>
[Member_of_CLC_since] =>
[Member_current_group] =>
[input_text_34] =>
[input_text_35] =>
[Guide_Spiritual_Exercises] =>
[Member_formation_team] =>
[Group_Guide_since] =>
[National_or_Regional_Eccl_Assistant] =>
[Delegate_previous_General_Assembly] =>
[Other_experience] =>
[English] => Understand,Speak
[French] => choice 3,choice 4
[Spanish] => Write
[Other_languages] =>
[needs] =>
[diet] =>
GreyHead 14 Dec, 2012
Hi wissam.abdo,

There's something very odd about the sequence of events I think. Do you have the Handle Arrays action *after* the DB Save action? It needs to be before it.

Bob
wissam.abdo@usj.edu.lb 16 Dec, 2012
thanks for the response.
ok, i put the debugger before, here is what i have:


Data Array:

Array
(
[chronoform] => WorldAssemblyForm
[event] => submit
[Itemid] => 274
[option] => com_chronoforms
[lang] => pt
[view] => form
[First_Name] => test4
[Name] => test4
[Gender] => Female
[Date_of_Birth] =>
[input_email] => [email]awissam@yahoo.com[/email]
[Photo] =>
[Occupation] =>
[Address] =>
[Community_Delegation] =>
[Country] => test4
[Phone] =>
[Mobile] =>
[Fax] =>
[Skype_contact] =>
[Member_of_CLC_since] =>
[Member_current_group] =>
[input_text_34] =>
[input_text_35] =>
[Guide_Spiritual_Exercises] =>
[Member_formation_team] =>
[Group_Guide_since] =>
[National_or_Regional_Eccl_Assistant] =>
[Delegate_previous_General_Assembly] =>
[Other_experience] =>
[English] => Array
(
[0] => Read
[1] => Understand
)

[French] => Array
(
[0] => Understand
[1] => Speak
)

[Spanish] => Array
(
[0] => Speak
)

[Other_languages] =>
[needs] =>
[diet] =>
[laptop] =>
[input_submit] => Submit
[d90d14140ed9446ff1d5229839a0bd32] => 1
[language] => pt-PT
[_PLUGINS_] => Array
(
[upload_files] => Array
(
)

)

)

Validation Errors:

Array
(
)
wissam.abdo@usj.edu.lb 16 Dec, 2012
oh, it seems in english it works now, but when it comes to french it doesn't
wissam.abdo@usj.edu.lb 17 Dec, 2012
Hi, so as i said in my previous post, in English it works but not in French.

here is the translation settings :

English=Anglais
French=Francais
Spanish=Espagnol
Read=Lu
Understand=Compris
Speak=Parlé
Write=Ecrit
Other languages...= Autres langues...

here is the message that I have:


Data Array:

Array
(
[chronoform] => WorldAssemblyForm
[event] => submit
[Itemid] => 270
[option] => com_chronoforms
[lang] => fr
[view] => form
[First_Name] => regiFR2
[Name] => regiFR
[Gender] => Male
[Date_of_Birth] => 2012-12-10
[input_email] => [email]awissam@yahoo.com[/email]
[Photo] =>
[Occupation] =>
[Adresse] =>
[Community_Delegation] =>
[Country] => regiFR
[Phone] =>
[Mobile] =>
[Fax] =>
[Skype_contact] =>
[Member_of_CLC_since] =>
[Member_current_group] =>
[input_text_34] =>
[input_text_35] =>
[Guide_Spiritual_Exercises] =>
[Member_formation_team] =>
[Group_Guide_since] =>
[National_or_Regional_Eccl_Assistant] =>
[Delegate_previous_General_Assembly] =>
[Other_experience] =>
[Anglais] => Array
(
[0] => Lu
[1] => Compris
)

[Francais] => Array
(
[0] => Compris
[1] => Parlé
)

[Espagnol] => Array
(
[0] => Parlé
)

[Other_languages] =>
[needs] =>
[diet] =>
[laptop] =>
[input_submit] => Submit
[a94bcd6d1f50d5178cc1a53e26ca04d7] => 1
[language] => fr-FR
[_PLUGINS_] => Array
(
[upload_files] => Array
(
)

)

)

Validation Errors:

Array
(
)
GreyHead 17 Dec, 2012
Hi [email]wissam.abdo@usj.edu.lb[/email],

If you look at the results you'll see that you are translating the **names** of the Checkboxes, change the names or the values so that the names are not changed.

Bob
wissam.abdo@usj.edu.lb 18 Dec, 2012
sorry i didn't well understand what you said. anyway i changed the value nothing change, i changed the name nothing changed. same issue.

thanks
GreyHead 18 Dec, 2012
Hi [email]wissam.abdo@usj.edu.lb[/email],

What entries do you have in your Multi-language aactions?

Bob
wissam.abdo@usj.edu.lb 18 Dec, 2012
originally:

English=Anglais
French=Francais
Spanish=Espagnol
Read=Lu
Understand=Compris
Speak=Parlé
Write=Ecrit
GreyHead 18 Dec, 2012
Hi wissam.abdo,

You have in your form a checkbox with HTML something like this
<input type='checkbox' name='English' id='English' value='English' /><label for='English'>English</label>

so in the translated version this becomes
<input type='checkbox' name='Anglais' id='Anglais' value='Anglais' /><label for='Anglais'>Anglais</label>
when all you really want to change is the label text.

If you change the Label to ##English## and then put
##English##=English
and
##English##=Anglais
it will just translate the label text.

Bob
This topic is locked and no more replies can be posted.