DB save

HY,

in a form i use a DB save.
When that form is completed and i look ad the record the field title does not display the data as entered on the form🙄 (see attachment)In the settings there is also a fieldname but the result does not change!?
I could not find info on this subject. Can someone help with this

Hi PeterL,

Please drag a Handle Arrays action into the OnSubmit event and move it up before the DB Save action.

Bob

oké, Thanks!
But....I need something to fill?
because nothing changes😶

Peter

Hi PeterL ,

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

Note: if you are using the Easy Wizard you may need to switch to the Advanced Wizard to do this; if you want to continue to use the Easy Wizard please make a copy of your form first and add the Debugger action to the copy.

Bob

Data Array:

Array
(
    [input_text_0] => Peter Lieberwirth
    [input_text_1] => Steenstraat 82
    [input_text_2] => 5521KV
    [input_text_3] => Eersel
    [input_text_4] => 0497516344
    [input_text_5] => p.lieberwirth@me.com
    [input_checkbox_6] => 
    [input_checkbox_7] => 1
    [input_textarea_8] => Alje, wederom een test.

Peter
    [chrono_verification] => u2JFv
    [input_submit_9] => Verzenden
    [8e8b5b938c47c488911ab130acb3a0a1] => 1
    [chronoform] => Aanmelden
    [event] => submit
    [Itemid] => 108
    [option] => com_chronoforms
    [view] => form
    [chronoform_data] => Array
        (
            [cf_uid] => 535cee79081137e087fe4f665a4a5d82
            [cf_created] => 2012-04-29 10:24:37
            [cf_ipaddress] => 212.83.83.215
            [cf_user_id] => 0
            [input_text_0] => Peter Lieberwirth
            [input_text_1] => Steenstraat 82
            [input_text_2] => 5521KV
            [input_text_3] => Eersel
            [input_text_4] => 0497516344
            [input_text_5] => p.lieberwirth@me.com
            [input_checkbox_6] => 
            [input_checkbox_7] => 1
            [input_textarea_8] => Alje, wederom een test.

Peter
            [chrono_verification] => u2JFv
            [input_submit_9] => Verzenden
            [8e8b5b938c47c488911ab130acb3a0a1] => 1
            [chronoform] => Aanmelden
            [event] => submit
            [Itemid] => 108
            [option] => com_chronoforms
            [view] => form
            [cf_id] => 16
        )

    [chronoform_data_cf_id] => 16
)

Uw aanmelding is met succes verzonden.

Wij danken u voor uw steun aan ons initiatief en houden u op de hoogte.

Het burgercomite
Debug Data

    2
        An email has been SENT successfully from (Aanmelden)info@iedereenglasvezel.nl to alje.brouwer@iedereenglasvezel.nl
        Email template:

        Naam (verplicht): 	Peter Lieberwirth
        Straat & Huisnummer: 	Steenstraat 82
        Postcode: 	5521KV
        Woonplaats (verplicht): 	Eersel
        Telefoonnummer: 	0497516344
        Uw email (verplicht): 	p.lieberwirth@me.com
        Ik wil op de hoogte gehouden worden over het burgerinitiatief 	
        Ik wil me aktief inzetten voor het burgerinitiatief 	1
        De belangrijkste vragen zijn voor mij: 	Alje, wederom een test.

        Peter


        Submitted by 212.83.83.215
        Attachments:
        array ( )
    Core Captcha
        Passed the core captcha check!

Hi PeterL,

That all looks correct to me. Which inputs do you think aren't saving correctly? All the entries from the DB Save look the same as the data submitted from the form?

Bob

Hello GreyHead,

as you can see in the attachment there is input_text_0, input_text_1 etc.
This should be, Name, Street, etc.🙄

Peter

Hi PeterL,

Well yes, it shows the names you have given to the input elements in the form. In this case as you've left the default names that's what shows up.

To change them you'll need to edit the form elements to give them meaningful names ( I suggest that you add ids at the same time) and then edit or re-create the database table so that the column names match the input names.

Bob