Configurable List: how to separate data into columns when integrated to Google Sheet

  • Profile Image
    kevin.f3c
    Asked on December 30, 2019 at 02:59 AM

    My form has a "Configurable list" segment with several fields in each line, and submitter can add as many lines as needed. I would like the resulting list to be exported into a google sheet with each list box in its own field in the sheet so that I can perform calculations on the list. Is this possible?

    Currently all list boxes are in one cell as text.



    This is a re-post of a comment on How to Integrate Forms with Google Sheets

  • Profile Image
    AndrewHag
    Answered on December 30, 2019 at 03:13 AM

    Unfortunately, when a Configurable list widget is used, the data will be exported to google sheet as a single field. So, it is not possible to display the data in different cells of google sheets.

    If you wish to display the data in different cells, I would suggest you use normal form fields instead of the configurable list widget.

    However, if you wish we can send a feature request to our backend team. But, we cannot assure you that this will be implemented or not. Please confirm so we can proceed.

  • Profile Image
    kevin.f3c
    Answered on December 30, 2019 at 03:43 PM

    So here is the need, which I felt the configurable list would best address: Submitter is asked for debt information, bank name, type of debt (select from list), current balance, minimum pmt, Current on payments? (Check), Paying extra? (check), Add next debt item below (same fields).
    Form type is one question at a time.
    How would one best do this with individual Q's to allow export to a sheet? 

    As to feature request, ABSOLUTELY!! This would be a natural way to import the field into a manageable spreadsheet in many situations! In fact, it seemed so natural I expected it to be possible.

    can you think of any way to make additional commas appear where the colon currently appears (between the field name and value entered)? This way I could just copy-paste the cell into a CSV import - PITA, but it should work.


  • Profile Image
    KrisLei
    Answered on December 30, 2019 at 05:41 PM

    Hi,

    I will escalate a feature request ticket on your behalf. 

    can you think of any way to make additional commas appear where the colon currently appears (between the field name and value entered)? This way I could just copy-paste the cell into a CSV import - PITA, but it should work.

    I'm not sure if I understand it correctly. However, I saw a thread with a workaround. For the meantime, you can create a Grid List report of the submissions, the data in the Configurable List widget will be separated into columns

    For your reference: How-to-Create-a-Grid-Listing-Report

    Then you can also use commas as a separator to make columns within Excel. Here's a complete guide in Excel: https://support.office.com/en-in/article/Split-text-into-different-cells-30b14928-5550-41f5-97ca-7a3e9c363ed7

  • Profile Image
    kevin.f3c
    Answered on December 30, 2019 at 06:05 PM

    I found a much easier method of accomplishing what I need. 

    From the email received upon submission, the data in the configurable list fields is presented as a table. I used copy/paste, highlighting/copying only the table from the email and pasting it into cell A1 of Excel sheet. There it is! I now can do what is needed.