Jump to content
  • 0

One form into many records


Question

4 answers to this question

Recommended Posts

  • 0
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.

Link to post
Share on other sites
  • 0
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

 

Link to post
Share on other sites
  • 0
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 

Link to post
Share on other sites
  • 0

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.

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...