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

    Collecting products and their properties within their own cells

    Asked by ocalle on February 03, 2016 at 08:08 AM

    I have this list

     

    Product                Quantity          Status

    One                        1                  White

    Two                       10                  Red

    Three                    12                  Blue

     

    Then in google spreadsheet in need arranged as 

    Product                Quantity          Status

    One                        1                  White

    Two                       10                  Red

    Three                    12                  Blue

     

    Waiting for one that do that, many thanks.

    quantity status product
  • Profile Image

    Answered by Ben on February 03, 2016 at 11:02 AM

    If you wish to have a data for each product and its properties within their own cells, then you would need to add a single field for each product, quantity and status.

    If you use widget, it will send the data to your Google Spreadsheet within the same cell since it is a single field (so to speak).

    For example (a quick example) can be seen here: https://form.jotform.com/60334254883962

  • Profile Image

    Answered by ocalle on February 03, 2016 at 04:41 PM

    Thank you but the aligment is horizontal i need vertical.

  • Profile Image

    Answered by Ben on February 03, 2016 at 05:54 PM

    Thank you for the screenshot. I believe that you are actually looking to have them each in its own row.

    For that, you would need to have 2 different submissions - to use 2 rows.

    So if you leave only one set of the input fields, it would be possible, but otherwise it would not be, since one submission can only take one row.