Save form data in 2 tables

Hello there,

Data in a form is stored in 2 tables in the database.
This also works.
I have the form a Multiplier container (screen). This more records to be stored in the second table.
Unfortunately, only one record is always stored. Where can be the error?
These are my settings in the "Setup" of the form to save the data in the second table:
Custom code:

     
<? php
$ form-> data ['Data_1'];
?>   

If I set "Multiple writes" to "yes", then it does not work either.


Thank you for the help.

F.

Hello Fredolino,
I'm not a Chrono professional, but after checking your new post, I think that the following links may help:
How do I save form data to a database table?
My form data isn't saving to the database correctly
My CFv5 form data isn't saving to the database correctly
How to load record data from a database table into your form
P.S: I'm just an automated service😉

Hi Fredolino,

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

Bob

Hi,

I changed the Custom Code in Setup:

<?php 
$form ->data["id_firma"] =  $form ->data ["id"];
?>

Now me, a record in the second table is stored.
Why he did not save me from my second record in the second table?

Table1 and table2 are linked (screen1).

For DB Save I have these settings (Screen2).
The option "Multiple writes" has not worked.

What am I doing wrong?

Hello there,

in my form the main data in the first table is correctly stored in the first table.
Why me saves the form but at the same time always only one record in my second table from?
In form I give a 2 records and more for the 2nd table.

1. Tabelle
id (PK)
...

2. Tabelle
id_auftrag (PK)
id_firma (FK)
...

Custom-Code in Setup:

 <?php 
$form ->data["Firma_1"]["id_firma"] =  $form ->data["id"];
?>

The ID number of Table 1 is neatly stored in Table 2 below.

F.

HI Fredelino,

Because there is no data in the $form->data array with names that match the column names in the table?

Bob

Hi,

wie bekomme ich das Ergebnis:

 [Firma_1] => Array
   (

            [1] => Array

                (

                    [position] => Assi
                    [spezifikation] => spezi
		    [status] => in bearb
		    [provision] => 1.000
                    [id_auftrag] => 12

                )


            [2] => Array

                (

                    [position] => Messi
                    [spezifikation] => spezialo
		    [status] => weg
		    [provision] => 2.000
                    [id_auftrag] => 13

                )


            [id_firma] => 58

        )

Firma_1 is the Model_id
id_firma is id from the Main data set
id_auftrag is the automatically assigned ID of the 2nd table in which the records of the order to be saved.

I have 1 Container, in the Container:
Multiplier-Container
- Multiplier Content
-- Multifield with z.B. Fieldname: [Firma_1][position][##]

F.

Hi,

now I'm getting a bit further.
Now only is still the problem that my records are not stored in the 2nd table.
What can be the problem?

F.

Hi,

solved :-)
is ok.

F.

How did you solve this?