Need help with integrating Google spreadsheet to my order form

  • abbyreid
    Asked on May 11, 2016 at 1:21 PM

    Ok I have tried the integrations for google spreadsheet, but it still doesn't seem to put it in "categories" so I can figure out what I am ordering - I am giving this one last shot- if you can help me,

    I need it to be able to tell me how many of each size i need to order

  • Kiran Support Team Lead
    Replied on May 11, 2016 at 1:42 PM

    I'm not sure if I understand your query correctly. Do you mean to display the products in separate columns in the spreadsheet? Please provide us with more information with your requirement so that we can guide you in the right direction.

    We will wait for your response. Thank you!  

  • abbyreid
    Replied on May 11, 2016 at 1:54 PM

    Yes, From the form- when I do a google form and look at the summary of responses it shows me a great pie chart that would show how many of what size I need- or if i do in spreadsheet it shows me this: and i can sum total the column for child medium, etc.

     

    Child medium leotard(6 responses)
    2
    2
    3
    3
    6
    1
  • Huberson
    Replied on May 11, 2016 at 2:43 PM

    If what you need is to have each options in the PayPal field in individual column in the Spreadsheet, I'm not sure it is possible. Because the payment block is regarded as a single field, its values is passed to a single column in the spreadsheet. 

    As an alternative, you can create the options field separately, then perform the calculation and pass the total to the PayPal field. 

    How-to-pass-a-calculation-to-a-payment-field