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

  • Profile Image
    ZeshanHaider
    Asked on March 27, 2018 at 01: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.

  • Profile Image
    Welvin
    Answered on March 27, 2018 at 06: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.