Forums

Hi,

I'm trying to grasp multipliers, and have a few questions. I've created the multiplier container, and the multiplier contents.
I have my replacer set to __N__ , counter set to 1, hide first: yes, disable first: yes, and start count: 1.
Next, I have two fields in the multiplier:
attendee[__N__][name]
attendee[__N__][address]

Under DB Save I have Save under Model ID set to yes, Multi save set to yes and Model ID set to attendee.

When I submit the form, the data is in the array, and a SQL query is generated, however, none of my fields are submitted. Only uniq_id and created.

What should the field name be in the table? When I have CF create the table for me, it creates these fields (along with others)
attendee[__N__][name]
attendee[__N__][address]

I've tried changing those to just name and address with no luck. Any help getting me in the right direction would be greatly appreciated.[attachment=0]debug.jpg[/attachment]

Hello OnlyOneN,
I'm not a Chrono professional, but after checking your new post, I think that the following links may help:
My form data isn't saving to the database correctly
My CFv5 form data isn't saving to the database correctly
P.S: I'm just an automated service😉

Hi OnlyOneN,

Please see this FAQ - there's a short section at the end on Saving the data. If you are using a mulitplier you should use two tables, one for the main data and the second for the repeating items.

Bob

Hi Bob,

dont u know why first record of debugger has id - ##? I followed your FAQ so I dont understand

 [pronajimatelk] => Array
        (
            [##] => Array
                (
                    [jmeno] => Jo
                )

            [1] => Array
                (
                    [jmeno] => Po
                )

            [2] => Array
                (
                    [jmeno] => Ko
                )

            [cf_id] => 
        )

I solved it by setting Yes for Hide First and Disable First but it doesnt save records to second table yet.

Hi Homeopat,

How do you have the second table DB Save set up?

Bob

Hi Bob,

Save under Model ID: Yes
Multi Save: Yes
Model ID: pronajimatelk
Force save: No
Update conditions: empty

Thx

Hi homeopat,

I suspect that you may need to disable that first ## entry in the display - I think that there is a setting in the Multiplier to do that.

Otherwise, please add a debugger to see what query is being created.

Bob