Matrix Question

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

  • Profile Image
    jeanettebmz
    Answered 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
    rsleavengood
    Answered 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
    jeanettebmz
    Answered 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
    rsleavengood
    Answered 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
    jeanettebmz
    Answered 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
    rsleavengood
    Answered 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
    jeanettebmz
    Answered on March 22, 2012 at 06:44 PM

    @ rsleavengood

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