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

  • Profile Image
    dmichaels
    Asked 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
    Nik_C
    Answered 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
    dmichaels
    Answered on April 24, 2017 at 10:23 PM

    That would be great.

    Thank you.

  • Profile Image
    Nik_C
    Answered 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!