Need help with integrating Google spreadsheet to my order form

  • Profile Image
    abbyreid
    Asked on May 11, 2016 at 01: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

  • Profile Image
    Kiran
    Answered on May 11, 2016 at 01: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!  

  • Profile Image
    abbyreid
    Answered on May 11, 2016 at 01: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
  • Profile Image
    Huberson
    Answered on May 11, 2016 at 02: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