What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Need help with integrating Google spreadsheet to my order form

    Asked by abbyreid 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

    Page URL:
    https://form.jotform.com/61265293899168

    size integrations in how
  • Profile Image
    JotForm Support

    Answered by Kiran 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

    Answered by abbyreid 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

    Answered by Huberson 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