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

    Configuration List -Request - submitted data in multiple cells in Excel sheet

    Asked by CinderellaSunflower on January 29, 2017 at 07:25 PM

    Hey! I am working with an event that wants to be able to sign up families and individuals for four classes throughout the event. I would like each form to be one family, but the individuals sign up for different classes. The way I'm trying to fix this is by using configurable lists, that is, normal fields for the family's info as a whole, but a config. list to add individuals' info. I guess I have a few questions about this:

    1) is there a better way to do this? This is the most efficient solution I have come up with, but it requires some work on my end to put individuals into the spreadsheet on separate lines, as the config. list enters them into one cell. I could have each individual submit a form, but that seems like more work than necessary on their part.

    2) I suppose that what I really want to know is how to put the config. list fields on two lines rather than just the one. This has been asked before, but all the answers I could find were tailored too specifically to each situation for me to pull out the solution I need.

    Thank you very much!

    Page URL:
    https://form.jotform.com/70265949185164

  • Profile Image

    Answered by CinderellaSunflower on January 29, 2017 at 10:19 PM

    UPDATE: this has been sort of resolved by making the width of the form essentially 100%, as well as increasing the width of the website it is embedded in. Still, if there are any answers, let me know, as this solution is not ideal.

  • Profile Image

    Answered by Ian on January 30, 2017 at 01:34 AM

    I'm afraid this can only be achieved manually.

    You can refer to the guide below to learn how to split text from a single cell to columns.

    https://support.office.com/en-us/article/Split-text-into-different-columns-with-the-Convert-Text-to-Columns-Wizard-30b14928-5550-41f5-97ca-7a3e9c363ed7?ui=en-US&rs=en-US&ad=US

    Video tutorial: https://youtu.be/8lkEH0IHE7Y

    I will still forward a feature request regarding this to our developers. However, I cannot give you any guarantee that this will be implemented soon since they will still need to check its feasibility. You will just be notified via this thread for updates if there are any.

  • Profile Image

    Answered by Ian on January 30, 2017 at 01:36 AM

    I'm afraid this can only be achieved manually.

    You can refer to the guide below to learn how to split text from a single cell to columns.

    https://support.office.com/en-us/article/Split-text-into-different-columns-with-the-Convert-Text-to-Columns-Wizard-30b14928-5550-41f5-97ca-7a3e9c363ed7?ui=en-US&rs=en-US&ad=US

    Video tutorial: https://youtu.be/8lkEH0IHE7Y

    I will still forward a feature request regarding this to our developers. However, I cannot give you any guarantee that this will be implemented soon since they will still need to check its feasibility. You will just be notified via this thread for updates if there are any.