Collecting products and their properties within their own cells

  • Profile Image
    ocalle
    Asked 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.

  • Profile Image
    Ben
    Answered 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
    ocalle
    Answered on February 03, 2016 at 04:41 PM

    Thank you but the aligment is horizontal i need vertical.

  • Profile Image
    Ben
    Answered 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.