One form into many records

[MHDslagelse]

I would like a submission form with the possebilly to have one form with to or more files for each person going into x numbers of records

 

Like this

Form

Name1 and Phone1

Name2 and Phone2

Name3 and Phone3

 

I the database it will create 3 records. Not one record 

 

How to do that please ;o)

[Mathilda]

23 hours ago, MHDslagelse said:

I would like a submission form with the possebilly to have one form with to or more files for each person going into x numbers of records

 

Like this

Form

Name1 and Phone1

Name2 and Phone2

Name3 and Phone3

 

I the database it will create 3 records. Not one record 

 

How to do that please ;o)

You could insert all those fields in table design in order to have all fields in one record.

[MHDslagelse]

On 28/8/2017 at 11:09 AM, Mathilda said:

You could insert all those fields in table design in order to have all fields in one record.

Sure - But that is not best practice in a database

I looking for something like

For i = 1 To 3
  Set Name = Name+i and Phone = Phone+i
Next 

 

And I will have these 3 records

ID	Name	 Phone
1	Jack		  12345678
2	James		11223344
3	Susan		22334455

 

[Mathilda]

On 9/21/2017 at 11:33 PM, MHDslagelse said:

Sure - But that is not best practice in a database

I looking for something like

For i = 1 To 3
  Set Name = Name+i and Phone = Phone+i
Next 

 

And I will have these 3 records

ID	Name	 Phone
1	Jack		  12345678
2	James		11223344
3	Susan		22334455

 

As far as I know, mass insert is not allowed in caspio, therefore I would submit each record separately 

[douvega]

You can do something like that using the API by looping into your data. However, it seems that what you need is a relational database so you can build a Tabular Datapage and enable the inline adding option, this way, your users will be able to insert new records without having to refresh the whole page which is what you are looking for, I think.