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

    Configurable List: Split fields in the downloadable spreadsheets

    Asked by terrywells on December 22, 2015 at 03:38 AM
    Also the Configurable List widget was exactly what I was looking for but can the fields be split (as in the email response) in the downloadable spreadsheets?
  • Profile Image
    JotForm Support

    Answered by Chriistian on December 22, 2015 at 04:04 AM

    Hi,

     

    Unfortunately, it is not currently possible to split the fields for the configurable list widget in the spreadsheet. We currently do not have a way to do this in JotForm. 

     

    Do let us know if you need further assistance.
    Regards.

  • Profile Image

    Answered by terrywells on December 22, 2015 at 12:13 PM

    Thanks Chriistian, I can probably work out something, however, as they are split in the notification email I am wondering if there is a way of translating this into a web post. I suspect may be beyond my skills though!

    Thanks

    Terry

  • Profile Image
    JotForm Support

    Answered by Boris on December 22, 2015 at 01:40 PM

    On behalf of my colleague, Christian, you are most welcome.

    I am not sure if I understood the part about translating it into a web post, Terry. If you are asking about taking data from the email notification and passing it along to be presented on a web page, that may require hiring a developer to custom code a solution for this, in order to parse the emails and post them to your website.

    Now looking back to the title of this thread, if you are simply looking for a way to have your data downloaded as Excel spreadsheets, you can certainly download your submissions in CSV or Excel format. Or you can set up an Excel report to be generated automatically for you.

    Once you have your submissions in Excel format, data from the Configurable List widget can be split into multiple columns by using the Data > Text to Column function in your spreadsheet software, such as Microsoft Office or Libre Office:

    https://support.office.com/en-us/article/Split-text-into-different-cells-30b14928-5550-41f5-97ca-7a3e9c363ed7

    I hope this helps. If you need assistance with anything else, please don't hesitate to open a new thread about it, and as always, we'll do our best to help.

  • Profile Image

    Answered by terrywells on December 22, 2015 at 02:34 PM

    Thank you Boris, yes passing the data to a web page is what I was thinking of but the club chairman seems happy with results being shown as the HTML Table Listing I will leave as is, at least for the moment.

    Thank you also for pointing me to DATA > TEXT to COLUMN, I knew I had seen how to do it somewhere.

  • Profile Image
    JotForm Support

    Answered by BJoanna on December 22, 2015 at 03:41 PM

    On behalf of my colleagues, you are welcome.

    Feel free to contact us if you have any other questions.