I'm new to Caspio.
I've created two data tables. One is a parent table that will hold venue information, and the other is a child table that will hold a list of camps being held at various venues. A venue_id ties them together.
The camps form has just a couple fields: Camp name, ages, dates, cost.
What I want is for a venue to be able to enter its details, and then add as many summer camps as it plans to host.
The way I have accomplished this so far is to make a datatable for the venue, then pass the venue_id parameter to a datatable for the camps form. The camps form is set to reload itself with that venue_id upon form submission.
This works, but the experience is less than ideal.
Is there some way that I could set up the camps form in a tabular style, so that each row is a camp. and each column is a field? The form would have an "add more" button to allow the user to add more rows as necessary. Then the "submit" button would submit all the rows, each as a separate record?
Here is a mock up of what I want to achieve:
How can I do this?