What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Registration Form with multiple registrants.

    Asked by oecc on March 05, 2016 at 08:48 AM

    I need to build a form for our local Junior Cricket club.

    My current form is here:

    https://form.jotformeu.com/53254637327357

     

    Everything is fine if each parent only needed to register only one child.

    However some parents need to register more than one child. 

    Hence, I have included a field "Do you want to register a second child?" third child, forth child.

     

    The problem:

    When more than one child is registered it creates both child's details on one line in the database, Excel spreadsheet.

    This is very difficult and messy to deal with and does not display in a usable format in an HTML Table Listing.

    I would like the data for each child to be on a separate line.

    However I do not want the parent to have to complete a new form for each child.

    So if more than one child is registered how do I build the form to write the data for the first child on Submit and if there is a second child, continue the form and write that data on to a new line on the next Submit etc?

    Any ideas?

    Many thanks.

    Robert

     

     

    Page URL:
    https://form.jotformeu.com/53254637327357

    registration form new form html table listing problem excel
  • Profile Image

    Answered by oecc on March 05, 2016 at 11:18 AM

    I've had an idea!

    If I create a Start Form and this redirects to a second form for the second child's details if the condition for "Register another Child" is Yes or redirects to the End Form for payment if NO.

    So I will have a:

    START FORM - Parents details & Child 1 details.

    CHILD 2 FORM - Child 2 details.

    CHILD 3 FORM - Child 3 details.

    CHILD 4 FORM - Child 4 details.

    END FORM - Final details & payment.

     

    This may work?

     

     

     

  • Profile Image

    Answered by oecc on March 05, 2016 at 11:21 AM

    Ah, the trouble is the submissions will all be in different forms!

    Any way of combining submissions from different forms?
  • Profile Image
    JotForm Support

    Answered by jonathan on March 05, 2016 at 09:17 PM

    We will resolve your next question here http://www.jotform.com/answers/788211

    Thanks.