multiple entries from a single datapage to one table

[Awright]

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

[Glitch]

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

[Corpcat]

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.