Configurable List: Be able to separate data into different columns and cells when the form is integrated with Google Sheets

  • Profile Image
    asyavench
    Asked on November 27, 2021 at 07:15 AM

    Hello!

    My name is Anastasia, I am from Junior Academy of Sciences of Ukraine under the auspices of UNESCO international affairs department.


    We are currently working on the preparation of registration forms for the world's first national GENIUS Olympiad Ukraine.


    There was a problem creating the configurable list.  As a result of filling out the form, we get all the information from the completed list in one cell of google sheets.  I am attaching a screenshot.  Tell me, is it possible to configure it somehow?


    It would be very convenient for us if each school registered its projects together and we would see them in a separate format.


     Best regards,

     Anastasia Venchkovska,

     Specialist of the International affairs Department of the JASU

    Screenshot
  • Profile Image
    Gilbert_P
    Answered on November 27, 2021 at 07:57 AM

    Hello Anastasia,

    Unfortunately, the configurable list widget is read as only a single field hence the reason why all the data are listed into one cell on the integrated Google Sheets or Excel reports.

    However, I think that it indeed will be more convenient if the data are automatically separated into different cells. I'll forward this as a feature request to our back-end team for further review and consideration. We cannot guarantee if this will be implemented or provide an ETA but rest assured that you'll be notified here once we receive any updates from them.

    One workaround I could think of is to just manually copy the configurable list data that you will receive from the notification email and paste them into Google Sheet. They are displayed in table form so they should automatically be separated on different cells when you paste them into Google Sheets.

    1638016893_61a2277d0c517_

    After pasting to Google Sheets

    1638017527_61a229f72c7b3_

    Again, this is just a workaround. We'll be sure to notify you here once we receive word from our back-end team regarding this issue.

    Let us know if you have any other questions or concerns.

  • Profile Image
    asyavench
    Answered on November 27, 2021 at 08:33 AM
    Thanks for your response!
    But unfortunately it even doesn't work like this:
    ...