-
ZeshanHaiderAsked 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.
Page URL: https://form.jotform.com/61084275252958 -
Welvin Support Team LeadReplied 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.