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

    Matrix Question

    Asked by rsleavengood on March 21, 2012 at 07:06 PM

    Hello,

    I am using the Matrix function as an Order Form.  Is there a way to only display the cells that contain a value?  When I receive submissions (orders) all of the options are listed.  I'd like to only see the cells that contain a value. Please see my screen shot and URL!

    Many thanks,

    Sabrina

    Page URL:
    http://www.jotform.com/?formID=20241537935

    Screenshot
  • Profile Image

    Answered by jeanettebmz on March 21, 2012 at 08:51 PM

    Hi, you can get that accomplished by selecting only the form fields (from the right hand side) you need in your email notification settings.


    If you need further assistance, let us know

    Jeanette

  • Profile Image

    Answered by rsleavengood on March 22, 2012 at 11:41 AM

    Hi Jeanette,

    Thank you for your reply.  I know how to select the form fields.  However, I only want to display the form fields that the customer assigns a value to.  Is that possible? 

     

    I think it would make sense if you looked at my form and how I am using the Matrix.  We have over 150 choices and usually a handful are chosen.  But I still see all 150 choices with a "-" in the answer field. 

    Thank you!

    Sabrina

  • Profile Image

    Answered by jeanettebmz on March 22, 2012 at 02:06 PM

    I think you might resolve this issue by setting "HIde empty fields" on the submissions view

     

    I have already set that on your form, tell me if it works

    Jeanette

  • Profile Image

    Answered by rsleavengood on March 22, 2012 at 02:52 PM

    The Auto Hide works for the Fields in the form, but not the cells/fields within the Matrix.  So if the email was empty, it would hide that field. 

     

    I'm just trying to hide the empty fields within the Matrix. Any ideas?

     

    Thanks again!

    Sabrina

  • Profile Image

    Answered by jeanettebmz on March 22, 2012 at 04:56 PM

    Ok, so in other words, what you need is to hide empty fields into the matrix not on the submissions , correct?

    I think using conditional might work in some way, but unfortunately, as far as I know , this feature only works with fields, not with Cells/rows into a matrix.

    You can set if Any of the conditions works, then , hide certain fields. As shown below:


    Like I said, sadly this doesn't work for Cells into a matrix, just for fields.


  • Profile Image

    Answered by rsleavengood on March 22, 2012 at 05:31 PM

    Yes Jeanette, that is what I'd like to do.  I thought there might be a workaround or some formula I could use. 

  • Profile Image

    Answered by jeanettebmz on March 22, 2012 at 06:44 PM

    @ rsleavengood

    Unfortunately, when it comes to cells within a matrix, there are not such  options