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

    Can I create a matrix with product options, i.e. size colour

    Asked by debbiecantley on January 11, 2016 at 04:39 AM

    I would like to use jotform as a data input form to create a csv file.

    We have clothing products with variations so a t shirt could come in 3 sizes and 5 colours

    When new stock arrives I want to be able to have both colours and size options as headers in the matrix (ideally the field names would be taken from a previous text box entry, i.e. available colours selected

    Is it possible to have the input type as text and enter the quantity.

    The output would then be a multi line excel csv file with each product option on a new line?

     

    Any help here would be really useful.

    Thanks

     

     

  • Profile Image
    JotForm Support

    Answered by beril on January 11, 2016 at 11:06 AM

    If you want to sell your products you can use our payment tools.

    Please, check the guide below for more information.

    http://www.jotform.com/help/165-Setting-Up-Your-First-Order-Form

    http://www.jotform.com/help/225-How-to-add-options-to-Payment-Forms

    If you want to use your form just for adding data input you can create matrix table as you see below:

    First of all, please, add matrix to your form and change row values.

    2) Change to column values.

     

    3) choose input type as text box.

    If you have any question or issues, please do not hesitate contacting us. We will be glad to assist you.

  • Profile Image

    Answered by debbiecantley on January 11, 2016 at 02:55 PM

    Thank you so much for your quick reply.  One more question... Is it possible to use the answer from another field as the row headings - i.e. product 1, product 2, product 3.  If there was a "COLOUR 1" text box/field with 'RED" as the answer, "COLOUR 2" with Green,  it would then dynamically insert Red as product 1, and so on....

    I know This may be a big ask, but would be incredibly useful.

  • Profile Image
    JotForm Support

    Answered by BDAVID on January 11, 2016 at 05:15 PM

    No, unfortunately it is not possible to accomplish what you need with our Form Builder.