When I integrate the forms with google Spreadsheet, how can I divide these fields: name of the "product", "quantity", "price" in different columns?

  • Profile Image
    Taurino
    Asked on December 18, 2020 at 04:05 AM

    When I integrate the forms with google Spreadsheet, how can I divide these fields: name of the "product", "quantity", "price" in different columns?

    Fabio

  • Profile Image
    Vick_W
    Answered on December 18, 2020 at 04:18 AM

    Hi Fabio,

    Unfortunately, you can not do that within the integrated Google Sheet. Product List is one field so all its contents will remain in one column. Separating them will also break the integration.

    However, if you move your data to Excel then there you should be able to separate them. Please check out this ticket for more details on the method and a demo video on how you can do it.

    https://www.jotform.com/answers/290516

    Let us know if you need further assistance.

    Thanks


  • Profile Image
    Taurino
    Answered on December 18, 2020 at 03:11 PM
    Hi, this is a big problem.
    I integrate with Google Sheet because it is itself automatically
    integrated with Shopify.
    I can't use Excel. Is there a different solution?
    If there is no solution, I will ask for a refund of the subscription.
    thanks
    Fabio
    Il 2020-12-18 10:18 Jotform ha scritto:
    ...
  • Profile Image
    Katherine_W
    Answered on December 18, 2020 at 04:58 PM

    Hi Fabio,

    Happy to help!

    I believe I may have a workaround for you, but please allow me some time to put it together for you and I will update you via this thread.

    I appreciate your patience as I put together a potential workaround for you.

  • Profile Image
    Taurino
    Answered on December 18, 2020 at 05:42 PM

    Hi Katherine, I hope you can find the solution soon. I will wait patiently.

    Thanks

  • Profile Image
    Taurino
    Answered on December 19, 2020 at 02:29 AM

    Hi, when I enter the data and confirm a Cash on delivery form, this message appears. How can I fix it?


    1608362960_5fddabd05bb1c_Schermata 2020-

  • Profile Image
    Vick_W
    Answered on December 19, 2020 at 02:34 AM

    Hi Fabio,

    I've created a separate ticket for your new questions. You'll receive a response to it shortly on the link below.

    https://www.jotform.com/answers/2776552

    Thanks

  • Profile Image
    Taurino
    Answered on December 19, 2020 at 08:42 AM

    Hi Vick, thanks I fixed.

    I look forward to solving the big problem of multi-column products as mentioned by Katherine.

    thanks a lot

    Fabio

  • Profile Image
    gerardw
    Answered on December 19, 2020 at 10:23 AM

    You may check this related thread when one of our colleagues has provided a workaround to split the details on your product field in a Google spreadsheet: https://www.jotform.com/answers/1333290-How-to-split-products-in-payment-settings-in-google-spreadsheet

    But, please note that you should not make these changes on the spreadsheet that you have linked to your form. Please export that data to a separate Excel file and then edit the requirements.

    You may use the IMPORTRANGE function on excel to transfer data from one spreadsheet to another: https://support.google.com/docs/answer/3093340?hl=en

    Meanwhile, I'll also follow up with our colleague, Katherine.

  • Profile Image
    Katherine_W
    Answered on December 19, 2020 at 06:16 PM

    Hi there,

    Thank you for your patience as I investigated a solution for you.

    My colleague has actually presented the exact workaround I was investigating and working on for you: have you had a chance to review the link my colleague sent and see if that is a viable workaround for you?

    We await your response.

  • Profile Image
    Taurino
    Answered on December 19, 2020 at 07:16 PM

    hi Katherine,

    it is not the ideal solution because I would have to intervene manually every time. I would like to use Zapier automatically without my manual intervention

    I'm afraid there are no solutions

    Thanks

  • Profile Image
    gerardw
    Answered on December 19, 2020 at 08:25 PM

    Hello.

    Sorry, but at the moment, we don't have another workaround.

    Please note that the product/payment field is a single field and its data will appear only inside one column in the Google spreadsheet - even if you download an excel submission file from your Form submission page.

    Apart from that, there is another alternative if you create/add products to the form outside the payment field. If you think that is viable, here is how you can do that (probably for future forms):

    With this method, you get the details in separate columns.

    Please review and let us know if this option would work out for you.