insert multiple records into the same table

Hi,

I've been trying this without any luck so far.

I have a chronoform with 2 fields, say Name and Email, repeated 2 times. When the user fills in both name and email pairs and clicks on submit,i would like to create 2 records (hence 2 db saves and 2 inserts into the same table) with the values of the Name and Email set correctly for each record.

Iam somehow under the impression that this might have to do with naming each Name, Email pair with a model id. So two different model id's would have the Name and Email fields associated with them and therefore those 2 model id's need to go into 2 db saves (even though it's just one table into which both records go). And yes, both records have auto increment id's so that's taken care of.

Any help please 🙂

Hi csdpl,

We have talked about this before. I think that the practical solution is to use a Custom Code action to hand-code the MySQL query to save the separate records.

There's an example here - there are other ways to code it as well.

Bob

Hi bob, I tried the link that you gave and it works to me..I can now insert multiple records into the same table.
--gina

Hi gina23 ,

Great, good to hear that you got it to work :-)

Bob