I am using Configurable List widget becauae I want the user to decide himself how many guests he wants to add. I have integrated my jotform with Googl

  • ZeshanHaider
    Asked on March 27, 2018 at 1:22 AM

    I am using Configurable List widget becauae I need the user to decide himself how many guests he wants to add. I have integrated my jotform with Google Sheets. Now I am trying to make sure that the name, email, phone are sent to the integrated google sheet, but in separate columns. Currently they are all in the same column and hard to sort, please help, thank you.

  • Welvin Support Team Lead
    Replied on March 27, 2018 at 6:38 AM

    Yes, that's how the configurable list widget dumps the data in the spreadsheet file. The only workaround you can try would be to use Text to Columns function; https://support.google.com/docs/answer/6325535?co=GENIE.Platform%3DDesktop&hl=en. Please try this, and let us know if you need further assistance.

    I'll also try to give you the steps to do it.