Configurable List: Split fields in the downloadable spreadsheets

  • terrywells
    Asked on December 22, 2015 at 3: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?
  • Chriistian Jotform Support
    Replied on December 22, 2015 at 4: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.

  • terrywells
    Replied 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

  • Boris
    Replied on December 22, 2015 at 1: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.

  • terrywells
    Replied on December 22, 2015 at 2: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.

  • BJoanna
    Replied on December 22, 2015 at 3:41 PM

    On behalf of my colleagues, you are welcome.

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