Splitting fields in google sheets integration

  • admin_Admin_admin294
    Asked on April 8, 2023 at 2:11 PM

    I'm deciding whether to use Jotform but product list and have read all the requests for this but it still shows the submission in one field in the google sheets integration. All the "workarounds" require the "coding" I'm trying to avoid so that my assistant can create a form without all these additional tasks.

    Is Jotform working on this as an option during integration ?

    I need to know before putting this to use.

    Thank you


  • Mary JotForm Support
    Replied on April 8, 2023 at 10:41 PM

    Hi admin_Admin_admin294,

    Thanks for reaching out to Jotform Support. I'm afraid the products list field is still considered a single field and this is the reason why it is showing in a single cell in the Google Sheet integration. As a workaround, you can create a second sheet and use the IMPORTRANGE feature of Google Sheets. Once you have imported the value from Sheet 1 into Sheet 2, you can try using the Split Text feature of Google Sheets.

    I am unable to confirm if this will be added as an additional feature in the future. I still went ahead and escalated this as a feature request to our Developers. But when or if it's developed depends on their workload, how viable it is, and how many other users also request it. If there are any updates, we’ll circle back to this thread and let you know.

    Let us know if you have any other questions.