Separate each infinite list field value into columns on Google Spreadsheet

  • goenkahim
    Asked on October 5, 2017 at 5: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.

  • Elton Support Team Lead
    Replied on October 5, 2017 at 8: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.

    Separate each infinite list field value into columns on Google Spreadsheet Image 1 Screenshot 20

    If you need further assistance, let us know.