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

    Infinite List: Have multiple fields in separate cells in Excel sheet

    Asked by dmichaels on April 24, 2017 at 05:15 PM

    I'm having a similar issue with the Infinite List widget. If we, for example, have 3 columns, Name, Phone, Email and the user enters 20 lines of data, it's pretty obvious that a report, whether it be Excel, CSV or whatever, should be formatted in such a manner that the names are in one column, the Phone numbers in another and the Email in a third.

    Similarly, the native JotForm Input Table has the same shortcoming.

    I feel like we've somehow missed the point in how data should be formatted in a usable manner.

    I should note that the E-mail message comes through looking just perfect. Rows and columns of data, laid out as we'd expect, with a column of names, a column of addresses, etc.

    Is there another tool that works as I've described?

    As I'm thinking about this, what I'm describing would break with the "One Form / One Record" model. Each form submitted would need to be appended to the previous results.

    As a temporary work-around, I've built a Excel worksheet that can transform the JotForm generated Excel report and move the columns around as needed, but it's clumsy and not terribly elegant.

    Any thoughts?

    Thanks,

    David

  • Profile Image
    JotForm Support

    Answered by Nik_C on April 24, 2017 at 05:25 PM

    Your observation is correct, information entered in Infinite list, Input table, or any other multi-field field will take only one cell in Excel spreadsheet. And that's because how our integration with Spreadsheet. Meaning every field from the form will have one cell in Excel spreadsheet. And since Input table, infinite list, configurable list are one field and they are presented in the sheet in that way. 

    One "solution" is what you're doing already in the Excel.

    We can submit this as a potential feature implementation if you wish, so it might be implemented in future.

    Please let us know.

     

  • Profile Image

    Answered by dmichaels on April 24, 2017 at 10:23 PM

    That would be great.

    Thank you.

  • Profile Image
    JotForm Support

    Answered by Nik_C on April 25, 2017 at 02:22 AM

    Thank you for getting back to us.

    I forwarded this thread to our backend team for a possible implementation. 

    We will inform you once/if this feature is implemented.

    Thank you!