Separate each infinite list field value into columns on Google Spreadsheet

  • Profile Image
    goenkahim
    Asked on October 05, 2017 at 05:25 AM

    I need help with your infinite list widget. When integrating my form with google spreadsheet, all entries made from the infinite list widget appears in a single cell which are comma and new line separated .

    I would like all separate entries to be shown in a different row and the under the header specified while incorporating the widget. 

    I am providing you the link to the spreadsheet. Kindly look at columns AK, AO for eg.

    How can i get this done?

    Your help will be highly appreciated.

    If this is not possible, kindly suggest an alternative.

  • Profile Image
    EltonCris
    Answered on October 05, 2017 at 08:36 AM

    That's not possible, unfortunately.

    We understand that the infinite list widget consists multiple fields but considering that it is grouped into a single field, they will be dumped into a single cell.

    I'm not sure if the following workaround will work on Google Spreadsheet but you can give it a try. https://www.jotform.com/answers/409905

    You can use a formula to separate the comma separated values into each column, but you will have to do this on a separate sheet to prevent the integration from breaking then use data reference to copy the data from the first sheet to another sheet.

    If you need further assistance, let us know.