Jump to content
  • 0

multiple entries from a single datapage to one table


Awright

Question

Hello All,

I have a table, we'll call it "group profile", where data that is entered into this table from a webpage may need to be entered more than once for different objects, like so:

  • object1    |    size1    |    age1    |    weight1
  • object2    |    size2    |    age2    |    weight2
  • object3    |    size3    |    age3    |    weight3
  • object4    |    size4    |    age4    |    weight4

each of the entries may or may not be from the same group profile.   These objects may need to be grouped with a "group_ID"  so that the data can be retrieved easily.  Further, the web page is being designed for people who may have ZERO tech skills so ease of use is a must.

 

My question is, can I create a datapage that will take multiple entries (into the same table) from the same web page without having to submit & refresh? Or is there some more elegant solution that Caspio provides for this type of situation?

Or maybe is there a better way that i could set up my tables in the first place?

 

Please and Thank you,

Awright

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 0

Hi @Awright

How about an inline insert?

Create a reports DataPage, and then enable Inline Insert. This way, you only need to click "ADD" on the left part of the report to add new Data. 

Check out this link: https://howto.caspio.com/datapages/reports/data-editing-options-in-reports/

I had a same workflow, and this one is a good workaround. 

- Vanellope

Link to comment
Share on other sites

  • 0

You can have a Submission Datapage with a report deployed in the footer.

The report would use the Group_ID as a parameter to filter the results so you only get the results of that group. Also I assume those fields are drop downs ie 

Select Object 1, Select Size, Select Age, Select Weight,  then hit submit

Then the Group_ID field is hidden and past as a Parameter to the report.

[@field:Group_ 1]

Group 1

  • object1    |    size1    |    age1    |    weight1
  • object2    |    size2    |    age2    |    weight2
  • object3    |    size3    |    age3    |    weight3
  • object4    |    size4    |    age4    |    weight4

You can then use formula and Aggregates to tally the reports IE How many of each object and how many of each size.

 

Link to comment
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...