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

    A way to get kids details in the form and have them into its own cell in the excel file

    Asked by Playgroup on April 09, 2015 at 11:53 AM

    Hi, 

    I have a registration form where parents can sign up their kids for our program. Each parent can sign up multiple kids, but we need to collect various details about each kid.

    I have tried different matrix widgets, but the data in excel shows up bunched together in one cell. Is there a widget I can use so that parents can add as many kids as they want, inputing various fields per kid, and so that each data point becomes its own cell in excel?

    Thanks for your help!

    Andrea

     

     

    Page URL:
    http://form.jotform.ca/form/50115894966263?

    format registration form excel different parent
  • Profile Image
    JotForm Support

    Answered by Welvin on April 09, 2015 at 01:12 PM

    Hi Andrea,

    That's how the data will appear in the excel file for now. I can't think of a possible way other than using our show/hide conditional logic. This method requires you to add a set of fields for the kids and show them based on the parent number input.

    https://www.jotform.com/help/196-Hide-or-Show-Multiple-Fields-at-Once

    or

    https://www.jotform.com/help/297-Show-or-Hide-multiple-fields-at-once-using-form-collapse-tool

    Well, this method defeats the purpose of adding contents dynamically.

    Or, you can also use Matrix field with textbox input type:

    Let us know if you have any further questions.

    Thanks