Why Google Sheets Integration is not working?

  • Profile Image
    boomtowndesigns
    Asked on March 04, 2018 at 05:18 PM

    I integrated google sheets to my form and a spreadsheet was created but form submissions are not populating.

    Also, how do I make a new column for each product option instead of having all my t-shirt sizes in 1 cell?

  • Profile Image
    Nik_C
    Answered on March 05, 2018 at 02:49 AM

    I cloned your form and tested the Spreadsheet integration, but I wasn't able to replicate an issue.

    Regarding the product creating, please follow:

    1520236158screencast.gif

    Let us know if you have any further questions.

    Thank you!

  • Profile Image
    boomtowndesigns
    Answered on March 05, 2018 at 10:32 AM

    I wasnt able to get my form to populate in sheets so I cloned it and the cloned form worked!  I know how to create products, my question is how to get the product quantities to show in their own columns in google sheets which is the whole reason why I want to use sheets is to count the individual size quantities of shirts!  Thanks.

  • Profile Image
    ashwin_d
    Answered on March 05, 2018 at 11:49 AM

    Do you mean to say that you want to separate the data of your payment tool and display in the separate column of google spreadsheet?

    Unfortunately there is no built in feature to achieve your requirement but with a little workaround, it is possible to achieve your requirement. Here are the options available:

    #1. You can use regular form fields to list your product and the quantity of different sizes. You can then add "Form Calulation" widget to calculate the amount and pass the data to your payment tool. You may like to take a look at the following guide which should help you:

    https://www.jotform.com/help/259-How-to-Perform-Form-Calculation-Using-a-Widget

    https://www.jotform.com/help/275-How-to-Pass-a-Calculation-to-a-Payment-Field


    #2. You can yourself slit the data of payment field and display it in excel file. You may like ot take a look at the following guide which should help you:

    https://support.office.com/en-us/article/Split-text-into-different-columns-with-the-Convert-Text-to-Columns-Wizard-30b14928-5550-41f5-97ca-7a3e9c363ed7?ui=en-US&rs=en-US&ad=US


    Hope this helps. 

    Do get back to us if you have any questions.