Collecting products and their properties within their own cells

  • ocalle
    Asked on February 3, 2016 at 8: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.

  • Ben
    Replied on February 3, 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

  • ocalle
    Replied on February 3, 2016 at 4:41 PM

    Thank you but the aligment is horizontal i need vertical.Collecting products and their properties within their own cells Image 1 Screenshot 20

  • Ben
    Replied on February 3, 2016 at 5: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.